Avoid Licensing Traps
It’s easy to run into licensing issues with the Oracle database. A “wrong” SQL command – and you’ve used an additional option of the database and you can get in trouble at the next licensing audit. This blog post lists some basic steps that can help to avoid such problems.
Read-Only Users in Oracle Enterprise Manager
Oracle Enterprise Manager is really powerful tool for database administration (and much more), which can be used by endusers which are not 100% familiar with the the Oracle architecture and the data ditionary. But if these users have too many privileges, they can cause damage to the database. How to restrict the access to Enterprise…
Pluggable Databases and “DATA_PUMP_DIR” – ORA-39087
Some days ago I ran into the issue that using the directory “DATA_PUMP_DIR”, which is created in every Oracle 12c database, cannot be using when exporting data of a PDB. This is documented in the “Utilities Guide” (Chapter „Overview of DataPump“) “The default Data Pump directory object, DATA_PUMP_DIR, does not work with PDBs. You must…