Q
Manage Learn to apply best practices and optimize your operations.

How to precreate tablespaces in Oracle before a new database import

Preparing to import a dump file into a new database? Learn what to do to prepare, including precreating the needed tablespaces.

I have a database dump from the Oracle 9i Std version and I created a new database (installed the same version) in another PC. The dump file is to be imported in the new database . What should be done in a new database before starting the import? The command used to expprt and importare:

exp ucs/ucs file=path log=path compress=y grants=y statistics=none

imp ucs/ucs file=path log=path fromuser=ucs touser=ucs statistics=none

Can you suggest a solution?

The big thing I always do before an import is to precreate the needed tablespaces. That way I know they are where they need to be. If the dump file is a FULL database dump, then you can import with FULL=Y and it will create all of your users, roles and everything else. If you do not have a full database export, you will also need to precreate any users and roles.

Dig Deeper on Oracle database backup and recovery

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