DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: import failed

  1. #11
    Join Date
    Dec 2000
    Posts
    21

    LND: You are right! It also shuts down the database whe 311
    error occurs. What is patch name for this oracle bug?

    tamslselvan: Sorry the dump file size is 4G not 400G.






  2. #12
    Join Date
    Nov 2000
    Posts
    212
    anyway, what is in Oracle log and trace files? If you are allowed, post relevant data from logs, it will be much clearer what is going on.
    Do it that way: backup and then delete old log/trace files,
    do import to get the failure and look what in the logs.

  3. #13
    Join Date
    Nov 2000
    Posts
    212
    as far I as can find 806 has two patch sets:
    8.0.6.1 and 8.0.6.2
    The are quite a set of 3113 errors related to import. Usual workarrounds are:

    to cancel import of some objects. For example:
    grants=no
    indexes=no
    constraints=no
    recalculate_statistics=YES/NO for import and statistics for export

    Some errors are related to tables with LOB columns, partitioned tables, views.

    If import runs OK, then you can try to import some objects after. Those are constraints, indexes, grants, statistics.
    If you now that particular object is causing problems, then can drop it before full export.





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