Home » RDBMS Server » Server Utilities » Error while Exporting data (DB : 10.2.0.1.0 OS: WIN 2003 server SP 2)
Error while Exporting data [message #424774] Mon, 05 October 2009 23:44 Go to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi All,

While exporting data from database, i am getting an error msg " EXP-00002: error in writing to export file ". i checked the alert log file and found that an error msg "ORA-01031: insufficient privileges". i am using DB :10.2.0.1.0 and OS: WIN 2003 server SP 2.

Syntax:

exp system/password@CPORA file=\\srvmumftp\AECOM\Consulting_Project_Backups\INDUS_NEW\CPORA.dmp log=\\srvmumftp\AECOM\Consulting_Project_Backups\INDUS_NEW\CPORA.txt owner=DELTEK

Error in Alert:

Errors in file d:\oracle\product\10.2.0\admin\cpora\bdump\cpora_j000_3304.trc:
ORA-12012: error on auto execute of job 102
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

Please check and suggest.

Thank you,
Vish
Re: Error while Exporting data [message #424782 is a reply to message #424774] Tue, 06 October 2009 00:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your post is not consistent.
The export cannot generate a trace file that comes from a job.
Post export log file.

By the way, Oracle does not support UNC for many of these tools/versions. Check if it is allowed for your version.
If it is, then the user or Oracle instance owner (depending on how you launch the export) should a network user with appropriate privileges on network.

Regards
Michel

[Updated on: Tue, 06 October 2009 00:29]

Report message to a moderator

Re: Error while Exporting data [message #424828 is a reply to message #424782] Tue, 06 October 2009 03:01 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi Michel,

Thanks for reply.

Actually, i am using Schedule task from Windows to run the export batch file. i have manually excecuted batch file and got completed without errors. Please check the attached old Export log file.

The user having proper privileges on network.

Please suggest.

Thank you,
Vish

  • Attachment: CPORA.txt
    (Size: 81.38KB, Downloaded 992 times)
Re: Error while Exporting data [message #424836 is a reply to message #424828] Tue, 06 October 2009 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i am using Schedule task from Windows to run the export batch file. i have manually excecuted batch file and got completed without errors.

Is the same user from scheduler and manual execution?

Regards
Michel
Re: Error while Exporting data [message #424843 is a reply to message #424836] Tue, 06 October 2009 03:54 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Yes, using the same user for both.

Regards,
Vish
Re: Error while Exporting data [message #424848 is a reply to message #424843] Tue, 06 October 2009 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure?
Which user? (I mean network privileges) The user in "Run as" in "Task" tab on schedule tasks panel.
What is the owner of the instance? (What are its network privileges)?
Also as I said, many Oracle tools do not support UNC.

Regards
Michel
Re: Error while Exporting data [message #426409 is a reply to message #424774] Thu, 15 October 2009 05:33 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hello Michel,

Sorry for late reply.i was out of town.

i added a user in ADMINISTRATOR group who have complete and unrestricted access to the computer/domain. Now daily scheduled batch file is works without any issue.


Regards,
Vishal

Re: Error while Exporting data [message #426414 is a reply to message #426409] Thu, 15 October 2009 05:42 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: how to expdp to find out the table size/row without the data
Next Topic: Import errors
Goto Forum:
  


Current Time: Fri Dec 09 08:09:39 CST 2016

Total time taken to generate the page: 0.07431 seconds