IMP Error while doing with FULL=Y
498879Aug 28 2007 — edited Oct 27 2007Hi DBAs,
I have a full db dump and importing with following caluse
imp "'/ as sysdba' " file=R1_2007_UAT_260807.dmp log=R1_2007_UAT_260807_imp.log full=y commit=y grants=y ignore=y skip_unusable_indexes=y feedback=25000 statistics=none
but getting following error for some user/profile missing.
my doubt is like it should not ask for profile of user missing error as i am doing a full database import,
please suggest :--
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBR_OPR_TF01" TO "OPS$TFOPR01""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OPS$TFOPR01' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBR_PRS_TF01" TO "OPS$TFOPR01""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OPS$TFOPR01' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "OPS$TFOPR01" DEFAULT ROLE "DBR_OPR_TF01""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'OPS$TFOPR01' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "TEST" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'TEST' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "OPS$TFOPR01" QUOTA UNLIMITED ON "INDEX_01" QUOTA UNLIMITED ON ""