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