One PDB to go, please!

Starting with 12c Release 1, Oracle introduced a completely new architecture concept for its database – the Container Database. With this new architecture, new challenges came up but with the same breath a wide branch of new opportunities.   The presentation will address the capabilities to create fast and easy new (test) databases or clones for a running production database. Five different ways will be discussed. – Using Local and Remote Cloning – Using an Unplugged PDB (predefined master) – Using Refreshable PDBs as a master for new (test) databases – Snapshot Carousel Another point of the agenda is the usage of the Snapshot features of ACFS and Direct NFS to speed up the creation process.

Oracle 21c: New Features and Enhancements of Data Pump / TTS

At the end of the year 2020, Oracle released 21c on its Cloud infrastructure. The on-premises version will follow later this year. As with every new Oracle version, the Data Pump utility gets new features or enhancements for existing features. This presentation gives an overview of the enhancements of Data Pump and Transportable Tablespaces. The following list is an excerpt of the points I will talk about. • Simultaneous use of EXCLUDE and INCLUDE • Parallelized import of metadata during a TTS import operation • Checksum support for dump files • Direct access to Oracle Cloud Object Store for exports and imports • … Some of the features are presented in a live demo.