Database Security Products (MOSC)

MOSC Banner

Need to encrypt column which has partitions using TDE

edited Jun 12, 2018 5:00AM in Database Security Products (MOSC) 1 commentAnswered

Hello Experts,

We are using oracle database version 11.2.0.4 in our solution and facing an issue while using column wise encryption using TDE. We are referring below link for TDE-

https://docs.oracle.com/cd/E11882_01/network.112/e40393/asotrans.htm#CHDHAHAB

We are trying to alter an existing column which has partition based on range with below query -

SQL> alter table FILESTORAGE modify("BFILEDATA" encrypt using 'AES256' 'NOMAC' NO SALT);

But not able to alter the same. The query keeps on loading and gets hanged after some time. We tried the same alter query on other test env, which doesnt have column partition and alter works there as expected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center