This discussion is archived
2 Replies Latest reply: Feb 24, 2011 5:41 AM by 741357 RSS

Quickest way to remove wsm'd tables?

741357 Newbie
Currently Being Moderated
I have a large number of wsm'd tables that I want to remove. They have many inter-relationships, and a reasonable amount of data in them (which I no longer need).

What is the quickest way to just remove them? Currently I am using disableversioning, but that takes several hours in test. In production I would like this to proceed quicker if I can.

Edited by: Bryan Hall on Feb 23, 2011 10:12 AM
  • 1. Re: Quickest way to remove wsm'd tables?
    Ben Speckhard Pro
    Currently Being Moderated
    Hi,

    The quickest way would be to drop all of the schemas containing version enabled tables. That is assuming none of the other objects need to be kept.

    It is recommended to execute dbms_wm.RecoverFromDroppedUser after doing so to clean up/fix any metadata. This only needs to be executed once after all of the required schemas are dropped, not after each drop user command.

    If there are tables or other objects that need to be kept, then you would need to use dbms_wm.DisableVersioning.

    Regards,
    Ben
  • 2. Re: Quickest way to remove wsm'd tables?
    741357 Newbie
    Currently Being Moderated
    Thanks Ben, that is what I thought.

    Although there are other items in the schema I want to keep, it looks quicker to export them, drop the schema owner, and then re-create the owner and re-import the other items.

    Bryan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points