Ora-29283:invalid file operation error occurred while performing EXPDP operation
sql> Create or replace directory Dumpdir 2 as '/home/oracle/testdump/';
Directory created.
$ cat test.sh Date EXPDP test/test@tstdb dumpfile=test_onetable.dmp directory=dumpdir tables=table1 logfile=n job_name= Exptab parallel=4 Date $
$ . /home/oracle/test.sh Fri Nov 11:20:35 EAT 2006
Export:release 10.2.0.1.0-64bit Production on Friday, November, 2006 11:20:35
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production with the partitioning, OLAP and Data Mining 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 475 ora-29283:invalid FILE operation
Fri 11:20:43 EAT 2006
Search on the internet for half a day, still posted on the itpub, half a day did not find a solution, had to decide to check their own again, the results found to be the following reasons:
sql> Create or replace directory Dumpdir 2 as '/home/oracle/testdump/';
Directory created.
Sql> host Ls/home/oracle/testdump/home/oracle/testdump not found
After creating the folder/home/oracle/testdump, as above test.sh can run correctly:
$ mkdir testdump $. /home/oracle/test.sh Fri Nov 15:06:47 EAT 2006
Export:release 10.2.0.1.0-64bit Production on Friday, November, 2006 15:06:47
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production with the partitioning, OLAP and Data Mining Options starting "Test". " Exptab ": test/******** @tstdb dumpfile=test_onetable.dmp directory=dumpdir tables=product_attr_i_p_l logfile= Test.log Job_name=exptab parallel=4 Estimate in progress using BLOCKS method ... Processing object type Table_export/table/table_data total estimation using BLOCKS method:80 MB processing Object Type TA Ble_export/table/table Processing Object Type Table_export/table/grant/owner_grant/object_grant Processing object Type Table_export/table/index/index Processing Object type Table_export/table/constraint/constraint Processing object Type Table_export/table/index/statistics/index_statistics processing Object type Table_export/table/comment Processing object Type Table_export/table/statistics/table_statistics. . Exported "test". " product_attr_i_p_l "            &Nbsp; 66.67 MB 1937788 rows Master table "test". " Exptab "Successfully loaded/unloaded **************************************************************************** * * Dump file set for test. Exptab is: /home/oracle/testdump/test_onetable.dmp Job "test". " Exptab "successfully completed at 15:07:19
Fri 15:07:22 EAT 2006 $
After you delete the folder/home/oracle/testdump, run the test.sh error recurrence: $ rmdir testdump
$ ls testdump testdump not found
$ . /home/oracle/test.sh Fri Nov 14:59:00 EAT 2006
Export:release 10.2.0.1.0-64bit Production on Friday, November, 2006 14:59:00
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production with the partitioning, OLAP and Data Mining 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 475 ora-29283:invalid FILE operation
As you can see, when you create a directory in Sqlplus, Oracle does not check that the referenced operating system folder already exists and should be examined carefully.