Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alter table rebuild .... ?

Re: Alter table rebuild .... ?

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Thu, 9 Nov 2000 17:27:53 +0200
Message-Id: <10675.121581@fatcity.com>


That's what i was looking for !
Thanks a lot !

> Hello Andrey,
>
> If you are talking about storage parameters and you are on 8i, try to use
> 'alter table move' command. Your table must be nonpartitioned.
>
>
> Regards
> Ed
>
> -----Original Message-----
> Sent: 9 ?????? 2000 ?. 16:02
> To: Multiple recipients of list ORACLE-L
>
>
> Dear gurus !
> Is there anything similar to "alter index MY_INDX rebuild ..... " for
tables
> ?
> I need to move a table from one TBS to another ...
>
> TIA
>
>
> Andrey Bronfin
> Navixo.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Nov 09 2000 - 09:27:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US