Home » RDBMS Server » Server Administration » consolidation
consolidation [message #246841] Fri, 22 June 2007 03:30 Go to next message
maoro
Messages: 310
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
Re: consolidation [message #246844 is a reply to message #246841] Fri, 22 June 2007 03:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: consolidation [message #246845 is a reply to message #246844] Fri, 22 June 2007 04:00 Go to previous messageGo to next message
maoro
Messages: 310
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
Re: consolidation [message #246864 is a reply to message #246845] Fri, 22 June 2007 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: consolidation [message #246885 is a reply to message #246841] Fri, 22 June 2007 06:41 Go to previous messageGo to next message
maoro
Messages: 310
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
Re: consolidation [message #246892 is a reply to message #246885] Fri, 22 June 2007 06:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what I first said: import with options fromuser/touser.

Regards
Michel
Re: consolidation [message #249918 is a reply to message #246841] Fri, 06 July 2007 09:18 Go to previous messageGo to next message
maoro
Messages: 310
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
Re: consolidation [message #249930 is a reply to message #246841] Fri, 06 July 2007 09:54 Go to previous message
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.
Previous Topic: User access to tables
Next Topic: ARCHIVAL Growth = 9Gb a day..
Goto Forum:
  


Current Time: Thu Dec 08 10:23:04 CST 2016

Total time taken to generate the page: 0.25864 seconds