Re: More than 1 tablespace/user ?

From: <terry_stjean_at_my-deja.com>
Date: 2000/06/30
Message-ID: <8ji86v$79r$1_at_nnrp1.deja.com>#1/1


Yes, your right. I meant schema's.

Terry

In article <996.215T636T12544659ewan_at_chimera.u-net.com>,   "Ewan Parker" <ewan_at_chimera.u-net.com> wrote:
> On 29-Jun-00 15:18:27, terry_stjean said about More than 1
 tablespace/user ?:
> > We have a software package we bought set up in it's own tablespace.
 I
> > want to create a few add-on tables but keep them in a separate
> > tablespace. The question is, when you set up a user, they have a
> > default tablespace (which is the package's tablespace). Will they be
> > able to see/access the tables I create in the new tablespace. From
 an
> > SQL procedure, do I have to qualify the tables names with the
> > tablespace in order to have a procedure use tables in both
 tablespaces?
>
> The default tablespace is the place segments are created if another
 tablespace
> in the user's quota is not specified in the DDL. The packages are not
> segments, and are stored in the data dictionary, as user SYS, in the
 SYSTEM
> tablespace.
>
> Tablespace names are completely irrelevant when retrieving data from
 tables.
> Possibly you are talikng about schemas?
>
> Ewan.
>
> --
> PGP footprint: 3A 82 19 D7 7A 61 D3 DC 4D F3 87 B2 27 99 BE 77
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CEST

Original text of this message