Re: User objects in System tablespace

[Sanjay Kumar]

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   ----- Original Message ----- From: Mark Leith To: Multiple recipients of list ORACLE-L Sent: Monday, February 05, 2001 10:45 AM Subject: RE: User objects in System tablespace 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