Re: More than 1 tablespace/user ?

[Quoted] 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?

[Quoted] The default tablespace is the place segments are created if another tablespace [Quoted] 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.

[Quoted] Tablespace names are completely irrelevant when retrieving data from tables. [Quoted] 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