Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import from 8 to 10g

601737Sep 2 2008 — edited Sep 3 2008
Hi all.
I have a .DMP from Oracle 8 and I must import in 10g r2 and I have no idea whats wrong with my import..
I create the instance from the beginning and I still hve the same error.
I suppose the problem is TEMP tablespace but i dont know how to resolve this.

this is my .log file

Connected to: Oracle Database 10g Release 10.2.0.2.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by EXPORTA, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 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 'D:\ORACLE\ORADATA\INEVOLUP\TEMP01.DBF' "
"SIZE 1073741824 , 'D:\ORACLE\ORADATA\INEVOLUP\TEMP02.DBF' SIZE 1073741"
"824 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 'D:\ORACLE\ORADATA\INEVOLUP\TOOLS01.DBF"
"' SIZE 209715200 DEFAULT STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS"
" 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE 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 3249:
"CREATE TABLESPACE "INDX" DATAFILE 'D:\ORACLE\ORADATA\INEVOLUP\INDX01.DBF' "
"SIZE 2500M , 'D:\ORACLE\ORADATA\INEVOLUP\INDX02.DBF' SIZE 2500M "
"DEFAULT STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 5000 PCTI"
"NCREASE 0) ONLINE 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 24344:
"BEGIN SYS.DBMS_PSWMG_IMPORT.IMPORT_PSW_VERIFY_FN(' P_USER_GRAL ', ' VERIF"
"Y_FUNCTION ', ' username varchar2,password varchar2,old_password varchar2) "
"RETURN boolean IS"

" m integer;"
" ischar boolean;"
" chararray varchar2(52);"
"BEGIN"
""
" chararray:= ''abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'';"
""
" -- Check if the password is same as the username"
" IF password = username THEN"
" raise_application_error(-20001, ''La clave no puede ser igual al usuar"
"io'');"
" END IF;"
""
" -- Check for the minimum length of the password"
" IF length(password) < 8 THEN"
" raise_application_error(-20002, ''La clave no puede ser menor de 8 ca"
"racteres'');"
" END IF;"
""
" -- 2. Check for the character"
" ischar:=FALSE;"
" m := length(password);"
" FOR i IN 1..length(chararray) LOOP"
" FOR j IN 1..m LOOP"
" IF substr(password,j,1) = substr(chararray,i,1) THEN"
" ischar:=TRUE;"
" GOTO findpunct;"
" END IF;"
" END LOOP;"
" END LOOP;"
" IF ischar = FALSE THEN"
" raise_application_error(-20003, ''La clave debe ser alfanumerica'');"
" END IF;"
" <<findpunct>>"
""
" -- Everything is fine; return TRUE ;"
" RETURN(TRUE);"
"END;"
"'); END;"
IMP-00003: ORACLE error 24344 encountered
ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_PSWMG_IMPORT", line 100
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 28004:
"ALTER PROFILE "P_USER_GRAL" LIMIT PASSWORD_VERIFY_FUNCTION "VERIFY_FUNCTION"
"""
IMP-00003: ORACLE error 28004 encountered
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION
IMP-00017: following statement failed with ORACLE error 28004:
"ALTER PROFILE "P_USER_ADMIN" LIMIT PASSWORD_VERIFY_FUNCTION "VERIFY_FUNCTIO"
"N""
IMP-00003: ORACLE error 28004 encountered
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'F5145E3A6C640AC2' DEFAULT TABLESP"
"ACE "TOOLS" TEMPORARY TABLESPACE "TEMP" PROFILE "P_USER_ADMIN""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "TOAD" IDENTIFIED BY VALUES '4759257F78A8B5A3' DEFAULT TABLESPA"
"CE "TOOLS" TEMPORARY TABLESPACE "INDX" PROFILE "P_USER_ADMIN""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
IMP-00017: following statement failed with ORACLE error 959:

Thanks a lot....!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2008
Added on Sep 2 2008
5 comments
2,843 views