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

Looks like you have run out of space in the tablespace where you are trying to insert records.

You can add a datafile to an existing tablespace by issuing: alter tablespace x
add datafile '......full path name/newdbfilename.dbf' size 100M;

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 Thu Nov 26 1998 - 12:36:20 CST