Re: Reorganizing tables (next extents)

From: FlameDance <flamedance_at_gmx.de>
Date: Fri, 30 Apr 2004 14:57:58 +0200
Message-ID: <c6tigu$ofs$02$1@news.t-online.com>

Dhana wrote:

>> next_extents := (user_tables.blocks * db_block_size - initial)
>> / no_of_parts;
>
>
> How will you arrive the figure for initial ?

By rule of thumb I guessed 1MB. Big enough to cover many tables completely, small enough to never give trouble when importing the huge tables into the backup database.

Thinking about it, maybe I should set initial to the same size as next_extents?

> What do you mean by no_of_parts ? No.of Partitions ?

Number of Fragments. It's what I'd call partitions but I believe that term is defined for something else in the oracle context ... not sure.

Stephan Received on Fri Apr 30 2004 - 07:57:58 CDT