Cannot Start Oracle-XE 18c in order to clear out data
====================================================================================================================
We are having an issue where an Oracle XE instance fills up and for a potentially unrelated reason crashes and cannot be restarted.
What this means is I cannot get back into the instance to cleanout data to resume operation. No matter what path is taken, I continue to be prevented from opening the PDB.
This basically then means I have to rebuild the thing from scratch which is loads of fun.
SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY;
ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY
*
ERROR at line 1:
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN RESTRICTED;
ALTER PLUGGABLE DATABASE XEPDB1 OPEN RESTRICTED
*
ERROR at line 1:
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
SQL> ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY FORCE;
ALTER PLUGGABLE DATABASE XEPDB1 OPEN READ ONLY FORCE
*
ERROR at line 1:
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
Any suggestions on how I might get the data out or get the process started so I can move forward?