Re: Table maintenance on a 7/24 database

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 13 Jun 1999 19:51:08 +0100
Message-ID: <929300294.9676.0.nnrp-11.9e984b29@news.demon.co.uk>

You could move to Oracle 8i and make
all your table index-organised tables.

Oracle 8i allows indexes to be rebuilt in real-time without locking other users. Changes are handled by keeping a log as the index is rebuilt, and then folding in the changes at the end.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Just Visiting wrote in message ...
>How do you do table "reorgs" to eliminate multiple extents, chained rows &
>deleted rows from tables on a database with 7/24 uptime requirements?
>
Received on Sun Jun 13 1999 - 13:51:08 CDT