This content has been marked as final. Show 3 replies
V$ENCRYPTED_TABLESPACES displays information about the tablespaces that are encrypted.
check OS side if there's any data files ?
The tablespace was dropped; it does not appear in dba_tablespaces and there are no datafiles listed in dba_data_files nor are they visible in ASM storage.
Does anybody have any guess at to why the residual information is still in v$encrypted_tablespaces? This behaviour didn't happen in two other test databases.
Is this and indicator of something bad lurking, waiting to break things in the future? I'm leery of creating another encrypted tablespace or doing anything that involves the key since this is production.