Home » RDBMS Server » Server Utilities » expdp - error (10.2.0.3)
expdp - error [message #311371] Fri, 04 April 2008 05:07 Go to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared

any come across this, what needs to be done?

Report message to a moderator

Re: expdp - error [message #311387 is a reply to message #311371] Fri, 04 April 2008 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
To get the privilege to execute the package.

Regards
Michel

Report message to a moderator

Re: expdp - error [message #311863 is a reply to message #311387] Mon, 07 April 2008 03:09 Go to previous messageGo to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
I executed the expdp with system ( even granted sysdba to system).
What privs / is it maybe OS privs to file system?

Report message to a moderator

Re: expdp - error [message #311866 is a reply to message #311371] Mon, 07 April 2008 03:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
 
alter package SYS.DBMS_DATAPUMP compile;

Report message to a moderator

Re: expdp - error [message #311873 is a reply to message #311863] Mon, 07 April 2008 03:55 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Copy and paste your session without forgetting to format it.

Regards
Michel

Report message to a moderator

Previous Topic: how to import 8i data in 10g
Next Topic: export import in oracle9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 14:36:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.