Hi Masters,
I took dmp file from oracle11g(11.2.0.2) version . and I need to import in 12.2.0.1 version db. while doing import i am getting errors.
in 11g .. username : hdm_dbuser3
TABLESPACE_NAME
------------------------------
HDM_DBUSER3_DATA
HDM_DBUSER3_DATA_P001
HDM_DBUSER3_DATA_P002
HDM_DBUSER3_DATA_P003
HDM_DBUSER3_DATA_P004
HDM_DBUSER3_INDEX
HDM_DBUSER3_INDEX_P001
HDM_DBUSER3_INDEX_P002
HDM_DBUSER3_INDEX_P003
HDM_DBUSER3_INDEX_P004
HDM_DBUSER3_LARGE_DATA
HDM_DBUSER3_LARGE_INDEX
HDM_DBUSER3_LARGE_LOB
HDM_DBUSER3_REPORTS_DATA
HDM_DBUSER3_REPORTS_INDEX
HDM_DBUSER3_REPORTS_LOB
HDM_DBUSER3_TEMP
same table spaces I have created .. in 12.2.01. as HDM18_DBUSER.
HDM18_DBUSER_DATA
HDM18_DBUSER_DATA_P001
HDM18_DBUSER_DATA_P002
HDM18_DBUSER_DATA_P003
HDM18_DBUSER_DATA_P004
HDM18_DBUSER_INDEX
HDM18_DBUSER_INDEX_P001
HDM18_DBUSER_INDEX_P002
HDM18_DBUSER_INDEX_P003
HDM18_DBUSER_INDEX_P004
HDM18_DBUSER_LARGE_DATA
HDM18_DBUSER_LARGE_INDEX
HDM18_DBUSER_LARGE_LOB
HDM18_DBUSER_REPORTS_DATA
HDM18_DBUSER_REPORTS_INDEX
HDM18_DBUSER_REPORTS_LOB
HDM18_DBUSER_TEMP
USER CREATED
+++++++++++++
Create user HDM18_DBUSER identified by xxxxxxxxx
Default tablespace HDM18_DBUSER_DATA
Temporary tablespace HDM18_DBUSER_TEMP;
Grants
--------
Grant connect,resource to HDM18_DBUSER;
Grant unlimited tablespace to HDM18_DBUSER;
Grant read,write on directory data_pump_dir_1 to HDM18_DBUSER;
GRANT create session, create table, create view,create type to HDM18_DBUSER;
grant create any materialized view to HDM18_DBUSER;
grant DATAPUMP_IMP_FULL_DATABASE to HDM18_DBUSER;
grant become user to HDM18_DBUSER;
import commond
++++++++++++++
Import command
++++++++++++++
impdp directory=DATA_PUMP_DIR_1 dumpfile=HS_36450_backup.dmp logfile=HS_36450_backup.log transform=oid:n remap_schema=HDM_DBUSER3:HDM18_DBUSER REMAP_TABLESPACE=HDM_DBUSER3_DATA:HDM18_DBUSER_DATA,HDM_DBUSER3_DATA_P001:HDM18_DBUSER_DATA_P001,HDM_DBUSER3_DATA_P002:HDM18_DBUSER_DATA_P002,HDM_DBUSER3_DATA_P003:HDM18_DBUSER_DATA_P003,HDM_DBUSER3_DATA_P004:HDM18_DBUSER_DATA_P004,HDM_DBUSER3_temp:HDM18_DBUSER_temp,HDM_DBUSER3_INDEX:HDM18_DBUSER_INDEX,HDM_DBUSER3_INDEX_P001:HDM18_DBUSER_INDEX_P001,HDM_DBUSER3_INDEX_P002:HDM18_DBUSER_INDEX_P002,HDM_DBUSER3_INDEX_P003:HDM18_DBUSER_INDEX_P003,HDM_DBUSER3_INDEX_P004:HDM18_DBUSER_INDEX_P004,
HDM_DBUSER3_LARGE_LOB:HDM18_DBUSER_LARGE_LOB,HDM_DBUSER3_LARGE_DATA:HDM18_DBUSER_LARGE_DATA,HDM_DBUSER3_LARGE_INDEX:HDM18_DBUSER_LARGE_INDEX,HDM_DBUSER3_REPORTS_INDEX:HDM18_DBUSER_REPORTS_INDEX,HDM_DBUSER3_REPORTS_DATA:HDM18_DBUSER_REPORTS_DATA,HDM_DBUSER3_REPORTS_LOB:HDM18_DBUSER_REPORTS_LOB
but getting errors
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39112: Dependent object type TRIGGER:"HDM18_DBUSER"."TEMP_DEV_LAST_CONTACT_TRIG" skipped, base object type TABLE:"HDM18_DBUSER"."DEVICE" creation failed
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
ORA-39112: Dependent object type INDEX:"HDM18_DBUSER"."IX_PROT_DM_ID_NAME" skipped, base object type TABLE:"HDM18_DBUSER"."PARAMETER" creation failed
ORA-39112: Dependent object type REF_CONSTRAINT:"HDM18_DBUSER"."FK_FUNCTIONMETAINFO_ID" skipped, base object type TABLE:"HDM18_DBUSER"."T_ALA_JCFSOURCEIMPORT" creation failed
ORA-39112: Dependent object type CONSTRAINT:"HDM18_DBUSER"."PK_RPT_POLICYACTIONARGUMENT" skipped, base object type TABLE:"HDM18_DBUSER"."RPT_POLICYACTIONARGUMENT" creation failed
ORA-39083: Object type INDEX:"HDM18_DBUSER"."SUBS_BATCH_UPDATE_SN_IDX" failed to create with error:
ORA-00959: tablespace 'HDM_DBUSER_INDEX' does not exist
HDM_DBUSER_INDEX -- why this table space I have to create?
BR
Frd