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
>>,it changing the default database password.
what do you mean by default password. you are doing schema export/import, if schema does not exist it will create the schema will all the inherited property of source one.
to prevent this you can create the schema before import and during import it will skip/error for the create statement only.