Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Tool for migrating data between databases

I need to migrate some data (maybe insert date on or after a certain date) in ORACLE_DB_1 to another Oracle database ORACLE_DB_2. Is there any tool to do this? After migration, the record will be removed from the ORACLE_DB_1.

I have an Oracle housekeeping question. What I need to do is migrate some data (maybe insert date on or after a certain date) in ORACLE_DB_1 to another Oracle database ORACLE_DB_2. Is there any tool to do this? After migration, the record will be removed from the ORACLE_DB_1.

I would suggest creating a database link from DB_1 to DB_2. Let's assume the database link is created in DB_1 and connects to DB_2, and is called db2_link. You can insert across the database link with a command similar to the following:

INSERT INTO dest_table@db2_link 
SELECT * FROM source_table WHERE date_column BETWEEN first_date AND last_date;

The "@db2_link" tells Oracle that the table is in a remote database accessed by the database link you created. The Oracle Administrator's Guide gives complete details on how to set up the database link. Pay particular attention to Part VII, Distributed Database Management. Chapter 29 shows you how to create a database link and use it in your SQL statements.

Dig Deeper on Oracle database design and architecture

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