1 Reply Latest reply: Jun 1, 2010 1:13 PM by Ben Speckhard-Oracle RSS

    move_table_clause of the alter table command

      Oracle Workspace Manager:
      Database version:

      Can one use the following technique to relocate a version enabled table from one tablespace to another? Is this supported?

      exec dbms_wm.beginDDL(tablename)
      alter table tablename_lts move tablespace ...
      exec dbms_wm.commitDDL

      I tried this in a development environment; the lt table moved, but the lck table remained behind. This history seems to be all there.