This discussion is archived
1 Reply Latest reply: Jun 1, 2010 11:13 AM by Ben Speckhard RSS

move_table_clause of the alter table command

299938 Newbie
Currently Being Moderated
Oracle Workspace Manager: 10.2.0.4.3
Database version: 10.2.0.4.0

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.

Legend

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