Need help with import
Hi,
I am doing an export/import job from 8.0.6 to 10.2.0.1, i have hundreds of users in this database.
1) I did an full=y export from 8.0.6
---------- exp system/manager file=e:\export.dmp log=export.txt full=y --------------------
2) I created same database structure as of 8.0.6 in 10g.
3) I imported the dump file in 10g
---------- imp system/manager file=e:\export.dmp log=e:\import.txt full=y ignore=y -------------------
when i start importing, i am getting errors that i dont have particular users.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V08.00.06 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses AR8MSWIN1256 NCHAR character set (possible ncharset conversion)
. importing ULTGNP's objects into ULTGNP
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER ON "ULT_ADJ_COMP_SEQ" TO "ULT_CASHIER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_CASHIER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_ADJ_COMP_SEQ" TO "ULT_CASHIER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_CASHIER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER ON "ULT_ADJ_COMP_SEQ" TO "ULTGNP_SYNM_GRANTS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULTGNP_SYNM_GRANTS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_ADJ_COMP_SEQ" TO "ULTGNP_SYNM_GRANTS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULTGNP_SYNM_GRANTS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULTGNP_SYNM_GRANTS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULTGNP_SYNM_GRANTS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_MEDLAB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_MEDLAB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_DOCTOR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_DOCTOR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_CASHIER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_CASHIER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_CORPORATE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_CORPORATE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_DENAPP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_DENAPP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ULT_APPL_TRANX_SEQ" TO "ULT_DENTIST""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ULT_DENTIST' does not exist
My question is do i need to pre-create all the users,roles etc in 10g before i import?
thanks