tablespace extents, i think

From: Tim Maggio <tim_at_sun1.claremont.com>
Date: Fri, 25 Mar 1994 18:14:16 GMT
Message-ID: <TIM.94Mar25131416_at_sun1.claremont.com>


I am back with YAP (Yet Another Problem)-

I have a tablespace of about 300 MB with tables amounting to 107 MB and indexes amounting to 20 MB leaving me with 170 MB or so.

One table is about 50 MB, which I drop and recreate every week or so (during testing). Along with the recreation process, I build several indexes. The first one is usually about 13 MB or so. This time, Oracle complains with:

   on ilx_detail( company_id, controller, user_id )

      *
   ERROR at line 2:
   ORA-01547: failed to allocate extent of size 5120 in tablespace 'DEANDATA'

The tablespace was created with:

	create tablespace deandata
	datafile '/home/oracle/7data/deandata.dbs' size 90M
	default storage (
		initial 20m
		maxextents 249
		pctincrease 0
		next 4m )
	online
	/

Any help would be appreciated.

--
Tim Maggio
tim_at_claremont.com
Received on Fri Mar 25 1994 - 19:14:16 CET

Original text of this message