Error:
ORA-31693: Table data object ""."" failed to load/unload and is being skipped due to error:
Reason:
The error is showing due to the backup dump file is not accessible from the the second node in the RAC
Solution:
Following example will help to resolve the issue.
expdp username/passwd tables=schema.table dumpfile=backup.dmp logfile=backup.log cluster=N
or
Shutdown Database on second node and execute the following command
expdp username/passwd tables=schema.table dumpfile=backup.dmp logfile=backup.lo
ORA-31693: Table data object "
Reason:
The error is showing due to the backup dump file is not accessible from the the second node in the RAC
Solution:
Following example will help to resolve the issue.
expdp username/passwd tables=schema.table dumpfile=backup.dmp logfile=backup.log cluster=N
or
Shutdown Database on second node and execute the following command
expdp username/passwd tables=schema.table dumpfile=backup.dmp logfile=backup.lo
No comments:
Post a Comment