Home » RDBMS Server » Server Administration » New database
New database [message #149816] Mon, 05 December 2005 02:36 Go to next message
juicyapple
Messages: 92
Registered: October 2005
Member
Hello, can anybody let me know what is the advantages to create separate/new database since we can create new schema...

Thanks.

Report message to a moderator

Re: New database [message #149858 is a reply to message #149816] Mon, 05 December 2005 06:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on the functionality and usage.
If the application is small and does not occupy / need any special resouces, just create a new schema.
Creating seperate databases for each and every new application is just waste of resources ( for every database/instance you need SGA/Seperate areas / CPU allocation etc).
On the other hand, i would not create a schema for TESTING purpose, in the same database as PROD is been created. So different environments need to be in different databases ( in above case, preferably in a different server).

Report message to a moderator

Re: New database [message #149911 is a reply to message #149816] Mon, 05 December 2005 12:26 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
In addition to what Mahesh said, other considerations include:

Uptime requirements
Version compatibility requirements with COTS

Report message to a moderator

Previous Topic: new server
Next Topic: high cpu activity on sun
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:21:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.