This challenge has come up a few times recently for me. Just HOW can a SQL Developer user quickly build out a SQL script for a database user that will include ALL of their privileges, roles, and system grants? I didn’t have a good answer until today. A group of DBAs at a large shipping […]
Heres a quick look at some of the new features introduced in 126.96.36.199 around Pluggable and Container databases. PDB CONTAINERS Clause Using the CONTAINERS clause, from the root container we can issue a query which selects or aggregates data across multiple pluggable databases. For example each pluggable data can contain data for a specific geographic […]
Let us look at a common requirement the DBA faces on a regular basis related to performing a database clone.
A developer needs a copy or clone of the production database to test some urgent fixes and requires this database for a short period of time to…
Some times we need to have an exact replica of the production database data to urgently test an issue encountered in production. If the production database is very large having a clone process running on the production server or taking a fresh full dat…
Working on a table? Maybe you need to investigate the stats while you also browse some data. But this is a BIG table. You know how to do the ‘split document trick,’ but that’s not quite cutting it. You need more screen real estate. Wouldn’t it be nice if you could drag that table viewer […]
Let us have a look at the Provisioning and Patching feature in OEM 12c.
We have a ‘gold image’ of a 188.8.131.52 Oracle Database Software where the Jan 2013 PSU has been installed.
We now want to deploy this particular 184.108.40.206 version of the d…
If there is one thing a DBA hates it is to waste time. Particularly on boring and tedious tasks. One such task is installing Oracle on a new system (or duplicating a home on an existing system) which generally involves X server setup (Xming for Windows, XQuartz on Mac, pure as the driven snow on […]