Friday, July 24, 2009

How to export all tables in a schema without specifying table names

exp utility doesn't have an option to export all tables in a schema. One has to give list of tables which is painful when the schema is huge.

The Data Pump Utility has an option [INCLUDE=TABLE_DATA] to achieve this.

example: expdp username/password dumpfile=username.dmp INCLUDE=TABLE_DATA