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

To-do's for creating a database

Is there a clear "list" of to do's when creating a new database (9.2), to import user exports from 9.0? The full export fails since the last security patch, so I am attempting to "upgrade" with a completely new install to a test SID with a separate Oracle home.
If you have a full export, then the only thing you really need to do is to create a new, empty database and the import should work. The full import of the full export will create all users, roles, tablespaces, and all of the user's objects. This assumes that you are using the same directory structure for your new database. If not, then you'll have to precreate your tablespaces with the new directory structure. Running import with SHOW=Y will get you the DDL statements to create your tablespaces.

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close