Shulou(Shulou.com)06/01 Report--

Rac expdp exported Times error:

ORA-31693: Table data object "scott". "dept" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/ home/oraclerac/dump_dir/oravs_expdp_05.dmp" for write

ORA-19505: failed to identify file "/ home/oraclerac/dump_dir/oravs_expdp_05.dmp"

ORA-27037: unable to obtain file status

Cause of error:

In the RAC environment, if the PARALLEL parameter setting is greater than 1, the process will export on each node of the RAC, and an error will be reported if the export directory is not shared.

Solution:

1. Set as shared directory

2. Add the cluster=n option to the export statement to specify that it will be exported locally only

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.