6 Replies Latest reply: Jul 27, 2009 9:06 AM by 591186 Branched to a new discussion. RSS

    imdpd/Expdp Problem on the same windows server

    714099
      Hi,

      I am new to oracle and have lots of questions and errors ...

      Now I have to do an expdp and imdpd of an db on my_server. The impdp-db is another oracle instance running on my_server.
      I did this on my_server:

      DB1 is on:
      -     DB1MASTER=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1MASTER
      -     DB1=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1USER

      DB2 is on:
      -     DB2MASTER=C:\ORACLE\PRODUCT\10.2.0\DB_1\DB2MASTER
      -     DB2=C:\ORACLE\PRODUCT\10.2.0\DB_1\DB2USER



      Expdp system-user/pw@DB1 full=Y directory=exp_dir dumpfile=dump1.dmp logifle=log.export.txt
      impdp system-user/pw@DB2 full=Y directory=imp_dir dumpfile=dump1.dmp logfile=log.import.txt

      my_server is a windows server 2003 R 2.

      The log file tells me:
      ;;;
      Import: Release 10.2.0.1.0 - Production on Monday, 27 July, 2009 15:48:04

      Copyright (c) 2003, 2005, Oracle. All rights reserved.
      ;;;
      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
      With the Partitioning, OLAP and Data Mining options
      Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
      Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@CQDBMBA full=Y directory=imp_dir dumpfile=dump.dmp logfile=log.import.cqdbmba_script1.txt
      Processing object type DATABASE_EXPORT/TABLESPACE
      ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
      ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
      ORA-31684: Object type TABLESPACE:"TEMP" already exists
      ORA-31684: Object type TABLESPACE:"USERS" already exists
      ORA-39083: Object type TABLESPACE failed to create with error:
      **ORA-01119: error in creating database file 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1MASTER'
      **ORA-27038: created file already exists
      OSD-04010: <create> option specified, file already exists
      Failing sql is:
      CREATE TABLESPACE "DB2MASTER" DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1MASTER' SIZE 2147483648 AUTOEXTEND ON NEXT 2097152 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEG
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01144: File size (5898240 blocks) exceeds maximum of 4194303 blocks
      Failing sql is:
      CREATE TABLESPACE "DB1" DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1USER' SIZE 48318382080 AUTOEXTEND ON NEXT 2147483648 MAXSIZE 33554431M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
      Processing object type DATABASE_EXPORT/PROFILE
      ORA-31684: Object type PROFILE:"MONITORING_PROFILE" already exists
      Processing object type DATABASE_EXPORT/SYS_USER/USER

      I thought that with the import-connection it will use the datafile from DB2 definitions.

      Any help on this ?

      Thanks
      Michael