Error: ORA-02429 after using expdp/impdp
791018Aug 12 2010 — edited Aug 12 2010Hi all
I have this problem: when I backing up my 11g database and restoring it into database of the different name I cannot drop particular indexes.
I am getting this error: ORA-02429: cannot drop index used for enforcement of unique/primary key.
note: I can easily drop this indexes before I run backup/restore procedures.
These are the steps.
1) creating database D1
2) back up:
expdp ** schemas=D1 dumpfile=D1.dmp logfile=D1.log*
3) create new db user
CREATE USER D2 IDENTIFIED BY D2 .....
4) restore D1 into D2:
impdp D1/D1** remap_schema=D1:D2 dumpfile=D1.dmp*
5) At this stage i am getting another identical database D2. but for some reason I cannot drop some indexes as discribed above.
Any ideas what am I missing in the process. Does impdp/expdp modifing my databes in some way?
Thanks a lot.