--Step 1 - login to the application root, in this case app_cont1
sqlplus / as sysdba
alter session set container=app_cont1;
--Step 2 - start the upgrade process
ALTER PLUGGABLE DATABASE APPLICATION hr_app
BEGIN PATCH 101;
--Step 3 - create a synonym, a new table, insert data, all allowed
create or replace synonym testing2 for hr_user.test_table_2;
create table hr_user.test_table_3 as select * from hr_user.test_table_2;
insert into hr_user.test_table_2
values (3,'Test3');
commit;
--drop the newly created table. It works.
drop table hr_user.test_table3;
--drop an existing table, it doesn't work
drop table hr_user.test_table_2;
ERROR at line 1:
ORA-65270: operation is not allowed in an application patch
--add a new column. It works.
alter table hr_user.test_table_2 add modified_by varchar2(30);
--drop the new column, it doesn't work
SQL> alter table hr_user.test_table_2 drop column modified_by;
ERROR at line 1:
ORA-65270: operation is not allowed in an application patch
--delete data, it works
delete * from hr_user.test_table_2;
commit;
--Step 4 - end the maintenance process
ALTER PLUGGABLE DATABASE APPLICATION hr_app
END PATCH 101;
