changing tablespace

[manjunathk]

Hi friends,
Some of the tables have been mistakenly created in the
System tablespace. How can i change it to the proper user tablespace without altering any of the other parameters?
thanks
manjunath

[pwoneill]

Offhand I'm not sure if this is the "correct" way, but you could create new tables in the correct tablespace as select * from the old tables, and then just drop the old tables. Then add whatever synonymns, permissions etc the appilcations need.

[pando]

if you are using 8i you coudl use

alter table xxx move tablespace yyy

[manjunathk]

thanks, i was moving in the same lines you suggested (using OEM) but when i use 'Create like..', a few check constraints originally not in the table are also being created. Therefore< i thought may be there is another easy and correct way.
manjunath

Sorry, I am using 8.0.5