Export and Import Data Pump Utility

This Export (EXPDP) and Import (IMPDP) utilities are introduced in Oracle 10g for full or partial data export and import. 

It has many new features compared with the old version of Export (EXP) and Import (IMP) utilities.

Additional features :- 

1. We can compress the datas when export. so that the dump file size will be reduced.

2. We can Split the export as jobs. And start/stop/restart it when ever needed.

3. We can export specific database object of specific database users and specific tablespaces alone.

4. When Import we can remap the user to another user. i.e when we export a user objects and want to import it as another user object it will be useful.

5. Same way we want to remap the objects from one tablespace to another tablespace when importing. 

6. We can import the database when exporting the database. Which looks like direct export and import of database/users/objects from one system to another system in the network.

Here Code given will be used to achieve 4 and 5.

EXPDP 'SYS/ORACLE@NEW AS SYSDBA' SCHEMAS=SCOTT DUMPFILE=STS.DMP

IMPDP 'SYS/ORACLE22@ORCL22 AS SYSDBA' DUMPFILE=STS.DMP REMAP_SCHEMA=SCOTT:RMVER REMAP_TABLESPACE=USERS:RMVER

This code will be used to achieve 6

create database link dbl2  connect to  rmver721 identified by rmver721 using '(DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = DB_SERVER)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = orcl)
   )
)';

IMPDP 'SYS/ORACLE22@ORCL22 AS SYSDBA' SCHEMAS=SCOTT REMAP_SCHEMA=SCOTT:RMVER REMAP_TABLESPACE=USERS:RMVER NETWORK_LINK=dbl2

Have Updated and Use Features

Thanks 

Have a nice day.