You can use export/import to move non-sys owned tables to a proper tablespaces.
Eveleen
Please respond to [EMAIL PROTECTED]
"Sanjay Kumar" <[EMAIL PROTECTED]> on 02/05/2001 11:50:52 AM
Message - From: "Sanjay Kumar" <[EMAIL PROTECTED]> on 02/05/2001 05:50 PM
GMT
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: (bcc: Eveleen Xu/NNIB/NNNG)
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
|
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
|
