ORA-28336

• 코드
• ORA-28336
• 원인
• Oracle TDE(Transparent Data Encryption) 기능에서 SYS 계정으로 Encrypted Table을 생성하면 발생하는 Error
• 해결
• Encrypted table 은 SYS가 아닌 Normal User 로 생성한다

• =======================
  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.
  =======================
• 참고 MOS 문서번호 & 기타
• 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