Database management

12cR2 auditing all users with a role granted

By Franck Pachot . 12.1 introduced Unified Auditing where you define policies and then enable them. As with the traditional audit, you enable them for all users or for specific users. The unified auditing adds a syntax to audit all(…)

New release model for JUL17 (or Oracle 17.3): RU and RUR

By Franck Pachot . Updated June 5th When reading about new version numbering in SQL Developer, I took the risk to change the title and guess the future version number for Oracle Database: Oracle 17.3 for(…)

Oracle 12cR2: exchange partition deferred invalidation

By Franck Pachot . In a previous post I introduced the new 12cR2 feature where some DDL operations can use the same rolling invalidation than what is done with dbms_stats. On tables, DDL deferred invalidation is(…)

Which privilege for CREATE PLUGGABLE DATABASE from DB LINK?

By Franck Pachot . When cloning a PDB from a remote CDB you need to define a database link to be used in the CREATE PLUGGABLE DATABASE … FROM …@… command. The documentation is not completely clear about the(…)

12cR2 needs to connect with password for Cross-PDB DML

By Franck Pachot . In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password(…)

Workaround for bug 19566227/20563128 doing Cross Platform Migration (MOS Note 1389592.1)

In a project I have to move an Oracle 11.2.0.4-DB (around 7TB in size) from Sparc Solaris (called Source in the remainder of this Blog) to Linux x86-64 (called Target in the remainder of the Blog). I.e. a platform migration(…)

random “ORA-01017: invalid username/password” in 12cR2

By Franck Pachot . Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing(…)

12cR2 Cross-container DML – insert into container()

By Franck Pachot . Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset,(…)

Oracle 12cR2 : Optimizer Statistics Advisor

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations(…)

Can you open PDB$SEED read write?

By Franck Pachot . If you are in multitenant, you probably already felt the desire to open the PDB$SEED in READ WRITE mode. Can you open PDB$SEED read write yourseld? Yes and No. Should you open PDB$SEED read write yourself?(…)