Copy table to different schema through IMPDP

·         How to copy table from one schema to another schema (you can also use the same method to copy table to different database in different schema)

       

       Database version 11.2.02

       Database Name: XE

       Source schema: HR, Table Name: REGIONS

       Target schema: HNR

  

       (1)      Take full schema  EXPDP datapump backup.

   

-                       Create .par file (exp.par)

               USERID=system/pwd@XE

               DIRECTORY=EXPDP_DIR

               DUMPFIE=EXPDP_FULLXE_071014.dmp

               LOGFILE=EXPDP_FULLXE_071014.log

               SCHEMAS=HR

2    (2)    Crosscheck in HNR schema that table does not exist.

(      (3)    Now from the schema dump , we will restore only REGIONS table in HNR schema

-                          Create .par file (imp.par)

                USERID=system/pwd@XE

                DIRECTORY=EXPDP_DIR

                DUMPFILE=EXPDP_FULLXE_071014.dmp

                LOGFILE=IMPDP_FULLXE_071014.log

                REMAP_SCHEMA=HR:HNR

                TABLES=HR.REGIONS

-                        Execute the IMPDP command.

-                       You will see the below screen.

          (4)      Now the table REGIONS is successfully restored in HNR schema.

                   (5)  We will also cross-check whether all the rows are matched with HR. REGIONS table or not.

I HOPE THIS BLOG WILL BE HELPFUL FOR YOU.

SEND YOUR SUGGESTIONS/QUERIES TO kaushaldaveit@gmail.com

Ora-12170 TNS CONNECT TIMEOUT OCCURRED

An ORA-12710 error occurs when SQL*Net cannot connect to its
destination. Common causes are firewalls blocking connections and
network routing errors.

Open firewall settings and ensure the listener  port is not blocked.

For example, on a Windows system, navigate to
 Control Panel-> Security Center-> Windows Firewall-> Exceptions.
Click on Add port and add port  1521 or whatever port the listener is
running on (see listener.ora).