Sample Header Ad - 728x90

Automatically purge dropped tables in Oracle

0 votes
1 answer
651 views
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