Redstone Content Solutions
  • About
  • Solutions
  • Product
  • Cloud
  • Business Blog
  • Technical Blog

ORA-01658 Unable to create initial extent for segment in tablespace

9/24/2009

0 Comments

 
The other day I was using an Oracle database tablespace supplied by a dba for a development environment and when I went to rebuild the full text index the Repository Manager greeted me with this nifty little error:

ORA-01658: unable to create initial extent for segment in tablespace

Fun huh?



Ok, this is a development box, lots of space. I thought this was all setup to expand on need, but let's check it out. First, we need to go to the database via something like Toad, SQL Developer or JDeveloper and execute a Query similar to this one:

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

You're tablespace name will vary, BUT REMEMBER: the value you supply for tablespace name is case sensitive

Running this query I find out that autoextend is NOT turned on, and further exploration yields a maxed out datafile. Fine, let's get autoextend turned ON. Here's two samples:

alter database datafile
'C:\Oracle\app\oradata\orcl\DEVWCM_SYSTEM.DBF'
autoextend on;
alter database datafile 'C:\Oracle\app\oradata\orcl\DEVWCM_SYSTEM.DBF'
autoextend on next 100m maxsize 2000m;

In the first case we're going to simply turn on autoextend and let it ride. In case number two you can see some extra instructions including how much to extend and a limit.

And did this take care of the problem? Yep. Sweet, a fresh, clean, working index.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Build your career in software development at Redstone Content Solutions as an Oracle WebCenter Consultant

    Categories

    All
    Collaborate
    Content Server
    Database
    Dev Tricks
    Digital Asset Management
    Linux
    Misc
    Oracle OpenWorld
    Oracle OpenWorld
    Oracle UCM
    Oracle UCM
    WebCenter Content
    WebCenter Sites
    WebLogic Server

    Archives

    March 2017
    June 2015
    December 2014
    June 2013
    February 2013
    October 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    February 2012
    January 2012
    December 2011
    October 2011
    September 2011
    July 2011
    June 2011
    May 2011
    April 2011
    February 2011
    January 2011
    October 2010
    September 2010
    August 2010
    July 2010
    May 2010
    April 2010
    March 2010
    February 2010
    December 2009
    November 2009
    October 2009
    September 2009
    August 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    December 2008
    November 2008
    October 2008
    September 2008
    August 2008
    July 2008

Powered by Create your own unique website with customizable templates.
  • About
  • Solutions
  • Product
  • Cloud
  • Business Blog
  • Technical Blog