utility that I will run daily to copy data from 10g to 8i

utility that I will run daily to copy data from 10g to 8i? any ideas
dtotten800Asked:
Who is Participating?
 
sdstuberCommented:
easiest is copy across database link


insert into your_8i_table(col1,col2,col3) select * from your_10g_table@your_10g_db_link where .....

if not that, then export (with 8i exp) then import (with 8i imp)
0
 
slightwv (䄆 Netminder) Commented:
What data?  Entire tables, parts of tables?

Are the databases on the same network?

If so, you might also look at the sqlplus COPY command.  This doesn't require a database link.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.