DataPump Error [message #282089] |
Tue, 20 November 2007 19:20 |
DaveHatz
Messages: 3 Registered: November 2007 Location: Aliso Viejo, CA
|
Junior Member |
|
|
We just installed 10g and we are trying to export once of the schemas. I have tried both EXPDP and EXP and I am getting the same results everytime. I have granted EXP_FULL_DATABASE to my user.
Here is the errors I am getting:
UDE-00008: operation generated ORACLE error 6550
ORA-06550: line 1, column 17:
PLS-00302: component 'DBMS_OUTPUT' must be declared
ORA-06550: line 1, column 13:
PL/SQL: Statement ignored
ORA-06550: line 1, column 56:
PLS-00302: component 'DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 52:
PL/SQL: Statement ignored
I am not a DBA but have been using 9i for about 4 years and just jumped to 10g. I come from the programming side of the shop. If anyone could shed some light on this problem for me, I would appreciate it.
Thanks,
Dave Hatz
|
|
|
|
Re: DataPump Error [message #282092 is a reply to message #282091] |
Tue, 20 November 2007 19:52 |
DaveHatz
Messages: 3 Registered: November 2007 Location: Aliso Viejo, CA
|
Junior Member |
|
|
I ran the following command from the command line :
expdp user/password@orcl directory=my_dir dumpfile=EXP.dmp NOLOGFILE=y
|
|
|
|
|
Re: DataPump Error [message #282287 is a reply to message #282122] |
Wed, 21 November 2007 06:45 |
DaveHatz
Messages: 3 Registered: November 2007 Location: Aliso Viejo, CA
|
Junior Member |
|
|
I have given the role of EXP_FULL_DATABASE to the user that is running the datapump. I am NOT using the SYS user.
I am guessing that I don't have the package installed. How can I check to see if the package is installed?
|
|
|
|