OS : solaris 5.10
database version : 11.2.0.4
Is there any dependencies/issues while doing tablespace rename operation. steps are below.
Reqirement: Defragment the fragmented tablespace + object defragmentation (Downtime is not an issue at object level hence not going for online table redifination)
steps I followed:
1) create new tablespace names "NEW"
2) move all the index ,lobs,tables , table partition from OLD tablespace to NEW.
3) check if any segments are left in OLD , if not then resize the OLD tablespace datafiles to minimum size
4) move back the objects from NEW to OLD
5) drop the NEW tablespace
in above I see the step 4 is extra and time consuming since 10g onwards tablespace renaming is allowed, do you see any issue with below approach
1) create new tablespace names "NEW"
2) move all objects ( index ,lobs,tables , table partition )from OLD tablespace to NEW.
3) drop OLD tablespace
4) rename the NEW tablespace to OLD name.
please let me know if anyone faced issue post rename of tablespace.
I will have to do the tablespace reorg for multiple tablespaces so I need to be sure on the approach I am following.
Thank you