| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Transparent database objects after merging
This is a multi-part message in MIME format.
------_=_NextPart_001_01C34B5E.DD5541FD
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Ave !
=20
If it's so, that user_a like to use customer table and user_b customer_b
table with same application, why You can't use synonyms? User_a synonyms
points to customer table and user_b synonyms points customer_b table =
etc.
=20
Or is there some decision making before start using application: "Now I =
want
use customer table and now I want user customer_b table"? If so, create =
two
database users, whose synonyms points to different tables. When user =
logs in,
he selects appropriate login username depends, which tables he wants to =
use.
=20
Too simple :) ?
=20
HTH
Jorma
=20
-----Original Message-----
From: ext Ukrit.Kuprasit_at_allianz.com.sg =
[mailto:Ukrit.Kuprasit_at_allianz.com.sg]
Sent: 16 July, 2003 07:29
To: Multiple recipients of list ORACLE-L
Subject: Re: Transparent database objects after merging
Thank you for your idea, Mark,=20
To explain more about the problem=20
Before we have 2 databases which they both have same sturcture =
and same database objects names. We have 2 set of D2K forms and reports =
to access to each database.=20
After merging, we looking for move data from database B to = database A but still be able to access by using the different of forms = and reports. However the tables which be move from database B to datbase = A, will be rename to <table>_B.=20
The developer just throw me a fire ball that what-if they don't =
modify the forms and reposts, is it possible to have one set of the =
forms access the <table>_B=20
UK=20
"Mark Richard" <mrichard_at_transurban.com.au>=20 Sent by: ml-errors_at_fatcity.com=20
07/16/2003 12:14 PM=20
Please respond to ORACLE-L=20
=20
To: Multiple recipients of list ORACLE-L =
<ORACLE-L_at_fatcity.com>=20
cc: =20
Subject: Re: Transparent database objects after merging
Also, depending on your requirements (which I don't fully understand) another approach may involve using views:
The CUSTOMERS view could point to either CUSTOMERS_A, CUSTOMERS_B or =
even
the merge of both tables (select * from customers_a union all select * =
from
customers_b) if required. Of course you may introduce primary and =
foreign
key problems, but like I said - I don't fully understand your =
requirement
so I'm just throwing ideas up in the air.
Regards,
Mark.
=
=20
"Arup Nanda" =
=20
<orarup_at_hotmail.c To: Multiple =
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> =20
om> cc: =
=20
Sent by: Subject: Re: Transparent =
database objects after merging =20
ml-errors_at_fatcity =
=20
.com =
=20
=
=20
=
=20
16/07/2003 13:59 =
=20
Please respond to =
=20
ORACLE-L =
=20
=
=20
=
=20
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 -----
From: Ukrit.Kuprasit_at_allianz.com.sg
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 15, 2003 11:29 PM
Subject: Transparent database objects after merging
Hello Gurus,
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 :
Database A has CUSTOMERS table.
Database B has CUSTOMERS table.
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.
Thank you for any comment and suggestion.
Ukrit K,
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>=
>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message
(or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the =
sender
by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message=20
that do not relate to the official business of
Transurban City Link Ltd
shall be understood as neither given nor endorsed by it.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>=
>>>>>>>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>=
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--=20
Author: Mark Richard
INET: mrichard_at_transurban.com.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
------_=_NextPart_001_01C34B5E.DD5541FD
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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>Ave =
!</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>If it's so, =
that user_a=20
like to use customer table and user_b customer_b</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>table with same =
application, why You can't use synonyms? User_a =
synonyms</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>points to =
customer table=20
and user_b synonyms points customer_b table etc.</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>Or is there =
some decision=20
making before start using application: "Now I want</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>use customer =
table and now=20
I want user customer_b table"? If so, create two</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>database users, =
whose=20
synonyms points to different tables. When user logs =
in,</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>he selects =
appropriate=20
login username depends, which tables he wants to =
use.</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D379064505-16072003><FONT face=3DArial>Too simple :)=20
?</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=3D379064505-16072003><FONT =
face=3DArial>Jorma</FONT></SPAN></DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> ext=20
Ukrit.Kuprasit_at_allianz.com.sg=20
[mailto:Ukrit.Kuprasit_at_allianz.com.sg]<BR><B>Sent:</B> 16 July, 2003=20
07:29<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B> Re:=20
Transparent database objects after merging<BR><BR></FONT></DIV><BR><FONT =
face=3Dsans-serif size=3D2>Thank you for your idea, Mark,</FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D2> To explain more =
about the=20
problem</FONT> <BR><FONT face=3Dsans-serif size=3D2> =
=20
Before we have 2 databases which they both have same sturcture and same =
database=20
objects names. We have 2 set of D2K forms and reports to access to each=20
database.</FONT> <BR><FONT face=3Dsans-serif size=3D2> =
=20
After merging, we looking for move data from database B to database A =
but still=20
be able to access by using the different of forms and reports. However =
the=20
tables which be move from database B to datbase A, will be rename to=20
<table>_B. </FONT><BR><FONT face=3Dsans-serif size=3D2> = =20 The developer just throw me a fire ball that what-if they don't =modify=20
size=3D1>Sent by: ml-errors_at_fatcity.com</FONT>=20
<P><FONT face=3Dsans-serif size=3D1>07/16/2003 12:14 PM</FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1>Please respond to ORACLE-L</FONT> =
<TD><FONT face=3DArial size=3D1> =
</FONT><BR><FONT=20
face=3Dsans-serif size=3D1> To: = =20
Multiple recipients of list ORACLE-L=20
<ORACLE-L_at_fatcity.com></FONT> <BR><FONT face=3Dsans-serif=20
size=3D1> cc: =
</FONT>=20
<BR><FONT face=3Dsans-serif size=3D1> =
Subject:=20
Re: Transparent database objects after=20
merging</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT face=3DArial =
size=3D2><BR>Also,=20
Mark.<BR><BR><BR><BR> =20 = =20 = =20 = =20 = =20 = =20 =20 <BR> = =20 "Arup Nanda" = =20 = =20 = =20 = =20 <BR> = =20 =20 <orarup_at_hotmail.c To: = =20
=20 <BR> = =20 om> = =20 cc: = =20 = =20 = =20 = =20 <BR> = =20 Sent by: = =20 Subject: Re: Transparent database =objects=20
=20 <BR> = =20 ml-errors_at_fatcity = =20 = =20 = =20 = =20 = =20
=20 .com = =20 = =20 = =20 = =20 =20 <BR> = =20 = =20 = =20 = =20 = =20 = =20 <BR> = =20 = =20 = =20 = =20 = =20 = =20 <BR> = =20 16/07/2003 13:59 = =20 = =20 = =20 = =20 <BR> = =20 Please =respond to=20
= =20 = =20 = =20 = =20 <BR> = =20 ORACLE-L = =20 = =20 = =20 = =20 = =20 <BR> = =20 = =20 = =20 = =20 = =20 = =20 <BR> = =20 = =20 = =20 = =20 = =20 = =20 <BR><BR><BR><BR><BR>You can drop or rename CUSTOMERS =to,=20
K,<BR><BR><BR><BR><<<<<<<<<<<<<<= ;<<<<<<<<<<<<<<<<<<= <<<<<<---->>>>>>>>>>>&= gt;>>>>>>>>>>>>>>>>>&g=t;>>>>>>>><BR> =20 Privileged/Confidential information may be contained in this = message.<BR> =20
=20 that do not relate to the official business of<BR> = =20 =Transurban=20
it.<BR><<<<<<<<<<<<<<<<&l= t;<<<<<<<<<<<<<<<<<<= ;<<<<---->>>>>>>>>>>>>= >>>>>>>>>>>>>>>>>>&= gt;>>>>><BR><BR><BR><BR><BR><<<<<<<&l= t;<<<<<<<<<<<<<<<<<<= ;<<<<<<<<<<<<<<<<<<= <<<<<<---->>>>>>>>>>>&= gt;>>>>>>>>>>>>>>>>>&g= t;>>>>>>>>>>>>>>>>>>=;>><BR>Privileged/Confidential=20
them.<BR><<<<<<<<<<<<<<<<= <<<<<<<<<<<<<<<<<<&= lt;<<<<<<<<<<<<<<<---->&g= t;>>>>>>>>>>>>>>>>>>= ;>>>>>>>>>>>>>>>>>>=>>>>>>>>>>>><BR><BR>--=20
 |
 |