Re: Transparent database objects after merging

From: Arup Nanda <orarup_at_hotmail.com>
Date: Tue, 15 Jul 2003 22:58:54 -0400
Message-Id: <25929.337924@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0057_01C34B24.AA36A680 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

You can drop or rename CUSTOMERS to, say, CUSTOMERS_A, and then create = synonym CUSTOMERS pointing to CUSTOMERS_B. Or rename CUSTOMERS_B to = CUSTOMERS. HTH. Arup Nanda

Original Message -----=20 From: Ukrit.Kuprasit_at_allianz.com.sg=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, July 15, 2003 11:29 PM Subject: Transparent database objects after merging

Hello Gurus,=20

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

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

------=_NextPart_000_0057_01C34B24.AA36A680 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>You can drop or rename CUSTOMERS to, =
say,=20
CUSTOMERS_A, and then create synonym CUSTOMERS pointing to CUSTOMERS_B. = Or=20
rename CUSTOMERS_B to CUSTOMERS.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>HTH.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Arup Nanda</FONT></DIV>
<BLOCKQUOTE=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3DUkrit.Kuprasit_at_allianz.com.sg=20   =
href=3D"mailto:Ukrit.Kuprasit_at_allianz.com.sg">Ukrit.Kuprasit_at_allianz.com.=

sg</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =

title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, July 15, 2003 = 11:29=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Transparent database = objects=20
  after merging</DIV>
  <DIV><BR></DIV><BR><FONT face=3D"Times New Roman" size=3D3>Hello = Gurus,</FONT>=20
  <BR><FONT face=3D"Times New Roman" size=3D3>      =   I'm=20
  working merging 2 databases which have sane structure of =  database=20
  objects into one database. However, after merging, the business = policies and=20
  regulations force us to have 2 set of database objects; for example :=20   </FONT><BR><FONT face=3D"Times New Roman" size=3D3>Database A has = CUSTOMERS=20
  table.</FONT> <BR><FONT face=3D"Times New Roman" size=3D3>Database B = has CUSTOMERS=20
  table.</FONT> <BR><BR><FONT face=3D"Times New Roman" size=3D3>After = merging=20
  database A will have CUSTOMERS and CUSTOMERS_B (data from database B). = I just=20
  wonder that is there any way that we don't need to change our script = in forms=20
  and reports to point into a new table name but still can access to the = data in=20
  the new table ( CUSTOMERS_B) not CUSTOMERS.</FONT> <BR><FONT=20   face=3D"Times New Roman" size=3D3>Thank you for any comment and = suggestion.</FONT>=20
  <BR><FONT face=3D"Times New Roman" size=3D3>Ukrit K,</FONT>=20 Received on Tue Jul 15 2003 - 21:58:54 CDT