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

Home -> Community -> Mailing Lists -> Oracle-L -> Transparent database objects after merging

Transparent database objects after merging

From: <Ukrit.Kuprasit_at_allianz.com.sg>
Date: Wed, 16 Jul 2003 10:33:11 +0800
Message-Id: <25929.337923@fatcity.com>


This is a multipart message in MIME format. --=_alternative 000E067048256D65_=
Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello Gurus,

        I'm working merging 2 databases which have sane structure of=20 database objects into one database. However, after merging, the business=20 policies and regulations force us to have 2 set of database objects; for=20 example :=20
Database A has CUSTOMERS table.
Database B has CUSTOMERS table.

After merging database A will have CUSTOMERS and CUSTOMERS=5FB (data from=20 database B). I just wonder that is there any way that we don't need to=20 change our script in forms and reports to point into a new table name but=20 still can access to the data in the new table ( CUSTOMERS=5FB) not=20 CUSTOMERS.
Thank you for any comment and suggestion. Ukrit K,

--=_alternative 000E067048256D65_=
Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

<br><font size=3D3 face=3D"Times New Roman">Hello Gurus,</font>
<br><font size=3D3 face=3D"Times New Roman">&nbsp; &nbsp; &nbsp; &nbsp; I'm=

 working merging 2 databases which have sane structure of &nbsp;database ob=
jects into one database. However, after merging, the business policies and =
regulations force us to have 2 set of database objects; for example : </fon=
t>
<br><font size=3D3 face=3D"Times New Roman">Database A has CUSTOMERS table.=
</font>
<br><font size=3D3 face=3D"Times New Roman">Database B has CUSTOMERS table.=
</font>
<br>
<br><font size=3D3 face=3D"Times New Roman">After merging database A will h=
ave CUSTOMERS and CUSTOMERS=5FB (data from database B). I just wonder that =
is there any way that we don't need to change our script in forms and repor=
ts to point into a new table name but still can access to the data in the n=
ew table ( CUSTOMERS=5FB) not CUSTOMERS.</font>
<br><font size=3D3 face=3D"Times New Roman">Thank you for any comment and s=
uggestion.</font>
<br><font size=3D3 face=3D"Times New Roman">Ukrit K,</font>
<br>
Received on Tue Jul 15 2003 - 21:33:11 CDT

Original text of this message

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