-
The only time I ever had an export hang on me was when there was a problem with disk space.
On Windoze, I have my .DMP files limited to <4 gigs cause winzip has a problem with files over 4 gigs.
Once I ran out of file names by doing the following...
FILESIZE=3900M
FILE=D:\blah\dump1.dmp, D:\blah\dump2.dmp
When dump2.dmp hit 3900M, the export hung.
You may want to check disk space or quotas on the dir that you are in.
Hope this helps.
I remember when this place was cool.
-
found the problem in
About to export the entire database ...
. exporting tablespace definitions
.
.
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
exporting system procedural objects and actions, when export starts it hangs at this point and it took an hour to automatically close the export with errors. Due to impatient i aborted the export after 15mins.
I found few system/user objects were invalid and had to run utlrp.sql to recompile and then the export ran well.
thanks for the time DBA's
"What is past is PROLOGUE"
-
Originally Posted by dbasan
In which version of Oracle exp this is available?
8.1.6
-
Pando
I could not find the parameter in
exp help=y
nor in Oracle doc 8.1.6, utility>export parameters?
when i use:
exp system@report file=e:\..\..\exp.dmp log=e:\..\..\exp.log full=y trace=y
where exactly is the trace of this export process written?
"What is past is PROLOGUE"
-
-
Originally Posted by pando
sql_trace => udump
Thanks Pando the genious
It worked!!! this would really help other dba's, Oracle has not documented this short cut method.
"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
|