More than 1 tablespace/user ?

From: <terry_stjean_at_my-deja.com>
Date: 2000/06/29
Message-ID: <8jfpbe$d0m$1_at_nnrp1.deja.com>#1/1


[Quoted] [Quoted] We have a software package we bought set up in it's own tablespace. I [Quoted] 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 [Quoted] SQL procedure, do I have to qualify the tables names with the tablespace in order to have a procedure use tables in both tablespaces?

Terry

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

Original text of this message