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.UTL_FILE", line 536 ORA-29283: invalid file operation
I have created directory 'Mydir' as below
SQL>CREATE 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 directory_name, directory_path from dba_directories; where directory_name='Mydir';
I can see the path 'C:\Users\osman\Desktop\Export'
So why am I getting this error?