unable to create INITIAL extent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: unable to create INITIAL extent

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    All -

    I am getting the following error when I try to do massive inserts & deletes.

    *******************************
    The following error has occurred:

    ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
    *******************************

    After doing some research, I tried the following:

    1) set maxextents unlimited
    2) set autoextend on
    3) coalesce

    The problem still persists. The maxsize of the datafile is unlimited and has 36GB of disk space left...

    Any suggestions?

    R
    On the other hand, you have different fingers.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    so you are creating objects in tablespace SYSTEM, itīs a bad idea because tablespace SYSTEM is almost impossible to reorganize once itīs fragmentated
    But anyway unable to create initial extent means there arent enough contiguos freespace to acomodate the new initial extent, check the creation script

  3. #3
    Join Date
    Jun 2001
    Posts
    76
    The default tablespace for this user is not system, it is "billing_ts"... Why would it create objects in the SYSTEM tablespace? How can I change this?

    R
    On the other hand, you have different fingers.

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Also, check if any users have SYSTEM as their temporary tablespace with the DBA_USERS view.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Jun 2001
    Posts
    76
    That was it! The temporary tablespace was set to SYSTEM for this particular user. Thank you all so much

    R
    On the other hand, you have different fingers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width