| 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: User objects in System tablespace
If you add a user to Oracle and don't specify the default tablespace as 'users' it defaults to the system tablespace.
Ana Choto
American University
"Mark Leith"
<mark_at_cool-to To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
ols.co.uk> cc:
Sent by: Subject: RE: User objects in System
tablespace
root_at_fatcity.
com
02/05/01
01:45 PM
Please
respond to
ORACLE-L
Roerg the tables, and specify the user tablespace..
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sanjay
Kumar
Sent: Monday, February 05, 2001 05:51
To: Multiple recipients of list ORACLE-L
Subject: User objects in System tablespace
Hi,
I have a situation where in all the user related objects (tables) have
been created in System tablespace.
I believe there is no convention followed while creating these tables.
Now, how do I separate these user related objects and put them in
Users tablespace?
Vinay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: achoto_at_american.edu
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 Tue Feb 06 2001 - 10:45:41 CST
 |
 |