Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| oracle_multitenant_application_container [2021/11/14 18:54] – [Create & Set the container MAP] andonovj | oracle_multitenant_application_container [2021/11/14 20:45] (current) – [Create & Set the container MAP] andonovj | ||
|---|---|---|---|
| Line 579: | Line 579: | ||
| < | < | ||
| - | SQL> alter session set container=appcdb; | + | SQL> alter session set container=north; |
| Session altered. | Session altered. | ||
| SQL> insert into c## | SQL> insert into c## | ||
| SQL> insert into c## | SQL> insert into c## | ||
| + | SQL> commit; | ||
| + | SQL> alter session set container=central; | ||
| + | Session altered. | ||
| + | SQL> commit; | ||
| SQL> insert into c## | SQL> insert into c## | ||
| SQL> insert into c## | SQL> insert into c## | ||
| + | SQL> alter session set container=south; | ||
| + | Session altered. | ||
| + | SQL> commit; | ||
| SQL> insert into c## | SQL> insert into c## | ||
| SQL> insert into c## | SQL> insert into c## | ||
| SQL> commit; | SQL> commit; | ||
| - | SQL> ALTER PLUGGABLE DATABASE APPLICATION Application_JULIEN ALL SYNC; | ||
| </ | </ | ||
| + | After that you can end the upgrade or installation and sync every application PDB | ||
| Now, when you select from that table, the query will be redirect to all PDBs and thus the data will be sharded across the PDBs. If the PDBs are proxy PDBs, it can be even distributed in different continents. | Now, when you select from that table, the query will be redirect to all PDBs and thus the data will be sharded across the PDBs. If the PDBs are proxy PDBs, it can be even distributed in different continents. | ||