SELECT t.name, NVL(e.encryptionalg, 'Not encrypted') algorithm
FROM v$tablespace t LEFT OUTER JOIN v$encrypted_tablespaces e
ON( t.ts# = e.ts# )
WHERE t.name not in ('SYSTEM','SYSAUX','UNDOTBS1','USERS');
To generate "CREATE TABLESPACE" statements for the tablespaces, see this post
No comments:
Post a Comment