Amazon books

Saturday, November 6, 2010

EXPDP ORA-39002 ORA-39070 ORA-29283 ORA-06512 ORA-29283 LOGFILE

If experiencing this error below when trying to export using EXPDP:

############################################
[oraebs@hom1 bkp_old_hml]$ expdp system/xxxxxxx dumpfile=expdir:exp_hml_%U.dmp filesize=3G logfile=log_exp_hml.log FULL=Y

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 06 November, 2010 16:42:42

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation
############################################

Just change the sintaxe to use the directory name together in LOGFILE parameter as below:

expdp system/xxxxxx directory=expdir dumpfile=expdir:exp_hml_%U.dmp filesize=3G logfile=expdir:log_exp_hml.log FULL=Y



Best Regards,
Paulo Portugal

No comments:

Post a Comment