I am attempting to clear up issues found in:
SELECT * FROM PDB_PLUG_IN_VIOLATIONS WHERE Status = 'PENDING';
I have one row:
"Sync PDB failed with ORA-01981 while performing 'REVOKE REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$" FROM "APEX_050000" CONTAINER=ALL'"
If I attempt:
SQL> SELECT SYS_CONTEXT('USERENV','CON_NAME') FROM DUAL;
SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT
SQL> REVOKE REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$" FROM "APEX_050000" CONTAINER=ALL;
REVOKE REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$" FROM "APEX_050000" CONTAINER=ALL
*
ERROR at line 1:
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
SQL> REVOKE REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$" FROM "APEX_050000" CASCADE CONSTRAINTS CONTAINER=ALL;
REVOKE REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$" FROM "APEX_050000" CASCADE CONSTRAINTS CONTAINER=ALL
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database TESTCPAT
ORA-65040: operation not allowed from within a pluggable database
So as you can see, this is not being performed from the new pdb moved here from a non-cdb database.
Any ideas? This is Oracle Enterprise 12.2.0.1