![]() Processing object type SCHEMA_EXPORT/TABLE/TABLE Total estimation using BLOCKS method: 128 KB Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Starting "SYS"."SYS_EXPORT_SCHEMA_01": sys/******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:"IN (\'EMP\', \'JOBS\')"Įstimate in progress using BLOCKS method. Opps!!!! What’s that!! I didn’t knew this – “table mode exports only allow objects from one schema”.Does that mean we can’t take export of tables from different schemas in one command.Lets try something differentĭ:\>expdp directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:\"IN (\'EMP\', \'JOBS\')\"Įxport: Release 10.2.0.4.0 - Production on Monday, 18 October, 2010 22:30:06 UDE-00012: table mode exports only allow objects from one schema Įxport terminated successfully without warnings.ĭ:\>expdp directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log tables='scott.emp','hr.jobs'Įxport: Release 10.2.0.4.0 - Production on Monday, 18 October, 2010 22:28:42Ĭopyright (c) 2003, 2007, Oracle. With the Partitioning, OLAP, Data Mining and Real Application Testing optionsĮxport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setĪbout to export specified tables via Conventional Path. ![]() All rights reserved.Ĭonnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production ![]() Suppose you are asked to take export backup of SCOTT’s emp and HR’s jobs tables, how would you do it?ĭ:\>exp file= exp_test.dmp log=exp_test.log tables='scott.emp','hr.jobs' feedback=10Įxport: Release 10.2.0.4.0 - Production on Mon Oct 18 22:25:05 2010Ĭopyright (c) 1982, 2007, Oracle. Recently i saw a thread in OTN forum where it was asked “How to export (using EXPDP) tables from different schemas in a single expdp commad”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |