Search results for query: *

Hi all... My job has recently moved me from a salaried position to an hourly position and we are already running into issues bumping against my "schedule". I am trying to gather information to take back to my management to show that it really isn't in their best interest to have me on a...

Did a search in help and found the locks tab in the Session Browser. Thanks again Dave. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to...

Actually, I do have access to it, just haven't got used to using it. So many things you can do there that I get a little lost. If you can point me in the right direction that would help. I think I would still want a query eventually as some of my offshore team does not have access to...

SantaMufasa had a great reply to thread759-1363380. I am needing to take it a little further and see the query that is actually causing the lock. Is there a way to do that? Terry ************************** * General Disclaimer - Please read * ************************** Please make...

Thanks. All clean now. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This...

All, been trying to clean up a PC. Was getting the following error: Generic Host Process for Win32 Services has encountered a problem and needs to close. I ran Spybot, Adaware and SuperAntiSpyware and cleaned anything I found. Ran Norton's and it said it was clean. Then I ran Kaspersky's and...

Just a follow up. I was able to grant unlimited quota to that tablespace and then the import performs without an issue. Just weird that only the tables with CLOB fields try to write to a specific tablespace and the rest write to the default tablespace for the schema. Thanks again. Terry...

Thanks for following up. Unfortunately, I will be unable to let it run through just to test the import. We finished our deployment to that server on Friday and it is in use now. I'yy try to do it when we have our next deployment. Thanks again. Terry ************************** * General...

Maybe I am misunderstanding, but shouldn't it try to load to the default tablespace of the new schema it is being loaded into? That being asked, all of the tables in the export (82) are stored in the SMFDATA schema of the exported instance, but only these three tables fail creation when...

Yeah, that is the major issue. I am trying to figure out why the import is trying to use a tablespace besides the default. I ended up letting it run and then recreating the tables via scripts, but it was just a question I had. Luckily, right now those tables are empty. Next time we do...

To me the issue is that due to them having LOB's, they are trying to write to a different tablespace than the default that I want it to. All the other tables get created in the default tablespace fine. Below is the log: Connected to: Oracle Database 10g Enterprise Edition Release...

Are there any known issues with exporting LOB tables? I did an export from database A, schema A. Then did an import of that data into database B, schema B. The import generates warnings as it is trying to create three of the 82 tables in a particular tablespace instead of the default user...

Bill, Engi and Dave, Thanks so much. As I said, this was just one example of a case where I needed to do something like this, so it was a learning process. I appreciate everone's input as it all helped to end up with the final result. Code: set define off; spool C:\test.sql; set...

Okay, we are getting close. The below result snippet is just the end of what was generated: insert into test2 select * from test where trunc(call_date) = to_date('25-jun-2007','dd-mon-yyyy') insert into test2 select * from test where trunc(call_date) = to_date('25-jun-2007','dd-mon-yyyy')...

Duh... I guess it might help to know what the errors are. With the above script, I get the following error: spool off; * ERROR at line 15: ORA-06550: line 15, column 1: PLS-00103: Encountered the symbol "SPOOL" If I comment out the SPOOL commands, the procedure runs, but I get no output...

Sorry Bill, I think you are missing the question. There are too many records in this table to move them over at once like you describe. So I am wanting to learn how to write a script that will go through a large table and create a set of "move and commit" scripts so that I don't blow any...

Sorry for the late response. Thanks Engi. I will give this a try and post a response if it does what I am looking for. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive...

Thanks for responding. In this instance it would be run on an adhoc basis. But really, I am just wanting to learn how to do this for any adhoc instance. So, in this case, for every grouping of trunc(date) data in the table, I want to move the data, and commit it. An example would be I...

I have gotten pretty good at writing SQL that generates other SQL. But try as I might, I can't figure out how to add this twist to it. I have a call history table that has a record with data for each call into our system. I need to move this data from one schema to another in. Since...