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

Hi Jim.

First of all you should create own tablespaces for data and indexes, not put data in
"SYSTEM" tablespace.

This error messages clearly tells you that it cannot allocate the space needed to
insert your record, so normally you should increase your tablespace  add/rezise
your tablespace.).
Insert and updates are controlled by pctused and pctfree, maybe you should have a look at these parameters.

What happends if you trie to insert records in table y (dublicate )? are you recieving
the same error?

Jan
Jim Bone wrote in message <365EC13E.F1C48996_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
>
>
>
>
Received on Sat Nov 28 1998 - 02:21:07 CST