OraFAQ Forum: Designer » Is it good to have many databases in one server?

Home » Developer & Programmer » Designer » Is it good to have many databases in one server?

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

Is it good to have many databases in one server? [message #170305]

Wed, 03 May 2006 04:21

motolongines
Messages: 3
Registered: May 2006
Location: dun

Junior Member

This is my issue, I would like to design databases which is each slightly different for each customer. And the databases reside in my server. So better to put all in one database or make many databases?

thank you
regards,

effendy

Report message to a moderator

Re: Is it good to have many databases in one server? [message #170521 is a reply to message #170305]

Thu, 04 May 2006 04:17

orausern
Messages: 826
Registered: December 2005

Senior Member

are these databases all meant for the same application? or are they for different application?

if they are for different application , it makes sense to have different databases..if they are all for the same application, it may be better to have one database..

Report message to a moderator

Re: Is it good to have many databases in one server? [message #170530 is a reply to message #170521]

Thu, 04 May 2006 04:37

motolongines
Messages: 3
Registered: May 2006
Location: dun

Junior Member

Well, Not really the same application,
but the applications will run on server then the client connect by remote desktop connection.
well, from the infrastructure, i already disagree bout running the program by remote desktop. but what can i do...??

Report message to a moderator

Re: Is it good to have many databases in one server? [message #170574 is a reply to message #170530]

Thu, 04 May 2006 07:10

orausern
Messages: 826
Registered: December 2005

Senior Member

If the applications are different, then they should reside on a different database.

that makes for logical grouping isnt it? -since the applications are different, even from security point of view, why should they share the same database?

Report message to a moderator

Re: Is it good to have many databases in one server? [message #170709 is a reply to message #170574]

Thu, 04 May 2006 20:14

motolongines
Messages: 3
Registered: May 2006
Location: dun

Junior Member

sorry i m new one to develop real application Smile

ok. the condition is like this :

I can make an application support only for one client,

but I afraid in the future if I need to customize my application

and will impact my database structure and result with new different

databases.

And problem is company only provide one server.

Embarassed

Report message to a moderator

Re: Is it good to have many databases in one server? [message #170823 is a reply to message #170709]

Fri, 05 May 2006 05:55

orausern
Messages: 826
Registered: December 2005

Senior Member

Not clear to me what is meant!

Report message to a moderator

Previous Topic:	error in designer10g ora-01917
Next Topic:	Table references on PL/SQL Modules

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 04:07:52 CST 2024