Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Change the table space name
yup .. and don't forget to rebuild the indexes of that table after that.
Anurag
"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3EA58390.72FBA636_at_remove_spam.peasland.com...
> ALTER TABLE my_table MOVE TABLESPACE eco;
>
>
> That should do the trick!
> HTH,
> Brian
>
Received on Tue Apr 22 2003 - 23:59:34 CDT