Oracle segment space

Question

I have a Tablespace with some tables and I can insert data without problem. Now I want to create a new table and I get this:

00000 - "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.

My question is: if there is a space problem, why am I able to insert data but not create new tables?

This is the CREATE script:

CREATE TABLE EC_SYS_NOTIFY_KYC (
  ID NUMBER(38,0) PRIMARY KEY,  
  ID_OP NUMBER(38,0),
  PROCESS_ID VARCHAR2(50) NOT NULL,   
  SYSTEM_ID VARCHAR2(50) NOT NULL)
TABLESPACE ECONTKYC_LARGE_1;

The problem is in: Failed to find sufficient **contiguous** space. — Marmite Bomber, Jul 12 '18 at 08:26
Thanks for your comment. I´m not DB Admin. To deal with this problem should I request more space to the Admins? Or some type of defragmentation is necessary? — Marco A. Hernandez, Jul 12 '18 at 08:43
see [this](https://stackoverflow.com/questions/37071152/ora-01658-unable-to-create-initial-extent-for-segment-in-tablespace-ts-data?answertab=active#tab-top) answer. — Marmite Bomber, Jul 12 '18 at 08:53

William Robertson · Accepted Answer · 2018-07-12T09:20:02.090

0

Space in Oracle is allocated in chunks called 'extents'. Your existing tables have already been allocated extents containing enough space to allow inserts for now, but you don't have enough unallocated free space in the tablespace to add a whole new extent, which is needed for a new table.

Eventually inserts into existing tables will start to fail as well, when their existing space is used up and they need more.

edited Jul 12 '18 at 09:20

answered Jul 12 '18 at 09:13

William Robertson

15,273
4
38
44

Ok, understood. A resize request solved the problem. Many thanks William. – Marco A. Hernandez Jul 12 '18 at 09:19

Oracle segment space

1 Answers1