-
Export hangs forever!
when i run export manually as user system it hangs indefinitely:
About to export the entire database ...
. exporting tablespace definitions
.
.
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions_
I have to abort the export every time, tried couple of times. this is on Win2000 oracle 9i R2.
thanks in advance.
"What is past is PROLOGUE"
-
After aborting the export, did the import work?
Tamil
-
"What is past is PROLOGUE"
-
have you traced the session to see what it is waiting on?
-
Originally Posted by davey23uk
have you traced the session to see what it is waiting on?
How do you set trace for the export session?
"What is past is PROLOGUE"
-
the same as other session, it has a session id in v$session, use that
-
Originally Posted by dbasan
No.
Can you post your exp command here?
Tamil
-
Originally Posted by tamilselvan
Can you post your exp command here?
Tamil
exp system@report file=e:\..\..\exp.dmp log=e:\..\..\exp.log full=y
"What is past is PROLOGUE"
-
you can use trace=y as export parameter to enable sql_trace
-
Originally Posted by pando
you can use trace=y as export parameter to enable sql_trace
In which version of Oracle exp this is available?
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|