import в 10g VS import в 9i на Муркоде

Дмитрий Кириенко

Дата: 01.06.2006 21:50:07

Вечер добрый,

помогите пожалуйста разобраться в следующей ситуации:

имеется дамп схемы (OS MS Windows Server 2003 Standart 32bit/ Oracle 9.2.0.1 Standart 32bit)

xal_from_9i.dmp

есть 2 тестовых сервера Oracle:

1. Oracle 9.2.0.1 Standart 32bit / OS MS Windows Server 2003 Standart 32 bit
2. Oracle 10.2.0.1 Standart 64bit / OS MS Windows Server 2003 R2 Standart 64 bit.

Импорт в Oracle 9.2.0.1 :

01_import.bat + файл параметов:

FROMUSER=xal_supervisor
TOUSER=xal_supervisor
FILE=e:\xal_from_9i.dmp
LOG=e:\01_import_shema_9i.log
GRANTS=y
ROWS=y
IGNORE=n
INDEXES=n
CONSTRAINTS=n
STATISTICS=NONE
BUFFER=2048000

01_import_shema_9i.log

Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in BLT8CP921 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing XAL_SUPERVISOR's objects into XAL_SUPERVISOR
***********************************************
***********************************************
Import terminated successfully without warnings.

02_import.bat + файл параметов:

FROMUSER=xal_supervisor
TOUSER=xal_supervisor
FILE=e:\xal_from_9i.dmp
LOG=e:\02_import_shema_9i.log
GRANTS=y
ROWS=n
IGNORE=y
INDEXES=y
CONSTRAINTS=n
STATISTICS=NONE
BUFFER=2048000

02_import_shema_9i.log

Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in BLT8CP921 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing XAL_SUPERVISOR's objects into XAL_SUPERVISOR
Import terminated successfully without warnings.

03_import.bat + файл параметов:

FROMUSER=xal_supervisor
TOUSER=xal_supervisor
FILE=e:\xal_from_9i.dmp
LOG=e:\03_import_shema_9i.log
GRANTS=y
ROWS=n
IGNORE=y
INDEXES=n
CONSTRAINTS=y
STATISTICS=NONE
BUFFER=2048000

03_import_shema_9i.log

Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in BLT8CP921 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing XAL_SUPERVISOR's objects into XAL_SUPERVISOR
Import terminated successfully without warnings.

Импорт в Oracle 10.2.0.1 :
Все тоже, но на 2-ом шаге происходит следующее:

02_import_shema_9i_to_10g.log

Connected to: Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses BLT8CP921 character set (possible charset conversion)
export client uses BLT8CP921 character set (possible charset conversion)
. importing XAL_SUPERVISOR's objects into XAL_USR
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE UNIQUE INDEX "I_537NUMBERIDX" ON "FALOG" ("DATASET" , "GROUP_" , "NU"
 "MBER_" , "LOGDATE" DESC , "ROWNUMBER" )  PCTFREE 10 INITRANS 2 MAXTRANS 255"
 " STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XALIDX" L"
 "OGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE UNIQUE INDEX "I_526IDFIDX" ON "SANKONTI" ("DATASET" , "BANKA" , "KOD"
 "S" , "VAL" , "KONTS" , "ROWNUMBER" DESC )  PCTFREE 10 INITRANS 2 MAXTRANS 2"
 "55 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XALIDX""
 " LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE UNIQUE INDEX "I_526KDVALIDX" ON "SANKONTI" ("DATASET" , "KODS" , "VA"
 "L" , "ROWNUMBER" DESC )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL"
 " 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XALIDX" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE UNIQUE INDEX "I_075FROMUSER" ON "MAIL" ("DATASET" , "FROMUSER" , "AR"
 "CHIVE" , "MAILSTATUS" , "ROWNUMBER" DESC )  PCTFREE 10 INITRANS 2 MAXTRANS "
 "255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XALIDX"
 "" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE UNIQUE INDEX "I_032LINRECIDIDX" ON "DELETED13" ("DATASET" , "LINRECI"
 "D" , "DATE_" DESC , "ROWNUMBER" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORA"
 "GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XALIDX" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Import terminated successfully with warnings.

Кто-нибудь может обьяснить разницу импорта в 9.2 и в 10g ? Такое впечатление, что при импорте в 10-ку задействована какая-то проверка целостности.