文档解释
ORA-28372: missing ENCRYPT storage option for encrypted tablespace
Cause: You attempted to specify ENCRYPTION property for CREATE TABLESPACE without specifying ENCRYPT storage option to encrypt the tablepsace.
Action: Add ENCRYPT storage option and retry the statement.
ORA-28372:当创建加密表空间时,缺少ENCRYPT存储选项。
官方解释
常见案例
一般处理方法及步骤
步骤1、执行查询以查看表空间是否已被加密:
SELECT ENCRYPTED FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = ‘TS_NAME’;
步骤2、如果表空间未被加密,请重新创建表空间,并指定’ENCRYPT’参数:
CREATE TABLESPACE TS_NAME DATAFILE ‘/u01/data/TS_NAME.dbf’ SIZE 100M ENCRYPTION USING ‘AES256’ DEFAULT STORAGE ( ENCRYPT );