Upgrade Ora19 to Multitenant Ora21

This course is devoted to exploring what’s is Oracle Multitenat , which new features has Ora 21 vs Ora 19. You will learn new administration features , development enhancemets and how to migrate single database to multitenat and how management it.

Duration: 4 hours
Lanquage : Slovak

Contents

1. Multitenat Database

Archutecture of multitenat databases
Multitenat user
Multitenat roles
Profiles and lockdown profiles
Technologies to upgrade to multitenat database
Administration multitenat environment

2. SQL and PLSQL enhancements in Ora21

Polymorphic Table Functions (PTF)
Analitic Function LISTAGG DISTINCT
Analytic Function Window Clause
Analytic Function windows_clause GROUPS
Analytic Fnc Bitwise Aggregate Functions
Aggregate Fnc ANY_VALUE
Aggregate Fnc CHECKSUM
SQL Quarantine
SET OPERATORS
SQL Macros
Inline External Tables

3.Database utilities

CHECKSUM
Data Pump Transportable Tbsp
INCLUDE and EXCLUDE in the Same Operation
Index Compression
In-Memory External Table Support