Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

What happens to data dictionary and system tables during upgrade

While upgrading the database from 8.0.6, we exported the database with Full=Y option. Now after installing a fresh...

database version 8.1.7, while using import of the entire dump, what will happen to the data dictionary and system tables owned by sys and system user?

The data dictionary tables owned by SYS are never exported, even if you specify FULL=Y on export. This is because any objects in the data dictionary will be rebuilt when you import into the new database. Don't worry about exporting and importing SYS. The export and import utilities will take care of everything for you.

The SYSTEM user is a little different. While objects owned by SYSTEM may be important, they are not data dictionary objects. So these objects will be exported and imported if performing FULL versions of export and import.

For More Information

This was last published in February 2003

Dig Deeper on Oracle database design and architecture

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.