Q
Problem solve Get help with specific problems with your technologies, process and projects.

What does the dump file consist of?

When I export a dump from a database, what does the dump file consist of? Are all the views, triggers, procedures and packages in the dump file?

When I export a dump from a database, what does the dump file consist of? Are all the views, triggers, procedures and packages in the dump file?

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.

This was last published in December 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close