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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database reorg in Oracle 8?

Re: Database reorg in Oracle 8?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 08 Jun 2003 07:28:09 -0700
Message-ID: <XJHEa.65565$MJ5.47561@fed1read03>


Heiko wrote:
> Hi @All!
>
> Is there a tool to reorg a Oracle 8 database? Size is 10 GB with > 100
> tables.
>
> Thanks!
> Heiko

SQL ALTER TABLE <TABLE_NAME> MOVE...
ALTER INDEX <INDEX_NAME> REBDUILD... Received on Sun Jun 08 2003 - 09:28:09 CDT

Original text of this message

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