Thursday, March 14, 2019

How to create a bigfile encrypted tablespace


There is slightly different syntax for  tablespace creation due to  use of Oracle Transparent Encryption.

CREATE BIGFILE TABLESPACE NAME_DATA
DATAFILE '&disk_group' SIZE 1024M
AUTOEXTEND ON NEXT 512M MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
ENCRYPTION DEFAULT STORAGE(ENCRYPT)
/




No comments:

Post a Comment