Re: Alter Table... Move Tablespace ... command

jjablt_at_hotmail.com wrote:
> 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

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org