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?
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To get the privilege to execute the package.

Regards
Michel
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?
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;

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

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


Current Time: Sat Dec 03 07:52:57 CST 2016

Total time taken to generate the page: 6.00490 seconds