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
Printable View
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
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.
if you are using 8i you coudl use
alter table xxx move tablespace yyy
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