Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to extract data fields?

Re: How to extract data fields?

From: Sarah Sikes <sikes_at_erols.com>
Date: 1998/02/08
Message-ID: <34dd5615.54405661@news.erols.com>#1/1

>I need to extract quite a few data fields from two different Oracle
>databases. The conditions for extracting these fields are in the two
>databases. I don't know what tools I should use to do the extraction -- C,
>SQL? Your expertise is highly appreciated.
>Please reply to this account. I do not have access to the group network.
>Thank you so much.
>

Create a database link between the two databases. Then extract the data with a SQL*Plus select statement. You should work with your dba on creating the database link. Received on Sun Feb 08 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US