Skip to Content
0
Feb 11, 2015 at 07:38 AM

Changing Table Space of Existing Table from SE11

743 Views

Hi,

I have a table with some data sitting across the Landscape including Production. Now, for some reason, if I want to change Table Space that was initially assigned to the Table from SE11, should I do it right away? Or Do I need to delete the Table and re-create it with New Table Space?

In fact, I have same question for the one that I created/activated in Development System but not yet applied to any other Systems? Do I need to simply change Table Space and Re-Activate it or should it be Delete and Create table with new Table Space?

I am worried about Table Re-Creation since this is going to purge the entire data, however this looks like the recommended way. Please share your thoughts?

Regards,

Naveen Inuganti