How to rotate tablespace (data encryption) keys in Oracle 19c?
How can I rotate data encryption key of previously encrypted tablespace in 19c?
Lets say a tablespace was encrypted with 'ALTER TABLESPACE <tablespace> ENCRYPTION ONLINE USING ‘AES256' ENCRYPT'.
Would running 'ALTER TABLESPACE <tablespace> ENCRYPTION ONLINE USING ‘AES256' REKEY' rotate the data encryption key with another AES256 key?
If it rotates, should master encryption key also be rotated afterwards using 'ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY <keystore_password> WITH BACKUP USING ‘<backup_identifier>’ ' to ensure encryption of rotated tablespace key?