RE: Alter table rebuild .... ?

From: Joanne Graham <joanne.graham_at_grenville.co.uk>
Date: Thu, 9 Nov 2000 14:30:27 -0000
Message-Id: <10675.121569@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0027_01C04A59.9AFE3670 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

What about 'alter table ..move ' ?

J.
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Andrey Bronfin
  Sent: Thursday, November 09, 2000 1:02 PM   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
Navixo.com

------=_NextPart_000_0027_01C04A59.9AFE3670 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#dfdcd7>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D622033014-09112000>What=20
about 'alter table ..move ' ?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D622033014-09112000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D622033014-09112000>J.</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Andrey = Bronfin<BR><B>Sent:</B>=20
  Thursday, November 09, 2000 1:02 PM<BR><B>To:</B> Multiple recipients = of list=20
  ORACLE-L<BR><B>Subject:</B> Alter table rebuild .... = ?<BR><BR></DIV></FONT>
  <DIV><FONT face=3DArial size=3D2>Dear gurus !</FONT></DIV>   <DIV><FONT face=3DArial size=3D2>Is there anything similar to "alter = index MY_INDX=20
  rebuild ..... " for tables ?</FONT></DIV>   <DIV><FONT face=3DArial size=3D2>I need to move a table from one TBS = to another=20
  ...</FONT></DIV>

  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2><BR>Andrey=20

Bronfin<BR>Navixo.com<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Thu Nov 09 2000 - 08:30:27 CST