From ora_user@hotmail.com Mon, 05 Feb 2001 14:51:28 -0800
From: "Sanjay Kumar" <ora_user@hotmail.com>
Date: Mon, 05 Feb 2001 14:51:28 -0800
Subject: Re: User objects in System tablespace
Message-ID: <F001.002AB565.20010205142124@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Thanks to those who responded.
 
I also have another question.
 
How do I distinguish between the 
non-system tables and system tables.?
 
This user has created all the application related 
tables as User SYS. I would like filter them and give a new 
tablespace.
 
Thanks
Sanjay  
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Mark 
  Leith 
  To: <A title=ORACLE-L@fatcity.com 
  href="mailto:ORACLE-L@fatcity.com">Multiple recipients of list ORACLE-L 
  
  Sent: Monday, February 05, 2001 10:45 
  AM
  Subject: RE: User objects in System 
  tablespace
  
  <SPAN 
  class=820204318-05022001>Roerg the tables, and specify the user 
  tablespace..
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: <A 
    href="mailto:root@fatcity.com">root@fatcity.com 
    [mailto:root@fatcity.com]On Behalf Of Sanjay KumarSent: 
    Monday, February 05, 2001 05:51To: Multiple recipients of list 
    ORACLE-LSubject: 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?
     
    <FONT face=Arial 
size=2>Vinay