Re: Design Q:Multiple Tablespaces vs Multiple Schemas in One TBLSPC?

Comments embedded
Hth,

Sybrand Bakker, Senior Oracle DBA

"Rob Williamson" <robw_at_physics.umd.edu> wrote in message news:3BB4D2E8.C3DC16BE_at_physics.umd.edu...
> I have 3 access databases that I will import into Oracle so I am in the
> design phase.
> It seemed to me that creating separate tablespaces for each of the three
> MSAccess
> DB's might be a good idea since they are fairly functionally
> independent.
>
> So I imagined T1,T2,T3 each with a separate DBA user to create the
> tables in the tablespaces.

No DBA user is necessary. You only need create session and create table privilege. Creating three 'DBA' users basically means your database is unprotected and unsecured from unauthorized access.

>
> Then I started thinking about future integration of the three groups of
> tables and I
> wondered how complicated it would be for users who are primarily using
> tables in T1
> by user U1 to use a table in T2? Is it as simple as U2.table_from_T2
> or creating some synonyms?

YES
> I have not been able to find any good Oracle documentation on this
> subject.

You did find the Oracle Concepts Manual though?
>
> Or am I wrong and should just create one tablespace and several schemas.

Yes, as long as you don't have tens of different schemas
>
> It just seemed nice and safe to have the separate files.
>
> Any advice or a good book on the subject would be apprediated.
> Rob

The Oracle documentation will do, or Oracle the Complete Reference and the Oracle DBA handbook both by Kevin Loney and published by Osborne/ Oracle Press. They weigh a ton, but they are worth it. Received on Fri Sep 28 2001 - 15:33:52 CDT