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

How to use Oracle's export and import utilities

Our Database Backup and Recovery expert explains how to use Oracle's import and export utilities to copy production data in to test.

I have to copy production data in to test. The data size is 100GB. The database version is 9.2.0.3 and the platform is Sun Solaris. What is the best way to do this?
I have to copy production data in to test. The data size is 100GB. The database version is 9.2.0.3 and the platform is Sun Solaris. What is the best way to do this?

For me, the best way to do this is to use Oracle's export and import utilities. The exp utility can be used to dump the entire production schema(s) and then imported into test. Please see the follow docs for more information on exp and imp:

Oracle 9i Database Utilities Guide

Dig Deeper on Oracle database administration

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