2

I get this error ORA-02289: sequence does not exist when I try to import a schema to my database, could you give me some recommendation?

Import Command:

impdp '"sys/mmm as sysdba"' directory=BACK_IMPORT dumpfile=0502190800%U.dmp 
logfile=impdp_MBD.log SCHEMAS=MSCHEM PARALLEL=7 encryption_password=0qazw

Export Command:

expdp '"sys/mmm as sysdba"' encryption=all encryption_password=0qazw 
encryption_algorithm=aes256 COMPRESSION=ALL DIRECTORY=BACK_EXPORT 
COMPRESSION_ALGORITHM=BASIC LOGTIME=ALL CONTENT=ALL flashback_time=systimestamp 
DUMPFILE=$name% U.dmp LOGFILE=$name.log PARALLEL=7 SCHEMAS=MSCHEM,IOOUT,ZHIST;
1
  • 1
    From oracle community check this link
    – user153556
    Commented Feb 11, 2019 at 23:38

1 Answer 1

0

You are importing MSCHEM schema. Please check in source database that one of TABLE/Procedure/Package using a sequence that exist in another schema. If so, don't worry just recreate it. you can find this sequence name in import log also.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.