Re: ORACLE Import

From: Chinna <jchinna_at_enron.com>
Date: 1997/09/16
Message-ID: <01bcc2bb$5babf440$06f7fb9b@eoghou1325.eog.enron.com>#1/1

I gave some suggestions. Please let me know if it was useful.

Chinna

Oscar Ssentoogo <impala_at_enterprise.net> wrote in article <5ujmn3$93p$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 Tue Sep 16 1997 - 00:00:00 CDT