How can I change datafile of my tables, initially I was using SYSTEM Datafile now I have created my new separete datafile, how can I transfer all data (50 tables) into new datafile(tablespace)
Printable View
How can I change datafile of my tables, initially I was using SYSTEM Datafile now I have created my new separete datafile, how can I transfer all data (50 tables) into new datafile(tablespace)
alter table move tablespace
Thanks Krishna
Just remember to rebuild your indexes on the table being moved. They will be put into the 'unusable' state one the table is moved.
I've heard that.Quote:
Originally posted by psychofun
Just remember to rebuild your indexes on the table being moved. They will be put into the 'unusable' state one the table is moved.
I would add an analyze after those two as well.
Heck I'll throw in a backup for free.
Also remove the quota that users have on the system tablespace.