| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Very Urgent ,Help me
Hi Saroj
The problem is that you do not have a chunk of free space the size of the
initial extent
for the segment you are creating in the particular tablespace.
You may have enough free space within the tablespace but you do not have a
chunk the size of the initial extent.
Oracle allocates contiguous space to extents.
Here is a query that would help you.
select max(bytes/1024/1024) from dba_free_space where tablespace_name='TABLESPACE NAME';
This will give you the maximum size chunk (in MEGS) available to allocate to any extent within the SPECIFIED tablespace. Compare this value to the initial extent for the segment you are trying to create.
When you are create the segment make sure the initial extent is smaller than this value else you will get the error.
You can overcome the error ora 1658 by using a smaller initial extent or by adding another datafile to your tablespace.
HTH
Suhen Pather
Oracle
Strandbags
Australia
email suhen.pather_at_strandbags.com.au
-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com]
Sent: Thursday, 9 November 2000 12:41
To: Multiple recipients of list ORACLE-L
Subject: Very Urgent ,Help me
Hi,
I got a problem of error ora 1658.
Please tell me what are the best ways to solve this problem.
Tell me the step.
THe problem is like this.
, "unable to create INITIAL extent for segment in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate INITIAL // extent for segment being created. // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the // tablespace or retry with a smaller value for INITIAL
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 08 2000 - 20:42:04 CST
 |
 |