Re: Unable to create INITIAL extent for segment in tablespace

Yulia wrote:
>
> I want to create a simple table and I got error like:
>
> create table test_db (line_num number(3), line_text varchar2(128));
> *
> ERROR at line 1:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> DEV_DATA1
>
> What can I do about it?

Have a look at DBA_FREE_SPACE for tablespace DEV_DATA1. It probably needs either a coalesce ( to get a single chunk large enough) or an increase in space (via its datafiles)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse