Re: Novice question: Tablespaces and Users

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 19 Dec 2003 07:36:08 -0800
Message-ID: <1071848075.183088@yasure>

Niall Litchfield wrote:

> "Dave Pylatuk" <davep_at_centurysystems.net> wrote in message
> news:rfoEb.18539$CK3.1618737_at_news20.bellglobal.com...
>

>>Hello all.
>>
>>I am running oracle 8.1.7 on a server with the following tablespace:
>>
>>Client1_DB
>>
>>This tablespace has many tables all owned by a user named 'John' for

>
> example
>

>>John.table1
>>John.table2
>>....
>>
>>I would like to have the following tablespaces on the same physical

>
> server:
>

>>Client1_DB
>>    John.table1
>>    John.table2
>>    ....
>>Client2_DB
>>    John.table1
>>    John.table2
>>    ....
>>Client9_DB
>>    John.table1
>>    John.table2
>>    ....
>>
>>As indicated above, all tables in each tablespace must be owned by the

>
> same
>

>>user.
>>Each tablespace will contain exactly the same set of tables.
>>
>>I not an Oracle expert and am sure this can be done, I just do not know

>
> how.
>
> What you ask cannot be done. A user cannot own multiple objects of the same
> type with the same name. What on earth would the correct result for
>
> select * from john.table1 be?
>
> However it looks like you wish to store the same application multiple times
> in the same instance. In this case you would create 9 users u01,u02...u09
> etc These can use the same or different tablespaces, which are just storage
> areas.

Why can't it be done? All it requires is Enterprise Edition and partitioning. Granted three are only two tables rather than six. But storage wise it is exactly the same thing he has described?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Dec 19 2003 - 09:36:08 CST