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: Shevtsov, Eduard <EShevtsov_at_flagship.ru>
Date: Thu, 9 Nov 2000 17:09:58 +0300
Message-Id: <10675.121565@fatcity.com>


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-----
From: Andrey Bronfin [mailto:bronfin_at_VisualTop.com] Sent: 9 ?????? 2000 ?. 16:02
To: Multiple recipients of list ORACLE-L Subject: Alter table rebuild .... ?

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 Received on Thu Nov 09 2000 - 08:09:58 CST

Original text of this message

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