RE: User objects in System tablespace

[achoto]

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@cool-to        To:     Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>       
                    ols.co.uk>           cc:                                           
                            
                    Sent by:             Subject:     RE: User objects in System 
tablespace                        
                    root@fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    02/05/01                                                           
                            
                    01:45 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L                                                           
                            
                                                                                       
                            
                                                                                       
                            




Roerg the tables, and specify the user tablespace..
     -----Original Message-----
     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).