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;