Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Alter Table... Move Tablespace ... command

Alter Table... Move Tablespace ... command

From: <jjablt_at_hotmail.com>
Date: Mon, 10 Dec 2007 16:00:15 -0800 (PST)
Message-ID: <a96c2f0a-fe9e-4811-ba31-a11ef0411897@d4g2000prg.googlegroups.com>


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 Received on Mon Dec 10 2007 - 18:00:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US