move table across tablespace

From: <hosu_at_cs.umbc.edu>
Date: Sat, 30 Dec 2000 05:04:37 GMT
Message-ID: <92jqd2$kha$1@nnrp1.deja.com>

Hi, there,

I am implementation the recommendation from Oracle Expert. Here is the script:

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 Fri Dec 29 2000 - 23:04:37 CST