Database Software

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 problem

user5707153Jun 4 2011 — edited Jun 4 2011

before am using unix with oracle 9i
and now moving to windowes oracle 10g
i have create database use DCA
i use full import commnad:
imp system/system Full=y ignore=y file=d:\full.dmp log=d:\full.log

and not imprting well any idea can help me

log file :

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8MSWIN1252 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 UTF8 NCHAR character set (possible ncharset conversion)
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "BUDGET" DATAFILE '/appl/oradata/ORC1/budget01.dbf' SIZE"
" 209715200 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/budget01.dbf'
ORA-27040: skgfrcre: 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 "BUDGET02" DATAFILE '/appl/oradata/ORC1/budget201.dbf' S"
"IZE 209715200 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/budget201.dbf'
ORA-27040: skgfrcre: 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 "COMP2_TABSP" DATAFILE '/appl/oradata/ORC1/compts01.dbf'"
" SIZE 209715200 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/compts01.dbf'
ORA-27040: skgfrcre: 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 "DEVELOPMENT_TS" DATAFILE '/appl/oradata/ORC1/devts01.db"
"f' SIZE 524288000 AUTOEXTEND ON NEXT 104857600 MAXSIZE 16383M, '/app"
"l/oradata/ORC1/devts02.dbf' SIZE 524288000 AUTOEXTEND ON NEXT 1048576"
"00 MAXSIZE 16383M, '/appl/oradata/ORC1/devts03.dbf' SIZE 524288000 A"
"UTOEXTEND ON NEXT 104857600 MAXSIZE 16383M, '/appl/oradata/ORC1/devts04.db"
"f' SIZE 524288000 AUTOEXTEND ON NEXT 104857600 MAXSIZE 16383M, '/app"
"l/oradata/ORC1/devts05.dbf' SIZE 524288000 AUTOEXTEND ON NEXT 1048576"
"00 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/devts01.dbf'
ORA-27040: skgfrcre: 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 "PHLT_TABSP" DATAFILE '/appl/oradata/ORC1/phltts01.dbf' "
"SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/phltts01.dbf'
ORA-27040: skgfrcre: 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 "RENTCONT" DATAFILE '/appl/oradata/ORC1/rentcont01.dbf' "
"SIZE 104857600 , '/appl/oradata/ORC1/rentcont011.dbf' SIZE 524288000 "
" AUTOEXTEND ON NEXT 10485760 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL A"
"UTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/rentcont01.dbf'
ORA-27040: skgfrcre: 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 "RENTCONTRACT" DATAFILE '/appl/oradata/ORC1/rentcontract"
"01.dbf' SIZE 1048576000 , '/appl/app/oracle/product/920/dbs/c:xxsth_04"
".dbf' SIZE 4194304 , '/appl/app/oracle/product/920/dbs/c:xxops_ssb01.d"
"bf' SIZE 10485760 AUTOEXTEND ON NEXT 4096 MAXSIZE 16383M, '/appl/app"
"/oracle/product/920/dbs/c:xxops_ssb001.dbf' SIZE 104857600 AUTOEXTEND"
" ON NEXT 4194304 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/rentcontract01.dbf'
ORA-27040: skgfrcre: 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 "REVENU" DATAFILE '/appl/oradata/ORC1/revenu01.dbf' SIZE"
" 314572800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/revenu01.dbf'
ORA-27040: skgfrcre: 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 "SDO_SUPPLY" DATAFILE '/appl/oradata/ORC1/sdosupp01.dbf'"
" SIZE 209715200 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/sdosupp01.dbf'
ORA-27040: skgfrcre: 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 "USR" DATAFILE '/appl/oradata/ORC1/usr01.dbf' SIZE 52428"
"800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/usr01.dbf'
ORA-27040: skgfrcre: 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 "SDO_DATA_TBS" DATAFILE '/appl/app/oracle/product/920/db"
"s/sdo1.dbf' SIZE 52428800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/app/oracle/product/920/dbs/sdo1.dbf'
ORA-27040: skgfrcre: 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 "PERFSTAT" DATAFILE '/appl/oradata/ORC1/perfstat.dbf' SI"
"ZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE "
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/appl/oradata/ORC1/perfstat.dbf'
ORA-27040: skgfrcre: 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 959:
"CREATE USER "INCOME" IDENTIFIED BY VALUES '05756EEF16496F44' DEFAULT TABLES"
"PACE "REVENU" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'REVENU' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "HRMS" IDENTIFIED BY VALUES 'E2D7E62F2772BB2B' DEFAULT TABLESPA"
"CE "DEVELOPMENT_TS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DEVELOPMENT_TS' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "DRCH" IDENTIFIED BY VALUES '280EF159FF52EFBC' DEFAULT TABLESPA"
"CE "DEVELOPMENT_TS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DEVELOPMENT_TS' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "SUPL" IDENTIFIED BY VALUES '16084C20344D2715' DEFAULT TABLESPA"
"CE "SDO_SUPPLY" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'SDO_SUPPLY' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "BUDGET" IDENTIFIED BY VALUES '1382227FBDCD5B61' DEFAULT TABLES"
"PACE "BUDGET02" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'BUDGET02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ADDRESSING" IDENTIFIED BY VALUES '94325DAE60443182' DEFAULT TA"
"BLESPACE "COMP2_TABSP" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'COMP2_TABSP' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ATTEND3" IDENTIFIED BY VALUES '3881FAB76DFAD5B1' DEFAULT TABLE"
"SPACE "BUDGET" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'BUDGET' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "SDO_DEV" IDENTIFIED BY VALUES '93E369DC66F593C0' DEFAULT TABLE"
"SPACE "SDO_DATA_TBS" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'SDO_DATA_TBS' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "PERFSTAT" IDENTIFIED BY VALUES 'AC98877DE1297365' DEFAULT TABL"
"ESPACE "PERFSTAT" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "INCOME""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INCOME' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "HRMS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HRMS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "DRCH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DRCH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "SUPL" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SUPL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "BUDGET" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'BUDGET' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "ADDRESSING" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADDRESSING' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "ATTEND3""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ATTEND3' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "SDO_DEV""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SDO_DEV' does not exist
IMP-00017: following statement failed with ORACLE error 990:
"GRANT ADMINISTER SECURITY TO "PLAN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT ALTER ANY SECURITY PROFILE TO "PLAN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE ANY SECURITY PROFILE TO "PLAN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE SECURITY PROFILE TO "PLAN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT DROP ANY SECURITY PROFILE TO "PLAN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER SESSION TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE TABLE TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PROCEDURE TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SEQUENCE TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PUBLIC SYNONYM TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP PUBLIC SYNONYM TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "INCOME""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INCOME' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "INCOME""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INCOME' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "INCOME""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INCOME' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "HRMS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HRMS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "DRCH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'DRCH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "SUPL" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SUPL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "SUPL" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SUPL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "AQ_ADMINISTRATOR_ROLE" TO "SUPL" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SUPL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "BUDGET""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'BUDGET' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "BUDGET" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'BUDGET' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "ADDRESSING""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADDRESSING' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "ADDRESSING" WITH ADMIN OPTION"
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADDRESSING' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "ATTEND3""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ATTEND3' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "ATTEND3""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ATTEND3' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "SDO_DEV""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SDO_DEV' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "SDO_DEV""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SDO_DEV' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "SDO_DEV""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SDO_DEV' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "SELECT_CATALOG_ROLE" TO "PERFSTAT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ATTEND3" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ATTEND3' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SDO_DEV" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SDO_DEV' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "INCOME" DEFAULT ROLE "DBA""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'INCOME' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "HRMS" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'HRMS' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "DRCH" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DRCH' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SUPL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SUPL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "BUDGET" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'BUDGET' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ADDRESSING" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ADDRESSING' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "PERFSTAT" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'PERFSTAT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "PERFSTAT" QUOTA UNLIMITED ON "PERFSTAT""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'PERFSTAT' does not exist
. importing DGTA's objects into DGTA
. importing BOHE's objects into BOHE
. importing PERM's objects into PERM
. importing SYSTEM's objects into SYSTEM
. importing WMSYS's objects into WMSYS
. importing SCOTT's objects into SCOTT
. importing EXAMPLE's objects into EXAMPLE
. importing HRMS's objects into HRMS
"ALTER SESSION SET CURRENT_SCHEMA= "HRMS""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully