Database Security Products (MOSC)

MOSC Banner

Oracle tablespace encryption

edited Dec 15, 2017 4:00AM in Database Security Products (MOSC) 4 commentsAnswered

Hi All,

I am trying to encrypt an existing tablespace and I though you could do it using:

SQL> alter database datafile 'D:\ORACLE\ORADATA\HZNTEST\TEST_TABLESPACE.DBF' encrypt;

alter database datafile 'D:\ORACLE\ORADATA\HZNTEST\TEST_TABLESPACE.DBF' encrypt

                                                                        *

ERROR at line 1:

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

I am using Oracle 12c R1.

I have tried researching this and specifically found the following which seems to suggest ALTER DATABASE DATAFILE data_file ENCRYPT is supported in 12.1.

https://docs.oracle.com/database/122/ASOAG/configuring-transparent-data-encryption.htm#ASOAG620

Thanks

Hakan

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