Re: Error when creating table
Date: 1997/03/13
Message-ID: <NEWTNews.858280067.1809.pdensmore_at_osf197.OKLAOSF.STATE.OK.US>#1/1
In Article<33262AE2.167E_at_intrasystems.com>, <jimh_at_intrasystems.com> writes:
> Path: news.ou.edu!leto.ou.edu!hammer.uoregon.edu!news-peer.gsl.net!news.gsl.net!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!cam-news-feed2.bbnplanet.com!newshost.oa.net!not-for-mail
> From: "James C. Hanrahan" <jimh_at_intrasystems.com>
> Newsgroups: comp.databases.oracle
> Subject: Error when creating table
> Date: Tue, 11 Mar 1997 20:02:42 -0800
> Organization: IntraSystems Inc.
> Lines: 32
> Message-ID: <33262AE2.167E_at_intrasystems.com>
> NNTP-Posting-Host: 207.141.168.66
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 3.01Gold (X11; I; IRIX 6.2 IP22)
> Xref: news.ou.edu comp.databases.oracle:95537
>
> Help:
> When I try to create a table as a user with dba permissions
> I get the following error. Can anyone let me know what it is??
>
> Here is the sql statement
> ------------------------------------------------------
> create table tech (
> techpatid number(24) not null
> ,techlname varchar2(24) not null
> ,techfname varchar2(24) not null
> ,technotes varchar2(2000)
> ,constraint eeg_primary_key primary key (techpatid)
> ) tablespace development
> storage (initial 500K
> next 100K
> maxextents 50) ;
>
> ------------------------------------------------------
> Here is the error
> ----ORA-01658: unable to create INITIAL extent for segment in tablespace
> DEVELOPMENT
> ------------------------------------------------------
>
> Any and all help would be greatly appreciated.
>
> Thanks in advance,
>
> James C. Hanrahan jimh_at_intrasystems.com
> Systems Engineer
> IntraSystems Inc. Voice (617) 830-0300
> 1017 Turnpike St. Fax (617) 830-9940
> Canton MA. 02021 http://www.intrasystems.com
This means that you do not have 500k of contiguous free space within the development tablespace. Try this query to determine how much contiguous free space actually exists:
SELECT FILE_ID, BLOCK_ID, BLOCKS, BYTES FROM SYS.DBA_FREE_SPACE
WHERE TABLESPACE_NAME = 'DEVELOPMENT'
ORDER BY BLOCK_ID;
You may need to coalesce the free space or add another data file to the
tablespace.
Good Luck. Received on Thu Mar 13 1997 - 00:00:00 CET