Re: ORACLE Import

It depends on the version of ORacle you are using. In 7.3 version unlimited can be used.

100M is available space.
50K is initial extent
50K is max extent.

Total space used is 51200 * 50 = 2560000 bytes. But still you have 10240000 - 2560000 = 7680000 byes remaining.

So change max extent to 190K(200K is the limit for 100M space).

this should work fine.

let me know if this helped.

Chinna

Oscar Ssentoogo <impala_at_enterprise.net> wrote in article <5ujmnr$97f$1_at_news.enterprise.net>...
> I am trying to import loads of records to an ORacle table but keep having
> the error (in .log file)
> ' ORA-01631: max # extents (50) reached in table TRAINS_DATA
> LOAD discontinued'
>
> The maxextents parameter is set to 50 for this table. Can I set
 Maxextents
> to unlimited?
>
> Is there a problem with the size of the table itself or INITIAL etc
> settings? What about PCTINCREASE?
>
> Here is the create table statement:
>
> CREATE TABLESPACE boxsheet
> DATAFILE '/oradata/boxt/box_data' size 100M
> DEFAULT STORAGE (
> INITIAL 50K
> NEXT 50K
> MINEXTENTS 2
> MAXEXTENTS 50
> PCTINCREASE 0)
> ONLINE;
>
> Thanks
>
> Oscar
>
>
>
>
  Received on Mon Sep 15 1997 - 00:00:00 CDT