ORA-28336: cannot encrypt SYS owned objects while create table

<<Back to DB Administration Main Page

ORA-28336: cannot encrypt SYS owned objects during create Table

Solution: The operation must not be performed as sysdba. Always use user with dba privileges to perform the task

Proof
CDB01> show user;
USER is "SYS"
CDB01> show con_name
CON_NAME
------------------------------
PDB01
CDB01> CREATE TABLE employee (
     first_name VARCHAR2(128),
     last_name VARCHAR2(128),
     empID NUMBER,
     salary NUMBER(6) ENCRYPT
);  2    3    4    5    6
     salary NUMBER(6) ENCRYPT
     *
ERROR at line 5:
ORA-28336: cannot encrypt SYS owned objects

SQL> show con_name

CON_NAME
------------------------------
PDB01
SQL> show user
USER is "PDBDBA"
SQL> CREATE TABLE tde_test1 (
  id    NUMBER(10),
  data  VARCHAR2(50) ENCRYPT
)   ;

Table created.