Access to Oracle Database 19c

To complete the OBEs of this module, you need access to Oracle Database 19c and to one CDB.

In this lesson, you'll learn how to:

• Install Oracle Database 19c with automatic root scripts execution
• Manage partitions in hybrid partitioned tables
• Create and load partitions of an in-memory hybrid partitioned table
• Create and populate in-memory external tables
• Populate in-memory tables into the in-memory column store (IMCS) and wait until they are completely populated before your application can access them
• Handle operations on the metadata and data of Oracle-managed and user-managed tablespaces when the Transparent Data Encryption (TDE) keystore is closed
• Avoid errors due to values generated by the LISTAGG function
• Audit top-level user activities, how to omit the column encryption attribute of tables during Data Pump import
• Use Database Vault Operations Control