OraFAQ Forum: Server Utilities » Error while Exporting data

Home » RDBMS Server » Server Utilities » Error while Exporting data (DB : 10.2.0.1.0 OS: WIN 2003 server SP 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while Exporting data [message #424774]

Mon, 05 October 2009 23:44

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

Report message to a moderator

Re: Error while Exporting data [message #424782 is a reply to message #424774]

Tue, 06 October 2009 00:25

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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 2344 times)

Report message to a moderator

Re: Error while Exporting data [message #424836 is a reply to message #424828]

Tue, 06 October 2009 03:32

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Error while Exporting data [message #424843 is a reply to message #424836]

Tue, 06 October 2009 03:54

stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai

Junior Member

Yes, using the same user for both.

Regards,
Vish

Report message to a moderator

Re: Error while Exporting data [message #424848 is a reply to message #424843]

Tue, 06 October 2009 04:01

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Error while Exporting data [message #426409 is a reply to message #424774]

Thu, 15 October 2009 05:33

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

Report message to a moderator

Re: Error while Exporting data [message #426414 is a reply to message #426409]

Thu, 15 October 2009 05:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:24:32 CST 2024