Downgrading PDBs That Contain Oracle APEX

Use this procedure to avoid INVALID OBJECTS OWNED BY APEX_050000 errors when you downgrade PDBs that contain Oracle APEX (formerly Application Express).

After you downgrade the PDB to an earlier release, enter a SQL statement similar to the following to drop the Oracle APEX user:, where the log file base is drop_apex5:

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -b drop_apex5
-c 'PDB1' -- --x'drop user apex_050000 cascade'

In this example, the PDB name is 'PDB1'.

Parent topic: Downgrading Oracle Database to an Earlier Release