Oracle

Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository

Antoine / 2018-12-12

Today, I’m going to share with you a simple SQL query that will allow you to quickly extract useful information […]

Database Link: ORA-12154: TNS:could not resolve the connect identifier specified

Antoine / 2018-12-05

If you are familiar with database links on Oracle database, you may have already encountered the error “ORA-12154: TNS:could not

Replicate a table without primary key or unique key with GoldenGate

Antoine / 2018-11-30

Yesterday, I was working on a simple Golden Gate replication between two Oracle databases. Everything worked as expected, the source

Tablespace usage on Oracle Database

Antoine / 2018-11-21

Yes, I know: many scripts are available to get tablespaces usage from your Oracle database. The one I’m going to

Get rid of clear passwords from your shell scripts with Oracle Secure External Password Store

Antoine / 2018-11-19

As a DBA (or developer), you often need to make connection to your Oracle database from shell scripts. That’s not

Hide table content to users with “SELECT ANY TABLE” privilege

Antoine / 2018-11-12

Today, we will see how to hide sensitive data in your Oracle database from other users with the “SELECT ANY