unable to create INITIAL extent

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

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

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

Also, check if any users have SYSTEM as their temporary tablespace with the DBA_USERS view.

Good luck.

That was it! The temporary tablespace was set to SYSTEM for this particular user. Thank you all so much:)

R