Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database 11gR2 Datapump Re-install DBMS DatatPump Objects Error

954700Oct 11 2012 — edited Oct 12 2012

Hi Guru, when I was doing following 4th step of re-install data pump utility

--#4 step to re-install DBMS data pump Objects
SYS@dxrpam>@$ORACLE_HOME/rdbms/admin/dbmspump.sql

I got an error as following,

CREATE OR REPLACE TYPE sys.oracle_loader AUTHID CURRENT_USER AS OBJECT
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type

I checked on-line for above error, it all say I should use alter type add/drop statement instead of alter type replace, but since the script is from the Oracle server standard, I didn't write the script, so what should I do? May I just ignore this error?

Advanced Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2012

Added on Oct 11 2012

#11g, #database, #database-key-features, #error, #export, #export-import-sql-loader-external-tables, #import, #installation, #sql

9 comments

2,065 views