I was under the impression that Oracle expert will generate the scripts for
you. We do not use this product here this is from memory so check the manual
for the product.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<hosu_at_cs.umbc.edu> wrote in message news:92jqd2$kha$1_at_nnrp1.deja.com...
>
>
> 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 Wed Jan 03 2001 - 08:06:48 CST
