Hello all,

I am encountering the following errors when attempting to export, via Oracle 10g, a dumped Oracle 9i database. The character set of the dumped 9i instance is indeed WE8ISO8859P15, BTW :

Import: Release 10.1.0.2.0 - Production on Wed Jun 15 16:43:49 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P15 character set (possible charset conversion)
IMP-00015: following statement failed because the object already exists:
"CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADA"
"TA\ORCL15\UNDOTBS01.DBF' SIZE 209715200 REUSE AUTOEXTEND ON NEXT 5242880 M"
"AXSIZE 32767M EXTENT MANAGEMENT LOCAL "
IMP-00015: following statement failed because the object already exists:
"CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 8192 TEMPFILE 'E:\ORACLE\ORAD"
"ATA\ORCL15\TEMP01.DBF' SIZE 105906176 REUSE AUTOEXTEND ON NEXT 655360 MAXS"
"IZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "CWMLITE" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ORC"
"L15\CWMLITE01.DBF' SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 3"
"2767M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SE"
"GMENT SPACE MANAGEMENT AUTO"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'E:\ORACLE\ORADATA\ORCL15\CWMLITE01.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.


etc, etc., and then of course everything else depending on these tablespaces fails also ...

Can anyone shed any light on this ORA-01119 error the keeps on preventing the necessary datafiles from being created ??


Thanks,

Travis Weir