Re: 8.1.6 support multiple default tablespaces

As long as the privlege to access this object is granted to this user
(dw_user), it does not matter what tablespace it is in.

You probably got the concept of default tablespace wrong. It means that if you don't specify the tablespace clause, the object (table/index) which you created will go to that tablespace.

For pure "access" of that object, Oracle does not care which tablespace it is in as long as you go the privilege.

Winnie

Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 11/03/2000 03:40:20 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: 8.1.6 support multiple default tablespaces

Hi All,

Does anyone out there know whether or not if 8.1.6 supports the ability to allow
a schema to point to more than one tablespace.

Let me give you an example.

dw_user wants to access Data Warehouse data on tablespace dw_tablespace dw_user also wants to access OLTP data on tablespace oltp_tablespace

user account: dw_user

can dw_user point to both of these tablespaces?

Thanks

larry

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Taylor
  INET: ltaylor_at_iq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).