Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

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
0
dtotten800
Asked:
dtotten800
2 Solutions
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now