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

From: simone griffin <simonemg_at_online.no>
Date: Sat, 28 Nov 1998 08:59:32 +0100
Message-ID: <73oajc$123$1@readme.online.no>

Hi Jim.

First of all you should not put ordinarly data in tablespace "SYSTEM". Create tablespaces for "DATA" and "INDEX".

This error message you recieve is telling you that your out of space in tablespace....

Jim Bone wrote in message <365CE792.134EBCD6_at_bonegroupinc.com>...
>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
>jbone_at_mcs.com
>
Received on Sat Nov 28 1998 - 01:59:32 CST