One thing to keep in mind: Application Containers should always be setup as OMF. When you create the application container, it will not error out or fail if you don’t use OMF. However, if you create a tablespace inside the application root container, you will never be able to sync the application PDB with the application root, as you will get the following error: ORA-01537.
alter
pluggable
database
application hr_app2 sync
*
ERROR at
line 1:
ORA-01537: cannot add
file 'C:\ORACLE\ORADATA\TESTDB\APP_CONT2\hr_app_data.dbf'
- file already part of
database
So far we covered the application containers and the operations we can perform. In the next post, I want to walk you through an exercise/demo from start to end, where we create the application container, run some maintenance, and sync the application PDBs. Stay tuned for more!