Include Select statement in EXPDP Posted by MOHAMMED ABDUL HAMEED on 3:38 PM

Create a parameter file with all the details as follows :

DIRECTORY = DATA_PUMP_DIR
DUMPFILE = hyd11.dmp
LOGFILE = hyd_lg.log

include=TABLE:"IN (select table_name from dba_tables where table_name like 'NAM%')"

 include=table:\"in\(select table_name from all_tables where table_name like \'NAM%\')\"
                               

Now Export it by using the below syntax of export :

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

Export: Release 11.2.0.3.0 - Production on Sat Nov 26 05:00:46 2016

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

Username: hameed
Password: 

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 "HAMEED"."SYS_EXPORT_SCHEMA_01":  hameed/******** PARFILE=/home/oracle/Desktop/hyd.par 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "HAMEED"."NAME"                             5.828 KB       1 rows
. . exported "HAMEED"."NAMEALL"                          5.828 KB       1 rows
. . exported "HAMEED"."NAMEFEW"                          5.828 KB       1 rows
Master table "HAMEED"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HAMEED.SYS_EXPORT_SCHEMA_01 is:
  /u01/app/oracle/admin/hyd/dpdump/hyd11.dmp

Job "HAMEED"."SYS_EXPORT_SCHEMA_01" successfully completed at 05:00:57