Re: Simple data transfer from Oracle 10g to an SQL DB

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 10 Jun 2006 04:57:47 GMT
Message-ID: <pan.2006.06.10.04.57.55.246896@gmail.com>

On Fri, 09 Jun 2006 08:30:19 -0700, RobbMichel wrote:

> I want to set up a data transfer anytime a row is added to a table in
> an my Oracle 10g database to an SQL database.

I am totally confused. You want to transfer from Oracle (which is a SQL database) to another Oracle? Or perhaps to another product that is based on SQL - such as Microsoft SQL Server?

If the former, use DB Links.

If the latter, use Heterogeneous services and ODBC. (Documented in the 10g documentation at
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-HET)

-- 
/Hans ... mailto: Fuzzy_dot_GreyBreard_at_gmail_dot_com
Top posting in newsgroups is a sure way to stop my replies!
I reserve the right to change my mind on anything.  Especially when 
confronted with facts that are better than the ones I use right now.

Received on Fri Jun 09 2006 - 23:57:47 CDT