2 Replies Latest reply: Sep 25, 2013 4:24 AM by Anar Godjaev RSS

    IMPDP problem

    JIC

      Hi I am getting strange problem, from full expdp, when I am trying to import "impdp" the user's data(sirsi user) from production database to test database (test user), here I found when I am trying to "impdp" ,it changing the test database password (same password of production).

      Ex: let as assume

      the production database password: production123

      the test database password: test123

      but when I try to Import "impdp" production to test database:

      F:\expdp>impdp directory=expdp dumpfile=21092013_JICLIBDB.DMP logfile=imp_sirsi.log remap_schema=sirsi:test statistics=none

       

      Impdp successful but no data was import to user (test user).

      And also I am getting following error:

      CREATE TABLESPACE "ACCOUNTABILITY_DAT" DATAFILE 'D:\ORACLE\APP\PRODUCT\11.2.0\JICLIBDB\ACCOUNTABILITY01.DAT' SIZE 10485760 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 819

      ORA-39083: Object type TABLESPACE failed to create with error:

      ORA-01119: error in creating database file 'D:\ORACLE\APP\PRODUCT\11.2.0\JICLIBDB\ACCOUNTABILITY01.IDX'

      ORA-27040: file create error, unable to create file

      OSD-04002: unable to open file

      O/S-Error: (OS 21) The device is not ready.

       

      My database version : 11..2.0.1

      OS: windows