From oracle 11gR2 onwards ACLs(Access control list) are mandatory to send mail from procedure using UTL_MAIL or UTL_SMTP. For this make sure XDB component is installed. If XDB component is not installed Check – How to install XDB component in oracle.   Verify whether UTL_MAIL and UTL_SMTP is installed […]

Though Oracle hasn’t provided straight forward method to disable TDE . But there is a work around for this. NOTE – Don’t implement this on production database. Oracle Support/Development team will not help in resolving any issues arising due to such operations.  Follow Below steps   Find the encrypted table columns and modify them:   SQL> […]

                           Transparent Data Encryption (TDE) provides mechanism to encrypt the data stored in the OS data files. TDE enables the encryption of data at the storage level to prevent data tempering from outside of the database. New commands has been introduced in oracle 12c […]