Database Software

Hi All,

So here is my issue.

The current Production is: OS windows 2003, Oracle 10.1.0.4 non-ASM
The Future Production is:OS windows 2008, Oracle 11.2.0.3 ASM)
So you see all three catagories are different, OS, version of Oracle and non-ASM to ASM.
The software is installed, we have the database which is working.
The question is we want to move the data from the current to the future.

First try resulted in:
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file 'O:\ORADATA\DEVL\BUSOBJ01.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.

Second try after we created the tablespaces first then the import resulted exporting almost alll objects but the log file shows the following errors:

Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"BUSOBJ" already exists
ORA-31684: Object type TABLESPACE:"CLOB_DATA" already exists
ORA-31684: Object type TABLESPACE:"DEVELOPMENT" already exists
ORA-31684: Object type TABLESPACE:"INDX" already exists
ORA-31684: Object type TABLESPACE:"IWAY" already exists
ORA-31684: Object type TABLESPACE:"TOOLS" already exists
ORA-31684: Object type TABLESPACE:"TRNGAUDIT" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-31684: Object type TABLESPACE:"XDB" already exists
ORA-31684: Object type TABLESPACE:"FILENOBST" already exists
ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
ORA-31684: Object type TABLESPACE:"ACSAQ" already exists
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file 'O:\ORADATA\DEVL\UNDO_01.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 UNDO TABLESPACE "UNDO_01" DATAFILE 'O:\ORADATA\DEVL\UNDO_01.DBF' SIZE 734003200 AUTOEXTEND ON NEXT 104857600 MAXSIZE 16384M,'O:\ORADATA\DEVL\UNDO_02.DBF' SIZE 2147483648,'O:\ORADATA\DEVL\UNDO_03.DBF' SIZE 2147
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file 'O:\ORADATA\DEVL\AUDIT.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 "AUDIT" DATAFILE 'O:\ORADATA\DEVL\AUDIT.DBF' SIZE 524288000 AUTOEXTEND ON NEXT 524288000 MAXSIZE 1073741824 NOLOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOM
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file 'O:\ORADATA\DEVL\CMS_CLOB_01.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

and so on....

Can someone guide me how to do a clean import using data pump.

I would appriciate any help.

Thanks to all...

As we proceed I will keep you all updated.

Thanks

Habeeb