The Library is currently in the process of being upgraded from Oracle Database Version 220.127.116.11 to 18.104.22.168.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Do you remember when mainframes were replaced by client-server? When
client-server was replaced by n-tier architecture? The "Cloud" is a
distraction ... DevOps is not. Prepare for the future.
This package, not installed by default during database creation supports Transparent Data Encryption according to the GoldenGate docs. Certainly the "KM" in the name does point to "Key Management"
Dependencies (Updated to 22.214.171.124)
Owned by SYS with no privileges granted.
client IN VARCHAR2,
master_key_id IN VARCHAR2,
wrapped_key IN VARCHAR2,
flags IN BINARY_INTEGER,
key OUT VARCHAR2);
-- if GoldenGate is installed
and the database utilizes TDE cd to the $GG_HOME directory, run the prvtclkm.plb
script, and grant EXECUTE to the GoldenGate user.
Enter user-name: / as sysdba
Oracle Database 12c Enterprise Edition Release 126.96.36.199.0 - 64bit
With the Partitioning, OLAP, Advanced Analytics and Real Application
SQL> desc DBMS_INTERNAL_CLKM
ORA-04043: object DBMS_INTERNAL_CLKM does not exist
SP2-0808: Package created with compilation warnings
SP2-0810: Package Body created with compilation warnings
SQL> GRANT execute ON dbms_internal_clkm TO ggadmin;