Friday, 8 March 2019

how to import multiple partition using impdp

Dump for entire schema available now we require to import 3 partition only into the another schema

Script-

impdp test/test
directory=dumpfile
dumpfile=user_full_schema.dmp
logfile=multiple_partition_import_remap_schema.log
tables=user.tablename1:partitionname1,user.tablename1:partitionname2,user.tablename1:partitionname3
remap_schema=user:test


Note: It will create a table with all partitions but data will import only above mentioned partitioned. Don't Worrry..

If any additional help is required Please write us at : dbtechsolutions17@gmail.com

Thanks
DB Tech Solutions


Prerequisite Check “CheckActiveFilesAndExecutables” Failed

While applying a patch to oracle binary using opatch utility, got below error. Error -  $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patc...