Re: move table across tablespace

hosu_at_cs.umbc.edu wrote:

Assuming you have the proper release of Oracle.

fix the root problem.

alter user scott default tablespace users temporary tablespace temp;

Hopefully you have a temporary tablespace called temp. You probably have the temp tablespace set to SYSTEM also for scott.

Alter table xxxx move tablespace users;

Issue the alter table command for each table where xxxx is the table name.

>
>
>Hi, there,
>
>I am implementation the recommendation from Oracle Expert. Here is the
>script:
>
>------------------------------------------------------------------------
>-- Segment Relocation Recommendations
>-----------------------------------------------------------------------
>
>Relocate table SCOTT.EMP from TABLESPACE "SYSTEM" to "USERS"
>
>Relocate table SCOTT.BONUS from TABLESPACE "SYSTEM" to "USERS"
>
>Relocate table SCOTT.SALGRADE from TABLESPACE "SYSTEM" to "USERS"
>
>...
>What is the corresponding SQL command that I can use to relocate table
>from one tablespace to another?
>
>Thank you and happy new year!
>
>Honglin
>
>
>Sent via Deja.com
>http://www.deja.com/
  Received on Sat Dec 30 2000 - 06:55:00 CST