Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple DB's or Schemas?

dgavendaNov 19 2008 — edited Nov 25 2008

I am porting an existing app from MySQL to Oracle. The current db layout has a db for every company. Within each db, there are about 5 tables. From a prior post, Justin advised to use schemas instead of creating new db's for every company. Thus, have one db with 5 tables.

Being very new to oracle and only partially thru an O'Reily Oracle book, can shed some light on schemas for this purpose? I'll need to have one schema for each company. Each schema will allow its company access to its data and no other company. Is this correct?

Also, are there examples of using schemas for this purpose?

Thx,
Dan

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2008

Added on Nov 19 2008

#database, #general-database-discussions, #schema

13 comments

2,361 views