After moving several tables from one tablespace to another, will the
original
table still exist?

I've issued the Alter Table Move Tablespace command on each table and
can
query the new tables in the new tablespace, however the old tables
remain - do
I need to manually drop them?

Thanks,

Jerry

jjablt (AT) hotmail (DOT) com wrote:
Impossible. Moving a table can not and does not duplicate the table.

Post your version number and the exact DDL you wrote that "moved"
the tables as well as the SELECT statement(s) that have you convinced
the "old" table still exists.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org