2 Replies Latest reply: Nov 27, 2012 11:56 AM by Richard Harrison . RSS

    Export non-asm to asm

    300230
      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