Re: ORACLE Import

Hi,

I'm new to Oracle 7, but it seesm to me, that here are mixed two things.

One thing is the STORAGE clause for the table itselfs, and the other thing is the STORAGE clause for the tablespace containing the table.

As far as I know, if the STORAGE clause for the table is too small, then even if the tablespace has enough space to store x times the amount of data of this table, you will run into ORA-01631.

For example, table TBL will be created in tablespace TBLSPC.

TBLSPC was created with a STORAGE clause

 	DEFAULT STORAGE (
 		INITIAL 50K
 		NEXT 50K
 		MINEXTENTS 2
 		MAXEXTENTS 50
 		PCTINCREASE 0)

TBL was created with its own STORAGE clause

 	DEFAULT STORAGE (
 		INITIAL 10K
 		NEXT 10K
 		MINEXTENTS 2
 		MAXEXTENTS 50
 		PCTINCREASE 0)

The restriction here is the STORAGE clause of the table, not of the tablespace (50 * 10k = 500k for TBL, but 50 * 50k = 2500k for TBLSPC). Oracle in ORA-01631 is complaining about #extents in table xxx. There are other error messages, which are related to tablespace restrictions, e.g., ORA-01652, ORA-01653, ORA-01654.

So, maybe, beside the STORAGE clause of the tablespace BOXSHEET, Oscar has to check the STORAGE clause of the table TRAINS_DATA too.

Please correct me, if I missed something. As I said already, I'm new to Oracle 7.

Regards,

Silvio

On Tue, 16 Sep 1997 16:09:22 GMT, "Chinna" <jchinna_at_enron.com> wrote:

>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
>>
>>
>>
>>

Silvio Seifert
Foehrer Strasse 34
65199 Wiesbaden
Germany Received on Sun Sep 21 1997 - 00:00:00 CDT