DBA GENESIS
Courses
Contact
Members
More
I want to export only tables of schema including index and trigger.
You want to export only the tables, you can also add include=table:
expdp \'/ as sysdba\' schemas=CTSCOB include=table
The above exports the tables with indexes and triggers, but it skips procedures, sequences and other objects not directly related to tables.
You can export of tables that start with “CRM” of MSDB schema as follows.
expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=SchemaBackup%U.dmp schemas=MSDB logfile=SchemaBackup.log parallel=64 cluster=n INCLUDE=TABLE:"LIKE 'CRM%'"
You want to export only the tables, you can also add include=table:
expdp \'/ as sysdba\' schemas=CTSCOB include=tableThe above exports the tables with indexes and triggers, but it skips procedures, sequences and other objects not directly related to tables.
You can export of tables that start with “CRM” of MSDB schema as follows.
expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=SchemaBackup%U.dmp schemas=MSDB logfile=SchemaBackup.log parallel=64 cluster=n INCLUDE=TABLE:"LIKE 'CRM%'"