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
Friday, July 24, 2009
Subscribe to:
Posts (Atom)
Posts
