Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Нужна помощ по импорту  [new]
AsmN
Member

Откуда:
Сообщений: 68
Народ, подскажите кто знает, в чем проблема? Делаю импорт из 8-ки в 10-ку, вываливается с ошибкой:
Вот лог
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in CL8MSWIN1251 character set and AL16UTF16 NCHAR character set
export server uses CL8MSWIN1251 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TEMP" DATAFILE 'C:\ORACLE\ORADATA\BASE\TEMP01.DBF' SIZE"
" 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M DEFAULT STORAGE("
"INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) "
"ONLINE TEMPORARY "
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 3249:
"CREATE TABLESPACE "TOOLS" DATAFILE 'C:\ORACLE\ORADATA\BASE\TOOLS01.DBF' SI"
"ZE 10485760 AUTOEXTEND ON NEXT 327680 MAXSIZE 32767M DEFAULT STORAG"
"E(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLI"
"NE PERMANENT "
IMP-00003: ORACLE error 3249 encountered
ORA-03249: Uniform size for auto segment space managed tablespace should have atleast 5 blocks
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' DEFAULT TABLESP"
"ACE "TOOLS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "APP_ENERGY" IDENTIFIED BY VALUES '25CAC7E34978AED7' DEFAULT TA"
"BLESPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "KAMRES" IDENTIFIED BY VALUES 'C6759F5AF88CCE25' DEFAULT TABLES"
"PACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "KAMSB1" IDENTIFIED BY VALUES 'D3C94EB32DA64EBD' DEFAULT TABLES"
"PACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "MELNIKOVA" IDENTIFIED BY VALUES 'B015F67A9707CDBF' DEFAULT TAB"
"LESPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "SHPAGIN" IDENTIFIED BY VALUES 'CD2422E24EFD16E3' DEFAULT TABLE"
"SPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "ALEXANDROVICH" IDENTIFIED BY VALUES '49C53CB1BA04CB71' DEFAULT"
" TABLESPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "MALAHOV" IDENTIFIED BY VALUES 'BE819BAA9144F357' DEFAULT TABLE"
"SPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "VOVAN" IDENTIFIED BY VALUES '6713937971F4FB86' DEFAULT TABLESP"
"ACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "UHINA" IDENTIFIED BY VALUES '3BCEABE323B9B860' DEFAULT TABLESP"
"ACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "MNEKINA" IDENTIFIED BY VALUES '299ADE091B5DA43A' DEFAULT TABLE"
"SPACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "LUKNEL" IDENTIFIED BY VALUES '23D178400CF3AB08' DEFAULT TABLES"
"PACE "USERS" TEMPORARY TABLESPACE "USERS""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER SESSION TO "APP_ENERGY" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PROCEDURE TO "APP_ENERGY" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SEQUENCE TO "APP_ENERGY" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION TO "APP_ENERGY" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SYNONYM TO "APP_ENERGY" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
-----------------------------------------------------------------------------
"ALTER USER "KAMRES" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'KAMRES' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SHPAGIN" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SHPAGIN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALEXANDROVICH" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALEXANDROVICH' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MALAHOV" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MALAHOV' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "VOVAN" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'VOVAN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "UHINA" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'UHINA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MNEKINA" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MNEKINA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "LUKNEL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'LUKNEL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "APP_ENERGY" QUOTA UNLIMITED ON "TEMP" QUOTA UNLIMITED ON "USERS"
"""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'APP_ENERGY' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "KAMRES" QUOTA 314572800 ON "TEMP" QUOTA 314572800 ON "USERS""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'KAMRES' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "KAMSB1" QUOTA 314572800 ON "USERS" QUOTA 314572800 ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'KAMSB1' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MELNIKOVA" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MELNIKOVA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SHPAGIN" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SHPAGIN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALEXANDROVICH" QUOTA 314572800 ON "USERS" QUOTA 314572800 ON "T"
"EMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALEXANDROVICH' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MALAHOV" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MALAHOV' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "VOVAN" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'VOVAN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "UHINA" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'UHINA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MNEKINA" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MNEKINA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "LUKNEL" QUOTA UNLIMITED ON "USERS" QUOTA UNLIMITED ON "TEMP""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'LUKNEL' does not exist
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. importing OSE$HTTP$ADMIN's objects into OSE$HTTP$ADMIN
. importing APP_ENERGY's objects into APP_ENERGY
"ALTER SESSION SET CURRENT_SCHEMA= "APP_ENERGY""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
24 апр 09, 08:50    [7108170]     Ответить | Цитировать Сообщить модератору
 Re: Нужна помощ по импорту  [new]
Вячеслав Любомудров
Member

Откуда: Владивосток
Сообщений: 18202
Создай табличные пространства И юзеров ручками
Прикольненько у тебя: DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "USERS"
24 апр 09, 08:53    [7108182]     Ответить | Цитировать Сообщить модератору
 Re: Нужна помощ по импорту  [new]
AsmN
Member

Откуда:
Сообщений: 68
Ет не у меня, ет в старой базе создавали на 8-ке, а мне надо ее переставить на 10-ку, в часности интересует вот ета ошибка:
IMP-00017: following statement failed with ORACLE error 3249:
"CREATE TABLESPACE "TOOLS" DATAFILE 'C:\ORACLE\ORADATA\BASE\TOOLS01.DBF' SI"
"ZE 10485760 AUTOEXTEND ON NEXT 327680 MAXSIZE 32767M DEFAULT STORAG"
"E(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLI"
"NE PERMANENT "
IMP-00003: ORACLE error 3249 encountered
ORA-03249: Uniform size for auto segment space managed tablespace should have atleast 5 blocks
Я думаю отсюда ноги растут.
24 апр 09, 09:03    [7108219]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить