Got it, thanks for the response.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3fe2cec8$0$13355$ed9e5944_at_reading.news.pipex.net...
> "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.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Fri Dec 19 2003 - 07:21:09 CST
