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: Can I use an O8 database as a transit database between a O9 and an O7 database?

Re: Can I use an O8 database as a transit database between a O9 and an O7 database?

From: Van Messner <messner1_at_NOSPAMbestweb.net>
Date: Mon, 24 May 2004 17:52:51 -0400
Message-ID: <10b4rqkon3feba3@corp.supernews.com>


yes

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message news:7fm4b05a4mbbb4jub1urin1j163jjsc7vg_at_4ax.com...
> Hi all,
>
> We will gradually migrate our application data from a O7 database to a
> new O9 database. The application data is also written to an O7
> datawarehouse via a database link. In the intermediate period data has
> to be written to the O7 datawarehouse db from the old O7 application
> db and also from the new O9 database. I did a test to see if could do
> an insert from the O9 database over a database link into the O7
> datawarehouse database, but this is not supported. Then I did the
> following:
>
> - create a dblink in the O9 database to a O8 database
> - create a dblink in the O8 database to the O7 database
> - create a synonym in the O8 database to the desired table in the O7
> database
> - create a synonym in the O9 database to the synonym in the O8
> database
>
> Now in the O9 database I inserted a record into the synonym, which
> indeed resulted in a record in the O7-table.
>
> Would it be a sensible solution to use an O8 database as a transit
> database in this way?
>
> Jaap.
Received on Mon May 24 2004 - 16:52:51 CDT

Original text of this message

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