Export / Import by using Parameter File Posted by MOHAMMED ABDUL HAMEED on 2:34 PM

Export :

Create a parameter file with all the details as follows :

DIRECTORY = DATA_PUMP_DIR
DUMPFILE = hyd.dmp
LOGFILE = hyd_lg.log
TABLES = hameed.info

Now Export it by using the below syntax of export :

[oracle@stndby ~]$ expdp PARFILE='/u01/hyd.par'

Export: Release 11.2.0.3.0 - Production on Sat Nov 26 03:31:46 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYS"."SYS_EXPORT_TABLE_01":  /******** AS SYSDBA PARFILE=/home/oracle/Desktop/hyd.par 

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

. . exported "HAMEED"."INFO"                             5.828 KB       1 rows

Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_TABLE_01 is:

  /u01/app/oracle/admin/hyd/dpdump/hyd.dmp

Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 03:32:04

Import :

Create a parameter file with all the details as follows :

DIRECTORY = DATA_PUMP_DIR
DUMPFILE = hyd.dmp
LOGFILE = hyd_lg.log
TABLES = hameed.info

Now Import it by using the below syntax of import :

[oracle@localhost ~]$ impdp PARFILE=/home/oracle/Desktop/hyd.par

Import: Release 11.2.0.3.0 - Production on Sat Nov 26 04:02:31 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01":  /******** AS SYSDBA PARFILE=/home/oracle/Desktop/hyd.par 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "HAMEED"."INFO"                             5.828 KB       1 rows
Job "SYS"."SYS_IMPORT_TABLE_01" successfully completed at 04:02:38