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