Hello
I am using Oracle 18c XE on Linux. For some reasons my datafiles have grown beyond 12GB limit by Oracle XE. I don't know why as Oracle throws an error if an attempt is made to resize a datafile beyond 12GB total limit. May be it is due to autoextend.
I rebooted the server today and the PDB is not opening.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 XEPDB1 MOUNTED
SQL> alter pluggable database xepdb1 open;
alter pluggable database xepdb1 open
*
ERROR at line 1:
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
I want to reduce a datafile size or drop some schema/tablespace but I cannot as the the PDB is in mount state
Can someone please help?
I am stuck.
Habib