The contents of the dump file depend on the parameters you use. If you specify just the TABLES parameter, then the table you specify along with any indexes and triggers on that table are exported. If you specify the OWNER parameter, then the entire contents of that schema (tables, indexes, views, triggers, stored procedures, sequences, functions, etc.) will be in the dump file. If you specify the FULL parameter, then the entire contents of the database will be present.
You can modify the contents slightly with parameters like the INDEXES parameter. Specifying TABLES=my_table and INDEXES=N will dump the MY_TABLE table contents to the dump file, but will not include indexes. The TRIGGERS parameter can be set to N to stop trigger definitions from being dumped. Statistics can also be present in your dump file depending on the setting of the STATISTICS parameter.
I highly recommend reading the Oracle Utilities guide for more information on all of the export and import parameters.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.