Previously Oracle introduced transparent data encryption (TDE) to seamlessly encrypt data inside database. The mechanism allows you to encrypt individual columns inside database which is good enough for most situations.Lets look at how wecan implement this.
Oracle is slowly moving from merely providing software to its customers to full fledged IT engineered systems. Exadata and database appliance are two major offerings. Both these systems are engineered which means that Oracle provides machines preconfigured for you to run. You don’t have to do any type of installation or do any network configuration etc. This […]
With every new release of the database, Oracle introduces hundreds of new features. These features help the DBA in maintaining the database. But sometimes there are a few improvements which are too small to be called a full fledged feature, yet they are so handy that every DBA must know them. In this article we will look […]
As you know Datapump is the Oracle preferred tool for moving data and is soon will be the only option because traditional exp/imp utilities will be deprecated. In following sections we will look at how you can use schema, table and data remapping to get more out of this powerful utility. Data remapping allows you to manipulate […]
One of the main advantages of using PL/SQL with Oracle is its tight integration with the database. PL/SQL is compiled directly inside the database. Although the compiler for PL/SQL is part of Oracle database engine but it uses the C language to do the mediation. All PL/SQL code is first translated into the C language […]