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

Command for full export

I want to do a full exp and imp of a database. I have the database on a server, and I want to take a full export of that database from my system. I can connect to the server and can access that database. What is the command to take the full export? Should I create all the tablespaces and users before the import?

I want to do a full exp and imp of a database. I have the database on a server, and I want to take a full export of that database from my system. I can connect to the server and can access that database. What is the command to take the full export? Should I create all the tablespaces and users before the import?
To perform a full export of your database, use the following:
exp userid=system file=my_db.dmp log=my_db.log full=y
The above assumes your environment points to your database (you have correctly set your ORACLE_HOME and ORACLE_SID environment variables). To import the full contents of the above dump file, you can use the following:
imp userid=system file=my_db.dmp log=imp.log full=y
If your database server has the same directory structure, then a full import of a full export will create the tablespaces for you. If you have a different directory structure, you will want to precreate your tablespaces.

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close