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

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.