Options

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.
· Share on Twitter

Comments

  • Options
    richardjmrichardjm Posts: 598
    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
    · Share on Twitter
  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • Options
    richardjmrichardjm Posts: 598
    This feature is now in the main release of the tool available today.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.