-
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.
-
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
On the other hand, you have different fingers.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|