Re: User objects in System tablespace

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_at_fatcity.com href="mailto:ORACLE-L_at_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_at_fatcity.com">root_at_fatcity.com     [mailto:root_at_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 Received on Mon Feb 05 2001 - 16:51:28 CST