What are the challenges you face when working across database platforms? Take the survey

Drop Tables with PURGE option

cchattcchatt Posts: 2
edited April 21, 2015 6:04AM in Schema Compare for Oracle
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.


  • Options
    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.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
  • Options
    Eddie DEddie D Posts: 1,788 Rose Gold 5

    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    This feature is now in the main release of the tool available today.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.