How can we help you today? How can we help you today?

Drop Tables with PURGE option

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.
cchatt
0

Comments

3 comments

Sort by
  • 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.
    richardjm
    0
  • 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
    Eddie D
    0
  • richardjm
    This feature is now in the main release of the tool available today.
    richardjm
    0

Add comment

Please sign in to leave a comment.