ORACLE Import

From: Oscar Ssentoogo <impala_at_enterprise.net>
Date: 1997/09/03
Message-ID: <5ujmn3$93p$1@news.enterprise.net>#1/1

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 Wed Sep 03 1997 - 00:00:00 CDT