Ora-29283 Invalid File Operation Windows
Invalid Operation Error
Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7. ORA-29283: invalid file operation ORA. ' can't create any direcotry on Windows.
I am using Oracle 11g and want to export a table using below statement C: expdp SYS/sys@MYDATABASE DIRECTORY = Mydir DUMPFILE = Customer.dmp LOGFILE = Customer.log TABLES = PERSON.CUSTOMER After this statement cmd is giving this UDE-28009: operation generated ORACLE error 28009 ORA-28009: connection as SYS should be as SYSDBA or SYSOPER I proceeded with Username: SYS@SMSPSETUP AS SYSDBA Password: And finally I got ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at 'SYS.UTLFILE', line 536 ORA-29283: invalid file operation I have created directory 'Mydir' as below SQLCREATE DIRECTORY Mydir AS 'C: Users osman Desktop Export'; And gave everyone full privileges to this folder from the windows folder system. When run the below statement: select directoryname, directorypath from dbadirectories; where directoryname='Mydir'; I can see the path 'C: Users osman Desktop Export' So why am I getting this error? Firstly, the oracle docs are VERY clear that you shouldn't use data pump as SYS:: Do not invoke Export as SYSDBA, except at the request of Oracle technical support The problem will almost certainly be permissions related. The user that is running the Oracle database is the user that attempts to write to the file, so check that user can write to the folder in question (and can access it through all the parent folders). Perhaps create a folder in the root of a drive (e.g.
'E: TestExport' or similar) so that you have fewer parent folders to worry about, then use this within Oracle to determine if this is the case.
