Export hangs forever! - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Export hangs forever!

  1. #11
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  2. #12
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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"

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Quote Originally Posted by dbasan
    In which version of Oracle exp this is available?

    8.1.6

  4. #14
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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"

  5. #15
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sql_trace => udump

  6. #16
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote 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
  •  



Click Here to Expand Forum to Full Width