Database Security Products (MOSC)

MOSC Banner

Remove TDE from table columns and uninstall TDE option from DB

edited Aug 3, 2016 11:26AM in Database Security Products (MOSC) 4 commentsAnswered
Oracle DB:         10.2.0.4
OS:                Red Hat Linux 5.6
Table:            86 Partition - Daily on date
Table size:       450 gb (indexes 120 GB - Not on TDE column
TDE column 1:     DATA1                    VARCHAR2(20 BYTE) ENCRYPT USING 'AES192' NO SALT,
TDE column 2:    

PATIENT_NAME    VARCHAR2(25 BYTE) ENCRYPT USING 'AES192' NO SALT,

1. What is the best way to remove TDE from these two columns in this table?

2. Can we use table while we remove the TDE from the table?

3. how to uninstall TDE option from the database?

Thanks.

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