Re: ORA-01547: failed to allocate extent size of 95 in tablespace 'SYSTEM'

The SYSTEM tablespace should only be used by, as the word says, the Oracle system. You data should reside on another tablespace. It stores information about your tables, indexes, etc.

Although there is nothing stopping you from just using the SYSTEM tablespace, it is not a recommended practice. Read about the Oracle Flexible Archtecture.

Now to the error message, you have to allocate additional extents to be able to do this (that is, assuming you want to only use SYSTEM tablespace). In version 7.3 (!?), you have the option to automatically allocate additional extents when needed. I think you have to do allocate this manually with earlier versions

Jim Bone wrote:

> Hi,
>
> Can anyone help me with this error. I have an Oracle Server 7.0.12.1.0
> database running on SCO. I'm trying to insert records into a table x
> and am receiving this error. I only have one table space "SYSTEM".
>
> What's really confusing to me is that I can duplicate this same table by
>
> creating an empty table called y and then inserting all of table x's
> records into it without any problem.
>
> Can anyone tell me what this error means and how to correct it?
>
> Thanks in advance for any help
>
> Jim in Chicago
Received on Sat Nov 28 1998 - 04:23:00 CST