OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » consolidation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

consolidation [message #246841]

Fri, 22 June 2007 03:30

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
there is an environment where there is 3 oracle databases and 3 different application; the issue is that i want to consolidate these 3 databases into one database; and there is definitly some common schema between the dartabases since the 3 applications came from the same supplier
is there some documented methodologies for consolidating these databases ?
thanks and regards

Report message to a moderator

Re: consolidation [message #246844 is a reply to message #246841]

Fri, 22 June 2007 03:54

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

export/import with options fromuser/touser with the hope that your supplier supports different schema names.

Regards
Michel

Report message to a moderator

Re: consolidation [message #246845 is a reply to message #246844]

Fri, 22 June 2007 04:00

maoro
Messages: 312
Registered: May 2005

Senior Member

well
the supplier have similar schema within the application, plus he created objects within some default schema like system or sys;
and you would have for instance maoro.emp in database A. and maoro.emo in database B
any help
thanks

Report message to a moderator

Re: consolidation [message #246864 is a reply to message #246845]

Fri, 22 June 2007 04:52

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Too bad.
If schema name is forced there is nothing to do.

Regards
Michel

Report message to a moderator

Re: consolidation [message #246885 is a reply to message #246841]

Fri, 22 June 2007 06:41

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
isnt possible to import schema to a different user and modify the application in order to reference the object ?
like if we have maoro.emp on A and maoro.emp on B

i would on C import maoro.emp to a schema like new_maoro.emp and update the application ..
what do you think
thanks

Report message to a moderator

Re: consolidation [message #246892 is a reply to message #246885]

Fri, 22 June 2007 06:51

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is what I first said: import with options fromuser/touser.

Regards
Michel

Report message to a moderator

Re: consolidation [message #249918 is a reply to message #246841]

Fri, 06 July 2007 09:18

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
thx for help
i found out that there is the same public synonyms in the database to be imported to the new consolidated one ...
i used fromuser touser during import , but what to do with public sysnonyms with the same name

thx

Report message to a moderator

Re: consolidation [message #249930 is a reply to message #246841]

Fri, 06 July 2007 09:54

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

Sounds like a chat with your application provider might be in order before you start playing with this.

At least I would if it were me.

Report message to a moderator

Previous Topic:	User access to tables
Next Topic:	ARCHIVAL Growth = 9Gb a day..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:48:44 CDT 2024