Drop Tables with PURGE option

cchatt

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.

richardjm

Seems like a reasonable idea. I'll see what I can do to add it to the tool as an option.

For now you could export your script and search and replace drop table and add the purge option manually.

Eddie D

Hi

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

richardjm

This feature is now in the main release of the tool available today.