Experts,
I have a .dmp file that I have exported from a Unix system running Oracle 11.2.0.3, I am trying an import on a Windows systems running Oracle 12.1.0.1 and I'm getting this error message alot:
WARNING: possible data loss in character set conversions
Starting "SYSTEM"."SYS_IMPORT_FULL_02": system/******** full=y directory=import dumpfile=Financetest.dmp
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-39083: Object type TABLESPACE:"EFIN_DTS" failed to create with error:
ORA-01119: error in creating database file '/oracle/oradata/EFINL/EFINL/efin_dts01.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.
Failing sql is:
CREATE TABLESPACE "EFIN_DTS" DATAFILE '/oracle/oradata/EFINL/EFINL/efin_dts01.dbf' SIZE 1073741824 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT
ORA-39083: Object type TABLESPACE:"EFIN_RTS" failed to create with error:
ORA-01119: error in creating database file '/oracle/oradata/EFINL/EFINL/efin_rts01.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.
Failing sql is:
CREATE TABLESPACE "EFIN_RTS" DATAFILE '/oracle/oradata/EFINL/EFINL/efin_rts01.dbf' SIZE 209715200 AUTOEXTEND ON NEXT 20971520 MAXSIZE 32767M LOGGING ONLINE PERMANENT
It goes on in the same manner for a while and it looks like these errors are the reason for the ones later on in the import.
The file location on the Unix server where the database is saved is /oracle/oradata/EFINL/EFINL and it appears to be looking for that location on the current install but as it is Windows, it doesn't exist.
Is there a way of changing this? I tried a remap_datafile command but got the same errors
Any help is great,
Cheers