Re: Multiple Databases/Multiple Instances

Hi.

    If I understand your problem correctly one solution is to use the CREATE DBLINK statement. You can then use statements like

    INSERT INTO <table_new>
    SELECT <list> FROM <table_old>@<link_name>;

Regards
Jerry Gitomer

Steven R Fuller wrote in message
<37C8269E.1B81B2A3_at_doitnow.com>...
>Please Help!!!, What is the best way to pull data from one
dataabse to
>another.
>
>I want to extract data from database 1, called prod1
>manipulate the data
>and load it onto database 2, called prod2
>
>Is this depenendent upon the tnsnames.ora file? At this point I
have to
>disconnect
>from prod1 and reconnect to prod2
>
>
Received on Mon Aug 30 1999 - 08:16:56 CDT