Import terminated unsuccessfully
658474Mar 6 2009 — edited Mar 9 2009Hi All,
I have exported the entire database and now importing to other DB on new system.
I have created the all tablespace which is existing in source database and using the below script to import the entire database
imp system/system full=Y file=/imageedw1/EDWBLR/expdump/EDW1exp.DMP,/imageedw1/EDWBLR/expdump/EDW2exp.dmp log=impdp.log
I am getting numerous error in log file like
ORA-01918: user 'ALLICDEXP' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "PORTAL30" QUOTA UNLIMITED ON "PORTAL30""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'PORTAL30' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SCOTT" QUOTA 104857600 ON "USERS""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SCOTT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
Note: if I import the dump using imp command and giving the first dumpfile name its going fine, but its not asking me to give the logfile name.
Please advice how can I import the entire database to this new database
Regards,