Drop Tables with PURGE option
cchatt
Posts: 2
Is there anyway to configure the product to always include the PURGE option when dropping tables? We are in a resource constrained environment where its necessary to reclaim the space immediately when objects are removed the from the database.
Comments
For now you could export your script and search and replace drop table and add the purge option manually.
Project Manager
Red Gate Software Ltd
I have some good news, a patch has been made available that includes a new option to add the PURGE keyword in your DROP TABLE syntax. Please use this LINK to download V3.1.10.14 of Schema Compare for Oracle.
Upgrade your existing version. Edit your Schema Compare for Oracle project and enable the PURGE option.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Project Manager
Red Gate Software Ltd