BEGIN INSERT INTO my_10g_table SELECT * FROM my_9i_table@9i_db_link; END;The above PL/SQL block can be put into a stored procedure or can be put into the Scheduler to be run periodically. The "@9i_db_link" tells Oracle to access the table in the database denoted by the link. Please read the Oracle Administrators Guide and Concepts Guide (available at http://tahiti.oracle.com) for information on setting up database links.
Dig Deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.