Hi,,
My db version is 11.1.0.7. I have 5-6 partitioned table in my db where i could see in each table the partitioned is created with day range and there are thousands of partition in each of the table. That means the partion is never deleted. Now , I got a requirement to move the table to another TBS which is encrypted TBS. Its quite impossible to move all the partion to another TBS one by one. Now, my concern is:
1. Can i move last two partition to another TBS and modify the default storage to the new TBS, than will the next partition will be created to new TBS???? Or there is any other issue??
2. Please help me to create a script which is automatically create and drop partion in a partion table
Regards,