![]() ![]() Starting “SYS”.”SYS_EXPORT_SCHEMA_01″: AS SYSDBA” parfile=oracledbwr. INCLUDE=TABLE:”IN ~]$ expdp \” as sysdba\” parfile=oracledbwr.parĮxport: Release 21.0.0.0.0 – Production on Sun Sep 11 20:18:09 2022 Master table “SYS”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Storing the parameters in a file allows them to be easily modified or reused, and is the recommended method for invoking Export. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ![]() Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Starting “SYS”.”SYS_EXPORT_SCHEMA_01″: AS SYSDBA” schemas=scott dumpfile=emp_dept1.dmp logfile=emp_dept1.log directory=data_pump_pdb include=table:”in (‘EMP’)” exclude=table:”in (‘DEPT’,’BONUS’,’SALGRADE’)” All rights reserved.Ĭonnected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production ![]() Any objects specified by the EXCLUDE parameter that are in the list of include objects are removed as the command executes.Įxclude=”table:\”in (‘DEPT’,’BONUS’,’SALGRADE’)\”” Then it processes the exclude parameters. When you include both parameters in a command, Oracle Data Pump processes the INCLUDE parameter first, and include all objects identified by the parameter. Starting with Oracle Database 21c, Oracle Data Pump permits you to set both INCLUDE and EXCLUDE parameters in the same command. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |