Home » RDBMS Server » Server Utilities » Problem in Full Import
Problem in Full Import [message #74026] Fri, 27 August 2004 00:53 Go to next message
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.

 

Report message to a moderator

Re: Problem in Full Import [message #74027 is a reply to message #74026] Fri, 27 August 2004 03:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
tablespaces alredy exist in your target database.
try with ignore=y ( which will not report error, if the object is already found, and will skip the import of the object/tablespace.

If there a few schema's i recomend to import schema-by-schema. It is little more work, but gives more control.

Report message to a moderator

Re: Problem in Full Import [message #74052 is a reply to message #74026] Tue, 31 August 2004 12:06 Go to previous message
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

Report message to a moderator

Previous Topic: import problem urgent
Next Topic: ORAPWD and ORADIM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 10:54:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.