|
-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|