ORA-39002: invalid operation ORA-39070: Unable to open the log file. Log your putty session into text files - Duration. ORA-01017: invalid username/password; logon denied - Duration. ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at “SYS.UTLFILE”, ORA-29283: invalid file operation When doing export occur above error, let’s check directories.
I have always been making use of Oracle 11g and wish to move a table using beneath statement
After this statement cmd will be giving this
I proceeded with
And finally I got
I have got created listing 'Mydir' as below
And provided everyone complete privileges to this folder from the windows folder program.
When operate the below statement:
I can observe the path 'C:UsersosmanDesktopExport'
So why have always been I getting this mistake?
osmanosman28333 gold badges77 sterling silver badges1515 bronze badges
6 Answers
I simply needed to chime in and share what obtained me past this mistake. In my case (Ora 11.2.0.3 on Gain 7) I found I needed the walking ' in my index path.
Replaced:
With:
KenKen
First of all, the oracle docs are Quite very clear that you shouldn't use data send as SYS:
http://docs.oracle.com/cd/E1188201/server.112/e22490/dpexport.htm#SUTIL824:
Perform not invoke Export as SYSDBA, except at the request of Oracle technical assistance
The issue will almost certainly become permissions related. The consumer that is usually operating the Oracle database is definitely the user that efforts to create to the file, so check out that consumer can compose to the folder in issue (and can access it through all the parent folders).
Possibly generate a folder in the basic of a get (at the.h. 'E:TestExport' or very similar) therefore that you have got fewer parent files to get worried about, then make use of this within Oracle to determine if this will be the situation.
Phil SumnerPhil Sumner
check out the file permissions because the export is performed by oracle consumer whereas the directory site belongs to osman user
Cyryl1972Cyryl1972
Yeah, I discovered the solution. It is certainly because my oracle data source is located on another pc on the system. So, when I test to export to like 'c:' listing, oracle will be attempting to export to its very own Chemical: directory website not mine.
I utilized network tackle of the folder as move website directory and the issue was solved.Make use of for instance
osmanosman28333 silver badges77 magic badges1515 bronze badges
oracle SQL statement 'CREATE Directory website Mydir AS 'Chemical:UsersosmanDesktopExport';' can't make any direcotry on Windows or Linux, it's simply a mapping between variable Mydir and index 'C:UsersosamnDesktopExport'
so you require to create certain your home windows provides 'C:UsersosmanDesktopExport'
hope this can assist you !
LawrenceLiLawrenceLi
in inclusion to the above, you may furthermore encounter the using (on windows) :
- Move to services.
- Search for 'OracleService'
- Best Mouse Click -gt; qualities -gt; Sign On (Tab)
- Switch this account (current user name) -gt; to a even more fortunate one (of program you can change the present user privileges as properly)
- Reboot the assistance and it should work.
Etay GudaiEtay Gudai
Not the answer you're also looking for? Search other queries labeled oracleoracle-11gexport or consult your own question.
I am making use of Oracle 11g and would like to export a table using beneath declaration
After this declaration cmd can be offering this
I proceeded with
And finally I obtained
I have created directory website 'Mydir' as below
And provided everyone complete benefits to this folder from the home windows folder system.
When operate the below declaration:
I can discover the route 'C:UsersosmanDesktopExport'
So why was I getting this mistake?
osmanosman28333 yellow metal badges77 gold badges1515 bronze badges
6 Answers
I just wished to chime in and share what got me past this error. In my situation (Ora 11.2.0.3 on Gain 7) I discovered I needed the walking ' in my directory site path.
Replaced:
With:
KenKen
Firstly, the oracle docs are Extremely obvious that you shouldn't make use of data tube as SYS:
http://docs.oracle.com/cd/E1188201/server.112/e22490/dpexport.htm#SUTIL824:
Perform not really invoke Move as SYSDBA, except at the request of Oracle technical assistance
The issue will nearly certainly become permissions related. The consumer that is working the Oracle database will be the user that attempts to write to the document, so verify that consumer can create to the folder in question (and can access it through all the parent folders).
Perhaps make a folder in the root of a travel (age.h. 'E:TestExport' or identical) so that you have got fewer parent files to get worried about, after that use this within Oracle to figure out if this is the case.
Phil SumnerPhil Sumner
check the document permissions because the move is completed by oracle user whereas the directory is supposed to be to osman consumer
Cyryl1972Cyryl1972
Yeah, I discovered the alternative. It can be because my oracle database is situated on another computer on the system. Therefore, when I try to export to like 'chemical:' index, oracle is certainly attempting to move to its personal D: directory site not mine.
I utilized network address of the folder as export website directory and the issue was resolved.Make use of for instance
osmanosman28333 magic badges77 gold badges1515 bronze badges
oracle SQL statement 'CREATE Directory site Mydir AS 'D:UsersosmanDesktopExport';' can't make any direcotry on Home windows or Linux, it's simply a mapping between variable Mydir and website directory 'C:UsersosamnDesktopExport'
so you require to make sure your windows has 'C:UsersosmanDesktopExport'
wish this can assist you !
LawrenceLiLawrenceLi
in addition to the over, you may furthermore encounter the using (on windows) :
- Go to services.
- Search for 'OracleService'
- Best Mouse Click -gt; attributes -gt; Record On (Tabs)
- Transformation this account (current user title) -gt; to a even more privileged one (of course you can change the current user liberties as nicely)
- Reboot the assistance and it should function.
Etay GudaiEtay Gudai