Re: tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 29 Sep 2002 23:03:14 +1000
Message-ID: <sHCl9.42355$g9.122437@newsfeeds.bigpond.com>

Hi Mantat,

What about using a partition table ?

A partitioned table allows you to have one logical table stored in many tablespaces but it doesn't contradict what Sybrand says in that you can not create two tables in the same schema with the same name (partitioned or otherwise).

The question we need to ask of the original poster is *why* does he want to a user to create two tables with the same name. For in that question lies the ultimate answer.

Cheers

Richard
"Mantat" <mtlam_at_macau.ctm.net> wrote in message news:an6ms8$5h19_at_ctmsun0.macau.ctm.net...
> How about using Partition table?
>
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl>
> ???????:soo9pu4gk2au16n1kgjl181qtrdj7rvm48_at_4ax.com...
> > On Fri, 27 Sep 2002 15:43:09 -0700, Quoc Vu <qvu_at_ipac.caltech.edu>
> > wrote:
> >
> > >Can a user work on 2 tablespace?
> > Yes
> >
> > Since I want a user can create a 2 tables with
> > >the same name in different tablespace. Is it possible to do that?
> > No. Think! A table name must be unique. In which tablespace the table
> > resides doesn't matter
> >
> > Here what I
> > >did, but it didn't work.
> > Of course not.
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Sun Sep 29 2002 - 08:03:14 CDT