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?