Re: RELOCATE TABLES FROM ONE TABLESPACE TO ANOTHER ONE ?
From: Stephen Harris <sweh_at_mpn.com>
Date: 31 May 1999 20:05:02 GMT
Message-ID: <7iuq1e$abc$1_at_nebula.mpn.com>
Date: 31 May 1999 20:05:02 GMT
Message-ID: <7iuq1e$abc$1_at_nebula.mpn.com>
Thomas Kyte (tkyte_at_us.oracle.com) wrote:
: SQL> alter table emp move tablespace some_other_tablespace;
Neat :-)
: is implemented -- no. You would typically export the table. drop it and
: recreate it in the 'right' tablespace and import it.
Co-incidently I was having a similar discussion with co-DBA here, and
the best we could come with was:
rename x to y
create table x tablespace z as select * from y
drop table y
Of course, you'd have to check your storage constraints were OK on the new table. Space _shouldn't_ be a problem. Expect lots of archive logs :-)
Would this affect/break any indexes? Or would they be rebuilt?
-- rgds StephenReceived on Mon May 31 1999 - 22:05:02 CEST