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

lafon wrote:
>
>Hi,
>
>We have create 2 tablespaces :
>
>
>For the data:
>
> create tablespace data
> default storage ( initial 10K next 10K
> minextents 1 maxextents 121
> pctincrease 10)
>for the index:
>
> create tablespace indexes
> default storage ( initial 10K next 10K
> minextents 1 maxextents 121
> pctincrease 10)
>
>We have try too with initial 1M next 1M.
>
>
>When we insert data in ORACLE, this error message appears :
>
> ORA-1632: max of extents (121) reached.

Defining the initial and next extent size when creating the tablespace only sets up a default for tables and indexes you subsequently create within the tablespace. You can override the default storage parameters for each table you create.

It sounds as if you have tables that require much more space than you are allocating. You should probably find out how much space is required to load your data, calculate expected growth for a reasonable period of time, then create your table with the initial extent large enough to hold all of the data. In a DBA's dream world table data never spills out of the first extent ;^)

Check out chapter 8 of the _Administrators_Guide_ for some help with calculating necessary space allocations. It's not unusual for large tables to require many, many megabytes of storage for the initial extent.

-- 
Mark Fontenot and Ally McEvoy
Pickwick Software Co.
Oracle Specialists
Portland, OR