Fun with Access Control Entries in Oracle 12cR1 – Part 2 : ACE and Data Pump

(Picture by Tiia Monto [CC BY-SA 3.0], via Wikimedia Commons) As explained in my previous blog post, in an attempt to develop a solid script to handle ACE (who says I am a quibbler ?), I also played with Data Pump to export and import ACE/ACL in Oracle 12cR1. I found out that OBJECT_PATH=NETWORK_ACL exists […]

Read More

Checklist to determine if an Oracle schema is self-contained

For a few months, I have been working on massive migrations of Oracle 10g/11g databases on Solaris to 12c on Linux. Most of these databases are highly consolidated with several schemas (no PDBs of course), and these schemas are used by different applications. These applications have supposedly nothing do to with each other. Of course, […]

Read More

Impdp tip : exclude content of a table and include metadata at once

I am currently in the process of migrating a 150 Gb Oracle 10g database to 12c. Due to some limitations I won’t discuss here, I have to do it with Datapump. As I encountered different problems during the import, I had to launch it several times. It took 2 hours to import a 120 Gb […]

Read More