Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: User objects in System tablespace

RE: User objects in System tablespace

From: <achoto_at_american.edu>
Date: Tue, 06 Feb 2001 08:45:41 -0800
Message-ID: <F001.002ABF0B.20010206062630@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US