ORA-01658: Unable to create INITIAL extent for segment in tablespace %s


You are trying to create a new object, but the initial extent does not fit into the tablespace specified.

There is not enough space left inside the tablespace either due to the datafiles being full, autoextend which is not set at datafile level or due to a disk which's full.

You'll have to check the size of the datafiles attached to the tablespace and check whether they can autoextend or not..

Alternatively you can specify a smaller size for the initial extent.

select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='TABLESPACE_NAME'


Either add more datafiles to the tablespace, set the autoextensible flag or enlarge the datafile(s).

To add more space to a file issue following command:

alter database datafile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\TS_TP.DBF' resize 100m;

To turn on the autoextend feature on a datafile use following command:

alter database datafile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\TS_TP.DBF' autoextend on next 200m maxsize 2000m;

To add a new datafile to the tablespace use following command:

alter tablespace TS_DP add datafile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\TS_TP.DBF' autoextend on next 200m maxsize 2000m;

4 comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Anonymous said...

useful info

Léo Bruski said...

Funcionou perfeitamente, obrigado!

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.