Re: HELP!!!!!!!!!!

The problem could be that you are ommitting the storage clause on the create table command. The parms you specify when creating the tablespace are used when you ommit the storage clause. The table you are loading is dynamically growing because the 10k initial extent provided by the tablespace's default storage clause is way too small. You need to provide a larger initial extent by supplying a storage clause when initially creating your tables and indexes.

Good Luck,

Richard Headley
Platinum TechnologyKen Friday <ken.friday_at_teldta.com> wrote:
>Minor addition to earlier response:
>
>Note that there are two limits on the maximum number of extents.
>
>1. The logical limit set at either the tablespace (default) or object
>level.
>2. A hard physical limit based on the Oracle block size used when the
>database was created. I use a 4K block and have a maxextents limit of
>249.
>
>Good luck
>K. Friday
>
Received on Thu Aug 03 1995 - 00:00:00 CEST