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

Exporting data only to new database

I have a new database created in Oracle 9i. Except for data it has all the other objects in this database. I'd like to export the data only from the old database and import it to the new database.

I have a new database created in Oracle 9i on my new laptop. Except for data it has all the other objects in this database. My old laptop has the same database but with data. I'd like to export the data only from the database on the old laptop and import it to the new database. Please advise on how to do this. Is it possible to export data alone and import it into another database? Thanks.
First, create a dump of your database. In this exercise, I'm going to assume that you only want to dump data belonging to a specific schema. This example will use the SCOTT schema. On the old laptop, run the following:
exp userid=system file=my_dump.dmp 
owner=scott

Now that you have the dump file created with the export utility, copy the dump file to the new laptop. You can...

use any OS routine to copy the file. If you use FTP, make sure you transfer in binary mode.

Once the dump file is on the new server, use the import utility to import the contents of the dump file.

imp userid=system file=my_dump.dmp 
fromuser=scott touser=scott
This was last published in July 2006

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close