• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » How to check encrypted tablespace in the Database

How to check encrypted tablespace in the Database

March 4, 2023 by techgoeasy Leave a Comment

Here is the query that can be used

select t.name,e.encryptionalg,e.encyptedts,e.status from v$encrypted_tablespaces e,v$tablespace t where t.ts#=e.ts#(+);

We can further check the datafile encryption status of the above tablespaces using the below query

select name, encrypted from v$datafile_header  where tablespace_name like '&1';

We can find the count of the datafiles which are not encrypted in the particular tablespace using the below query

select count(*) from v$datafile_header  where tablespace_name like '&1' and encryped='NO';

We can find the count of the datafiles which are encrypted in the particular tablespace using the below query

select count(*) from v$datafile_header  where tablespace_name like '&1' and encryped='YES';

Filed Under: Oracle, Oracle Database

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet
  • How to check Package version in EBS R12
  • sed delete line containing string

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us