Problem in Full Import [message #74026] |
Fri, 27 August 2004 00:53 |
Avra
Messages: 65 Registered: July 2004
|
Member |
|
|
Hi.... When I am trying to import a .dmp file with FULL=Y option, I'm getting the follwing errors..... Please have a look in it and give me a solution......
thanks.........
ERROR:
Connected to: Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
Export file created by EXPORT:V07.03.03 via direct path
IMP-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "RBS" DATAFILE
'/oracle/mnt1/oradata/FACMC/rbs01.dbf' SI"
"ZE 26214400 , '/dataora/DATA/rbs02.dbf' SIZE 104857600 DEFAULT
S"
"TORAGE (INITIAL 131072 NEXT 131072 MINEXTENTS 2 MAXEXTENTS 121
PCTINCREASE "
"1) ONLINE PERMANENT"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "TEMP" DATAFILE
'/oracle/mnt1/oradata/FACMC/temp01.dbf' "
"SIZE 563200 , '/dataora/DATA/temp02.dbf' SIZE 52428800 ,
'/oracle"
"/app/oracle/product/733/oradata/temp03.dbf' SIZE 52428800 DEFAULT
STO"
"RAGE (INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE
0)"
" ONLINE PERMANENT"
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "TOOLS" DATAFILE
'/oracle/mnt1/oradata/FACMC/tools01.dbf"
"' SIZE 15728640 DEFAULT STORAGE (INITIAL 10240 NEXT 10240
MINEXTENTS "
"1 MAXEXTENTS 121 PCTINCREASE 5) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file
'/oracle/mnt1/oradata/FACMC/tools01.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-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "USERS" DATAFILE
'/oracle/mnt1/oradata/FACMC/users01.dbf"
"' SIZE 1048576 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS
1"
" MAXEXTENTS 121 PCTINCREASE 5) ONLINE PERMANENT"
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "FACMC" DATAFILE '/dataora/DATA/facmc01.dbf'
SIZE 524288"
"000 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXEXTENTS"
" 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dataora/DATA/facmc01.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 "RDP" DATAFILE '/dataora/DATA/rdp01.dbf'
SIZE 209715200 "
" DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS
121"
" PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dataora/DATA/rdp01.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 "FACIDX" DATAFILE
'/dataora/DATA/facmcidx.dbf' SIZE 1048"
"57600 , '/oracle/app/oracle/product/733/oradata/facmcidx_01.dbf'
SIZE "
"104857600 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXE"
"XTENTS 121 PCTINCREASE 5) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dataora/DATA/facmcidx.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 "RDPIDX" DATAFILE '/dataora/DATA/rdpidx.dbf'
SIZE 524288"
"00 , '/oracle/app/oracle/product/733/oradata/rdpidx_01.dbf' SIZE
52428"
"800 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1
MAXEXTENTS"
" 121 PCTINCREASE 5) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dataora/DATA/rdpidx.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 "OLDDATA" DATAFILE '/home2/olddata.dbf' SIZE
262144000 "
" DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS
121 "
"PCTINCREASE 3) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home2/olddata.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 "AUD_INFO" DATAFILE
'/home2/oradata/aud_info_01.dbf' SIZ"
"E 52428800 DEFAULT STORAGE (INITIAL 51200 NEXT 51200 MINEXTENTS 2
MAX"
"EXTENTS 50 PCTINCREASE 1) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home2/oradata/aud_info_01.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 "AUD_INFO_I" DATAFILE
'/home2/oradata/aud_info_i_01.dbf'"
" SIZE 52428800 DEFAULT STORAGE (INITIAL 51200 NEXT 51200 MINEXTENTS
2"
" MAXEXTENTS 50 PCTINCREASE 1) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home2/oradata/aud_info_i_01.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 "TEST" DATAFILE '/home2/oradata/test1.dbf'
SIZE 5242880 "
" DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS
121"
" PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/home2/oradata/test1.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.
|
|
|
|
Re: Problem in Full Import [message #74052 is a reply to message #74026] |
Tue, 31 August 2004 12:06 |
croK
Messages: 170 Registered: April 2002
|
Senior Member |
|
|
there is also problems trying to crete datafiles, for example:
file '/home2/oradata/test1.dbf'
you will have to crete directory /home and
/home/oradata manually if it doenst exist in your system. ORACLE WILL NOT RECREATE DIRECTORIES NOR SUBDIRECTORIES.
Or you can be faceing lack of space on that filesystem, or permissions problems.
TABLE ALREADY EXIST problems can be solved using ignore=y or you can drop first those objects before importing.
Best luck
www.consultoria-oracle.com
|
|
|