Database Software

I've just imported whole 8i (8.1.7.0.0) database into 11g r2 (11.2.0.1.0) & generated one import log file..

import terminated successfully with warnings.. below are the import log details.



Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
IMP-00046: using FILESIZE value from export file of 1073741824
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 3249:
"CREATE TABLESPACE "TOOLS" DATAFILE '/home/oradata/oracanet/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 1119:
"CREATE TABLESPACE "RBS" DATAFILE '/home/oradata/oracanet/rbs01.dbf' SIZE 2"
"09715200 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M DEFAULT STORAGE("
"INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50) ONL"
"INE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home/oradata/oracanet/rbs01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TEMP" DATAFILE '/home/oradata/oracanet/temp01.dbf' SIZE"
" 104857600 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-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "USERS" DATAFILE '/home/oradata/oracanet/users01.dbf' SI"
"ZE 20971520 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M, '/home/oradat"
"a/oracanet/users02.dbf' SIZE 314572800 DEFAULT STORAGE(INITIAL 13107"
"2 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE PERMANENT "
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "INDX" DATAFILE '/home/oradata/oracanet/indx01.dbf' SIZE"
" 104857600 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M DEFAULT STORAG"
"E(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ON"
"LINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home/oradata/oracanet/indx01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "DRSYS" DATAFILE '/home/oradata/oracanet/drsys01.dbf' SI"
"ZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M DEFAULT STORAG"
"E(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 5"
"0) ONLINE PERMANENT "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home/oradata/oracanet/drsys01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "TBLCANNET" DATAFILE '/home/oradata/oracanet/cannet01.db"
"f' SIZE 524288000 DEFAULT STORAGE(INITIAL 655360 NEXT 655360 MINEXTE"
"NTS 1 MAXEXTENTS 505 PCTINCREASE 0) ONLINE PERMANENT "
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES '80A6FCA036EAD93B' DEFAULT TABLESP"
"ACE "TOOLS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
IMP-00015: following statement failed because the object already exists:
"CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' ACCOUNT LOCK"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'E066D214D5421CCC' ACCOUNT LOCK"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "SCOTT" IDENTIFIED BY VALUES 'A767CAA33CAA092F' ACCOUNT LOCK"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ADMIN" IDENTIFIED BY VALUES '9F919C566CC0BBC9' DEFAULT TABLESP"
"ACE "TBLCANNET" TEMPORARY TABLESPACE "TEMP""

IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "ADMIN" QUOTA UNLIMITED ON "TBLCANNET" QUOTA UNLIMITED ON "INDX""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'INDX' does not exist
. importing ADMIN's objects into ADMIN
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE DATABASE LINK "MIPDB" CONNECT TO "CANNET" IDENTIFIED BY "BLISS" USIN"
"G 'mip'"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
. importing SYSTEM's objects into SYSTEM

. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. importing OSE$HTTP$ADMIN's objects into OSE$HTTP$ADMIN
. importing ADMIN's objects into ADMIN
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM

. . importing table "AWB" 1550 rows imported
. . importing table "AWB05042007" 1242 rows imported
. . importing table "AWB12052006" 782 rows imported
. . importing table "AWB_OLD" 700 rows imported
. . importing table "BUG" 251 rows imported
. . importing table "BUG_TMP" 211 rows imported
. . importing table "CIRCULAR" 1702 rows imported
. . importing table "CIRCULAR_OLD" 445 rows imported
. . importing table "COMMUNICATION" 104 rows imported
. . importing table "EMAIL" 615 rows imported
. . importing table "EMP" 0 rows imported
. . importing table "GROUPPASS" 9 rows imported
. . importing table "IMB" 1047 rows imported
. . importing table "IMBCORPUSERS" 0 rows imported
. . importing table "IMB_OLD" 300 rows imported
. . importing table "MEMO" 139 rows imported
. . importing table "NEWSECTPASS" 50 rows imported
. . importing table "OLDSECTPASS" 50 rows imported
. . importing table "PACKAGE" 10 rows imported
. . importing table "SECTPASS" 62 rows imported
. . importing table "SUGGESTION" 3173 rows imported
. . importing table "TBLCIRCULAR" 0 rows imported
. . importing table "TBLMEMO" 0 rows imported
. . importing table "TBLUSER" 1 rows imported
. . importing table "TEST" 145 rows imported
. . importing table "TEST_090709" 0 rows imported
. . importing table "VERSION" 11 rows imported
. . importing table "WANORDER" 848 rows imported
. . importing table "WANORDER1" 848 rows imported
. . importing table "WANORDERPASS" 2 rows imported
. . importing table "WINGPASS" 23 rows imported
. importing SYSTEM's objects into SYSTEM



""
"/"
. importing ADMIN's objects into ADMIN
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
About to enable constraints...
. importing ADMIN's objects into ADMIN
Import terminated successfully with warnings.




so please refer these & tell me are there any critical warnings??? because i couldn't able to find the critical warnings i am new to this field...

and i want access these tables data also..please suggest me the queries to access these tables that have been imported....

Edited by: 13021986 on Apr 19, 2012 5:38 AM