I am using an Oracle 18c database in a build system.
One of my builds is for a JPA/Hibernate project, which is configured as "create-drop". This means it will create all tables during startup and drop all of them again at the end.
The problem is: I can't configure Hibernate to create "drop ... purge" statements.
It seems that as a result the recycle bin has grown with each build, exceeding now the maximum allowed database size of 12 GB - and I am not even able to open the database anymore:
alter database open
*
ERROR at line 1:
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
I have now droped the PDB and created a new one - but this will last for at most a month, before I run into the same problem again.
My question: Is there any option to tell Oracle to _immediately_ purge dropped tables?
Asked by Tobias Liefke
(103 rep)
Nov 19, 2019, 04:21 PM
Last activity: Nov 19, 2019, 06:02 PM
Last activity: Nov 19, 2019, 06:02 PM