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
    From oracle community check this link – Sam Feb 11 at 23:38

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.