| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8.1.6 support multiple default tablespaces
Provided you have the proper access via a grant to the
table it does not matter what tablespace is in. If they
want to create tables in multiple tablespaces all they need
is a quota on that tablespace. Then they would just
need to specify the tablespace name when creating the table.
So I guess the answer is yes if I interpreted the question correctly.
-----Original Message-----
From: Larry Taylor [mailto:ltaylor_at_iq.com]
Sent: Friday, November 03, 2000 3:40 PM
To: Multiple recipients of list ORACLE-L
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). Received on Fri Nov 03 2000 - 18:24:57 CST
 |
 |