In my previous article we learnt how to move an application container across CDBs. As we already know, Multitenant Application Containers eliminate the overhead of replicating application definitions ...
Introduction In my previous article, I discussed the use of proxy PDBs with application containers to load balance an application across CDBs by relocating application PDB‘s). In this article, I will ...
Introduction As we saw in myprevious article, if application containers in multiple CDBs need to have the same application definition (for example, same tables and PL/SQL packages), then the applicati...
Introduction In my previous article, I discussed conversion of a regular PDB to an application PDB so that applications that are already installed in it can also take advantage of application containe...
Overview In my most recent article, I discussed the cross-container DML statement, which is a convenient way for the Application Root administrator to perform DML operations on a table in any applic...
Overview In my last article, Oracle Multi-tenant Application Containers – Part IV, we learned about cross-container aggregation to query user-created data in a metadata-linked table across various app...
Overview In my last article, Oracle Multi-tenant Application Containers Part-III, we learnt about data sharing among containers in an application container by means of metadata-linked objects, data-li...
Introduction For an application container, when a DML statement is issued in the application root without specifying containers in the WHERE clause, the DML statement affects the default container for...
Introduction Oracle documentation states that it is possible to update a metadata linked table in multiple Application PDBs in a single DML statement. Here are some excerpts with relevant parts highli...
Overview In my last article, Oracle Multi-tenant Application Containers Part-II, we learnt how to create an application container comprising application root, application seed PDB, and application PDB...
Overview As I discussed in my last article Oracle Multi-tenant Application Containers Part-I, Oracle Database 12.2.0.1 introduces the concept of multi-tenant application containers that enable many PD...
Introduction Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of mul...
