Move tables from one tablespace to another | Maria's Oracle Blog

Today I had to change default tablespace for user X from USERS to XDATA together with all of its tables. 1. Change the default tablespace for the user which will ... Nice script but one mistake select ‘ALTER TABLE.X ‘ || rtrim(ltrim(segment_name)) || ‘ MO

oraclespot.wordpress.com