|
-
Ooops i didnt at all read it.
I tried specifying schemas but it started doing schema export.
Then I tried doing table export using query parameter as follows:
C:\>expdp 'hr/hr@orac' dumpfile=t2.dmp logfile=lg2.log tables=hr.employees query=employees:\"where department_id in (50)\"
Export: Release 10.2.0.1.0 - Production on Thursday, 16 July, 2009 17:12:33
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 "HR"."SYS_EXPORT_TABLE_01": 'hr/********@orac' dumpfile=t2.dmp logfile=lg2.log tables=hr.employees query=employees:"where department_id in (
50)"
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
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "HR"."EMPLOYEES" 11.30 KB 45 rows
Master table "HR"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_TABLE_01 is:
E:\ORACLE\ADMIN\ORAC\DPDUMP\T2.DMP
Job "HR"."SYS_EXPORT_TABLE_01" successfully completed at 17:12:59
I hope this time it is right.
lucky
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|