Return
-
Title
LiveReorg on huge table fails with ORA-39059: dump file set is incomplete -
Description
Import is failing while doing Reorg on huge size tables with
"ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files"
-
Cause
This is due to the limit (99) set by the Oracle on the number of export/import dump files.
-
Resolution
Increase the dump file size in the Reorg window by selecting the option 'size of the file' before triggering/running the Reorg script.
Note: Make sure that the number of files count falls under 99 when divided the whole export dump size with the size of the file .