Recent content by THoey

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')...