Export the Schemas
Export: ----------- When You perform Full export of database or Schema, you may need excluding some schemas or tables. Especially your database or Schemas are too big, probably you need to exclude some schemas or tables during full export of database or Schema export. You can add the EXCLUDE option to expdp command, EXCLUDE syntax: EXCLUDE=object_type[:name_clause] [, ...] expdp ... SCHEMAS=scott EXCLUDE=SEQUENCE, TABLE:\"IN ('EMP', 'DEPT')\" Exclude Table in Oracle For Example; Scenario 1: I want to export MSDB Schema , If I need full schema export , following command can perform this. expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=SchemaBackup%U.dmp schemas=MSDB logfile=SchemaBackup.log parallel=64 cluster=n Scenario 2: But,I want to Exclude Some tables from MSDB Schema, All tables except this excluded tables will be exported by using EXCLUDE option as follows. If you don’t use parfile ( parameter file ),you can get the quote marks errors ...