Hi,
I have 11gR2 database. I was wondering how can i move all objects from one tablespace(unencrypted) to encrypted tablespace within a database using TTS. It is no straight forward switching data from one database to another using TTS, here metadata of current tablespace make no sense i guess, as encrpted tbs is alreay in place and datafiles don't have to move, they too are in place.
Note: I created procedure using (alter table move and index rebuild +LOBS etc), But I wanted to know how to make it happen through TTS.
Can someone please share the steps?
Regards,
Shahzad