In oracle they call changing TABLESPACE for a Table(s) is Move, thus, you can move table between tablespaces by using this query
ALTER TABLE TABLE_NAME MOVE TABLESPACE TABLE_SPACE_NAME
|
||||||
Alter tablespace for table(s)1 comment to Alter tablespace for table(s) |
||||||
|
Copyright © 2010 El-Shihabi - All Rights Reserved |
||||||
1- create tablespace tbs_name Datafile ‘tbs_name’ SIZE 5120M AUTOEXT ON NEXT 100M;