Datapump Export Table Level

Datapump Export--->Table Level ------------------------------Description: -----------Here i Exported table named like table3 from test1 schema and "doyen" database. Syntax: ------[oracle@sys34 ~]$ expdp test1/test1 directory=data_pump_dir1 dumpfile=table3.dmp tables=table3 Logfile: -------Export: Release 10.2.0.1.0 - Production on Tuesday, 26 August, 2008 11:36:22 Copyright (c) 2003, 2005, Oracle.

All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Production With the Partitioning, OLAP and Data Mining options Starting "TEST1"."SYS_EXPORT_TABLE_01": test1/******** directory=data_pump_dir1 dumpfile=table3.dmp tables=table3 Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 0 KB Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "TEST1"."TABLE3" 0 KB 0 rows Master table "TEST1"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for TEST1.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/oradata/doyen/datapump_dir/table3.dmp Job "TEST1"."SYS_EXPORT_TABLE_01" successfully completed at 11:36:30