Re: tablespace 'SYSTEM'
Date: 3 Jan 1995 16:03:43 GMT
Message-ID: <3ebsgv$7tr_at_redwood.cs.scarolina.edu>
moorthy_at_eng.auburn.edu (Moorthy N. Rekapalli) writes:
>I am trying to create a default block. When I am saving the form, I am getting the error:
> ORA-01547: failed to allocate extent of size 62 in tablespace 'SYSTEM'
Generating the form creates a system file (UNIX/VMS/DOS/Whatever). Saving the form loads the system tables IAP_% with the form definition.
ORA-1547 means there's no more space in the partition to hold the inserted rows.
Add a file to the system partition by:
OS Prompt: ccf <filename> <size>
with size in oracle blocks (512-byte block on most systems) Try 2000.
sqlplus system/manager
SQL> alter partition system add file '<filename>'
partition altered.
SQL> exit
>Where can I find the solutions for ORA-xxxxx errors. I have SQL*Forms Designer's reference, in which there are only FRM-xxxxx errors.
ORA- errors are described in the ORACLE Error Messages manual.
>Thanks in Advance.
>Moorthy
>(moorthy_at_eng.auburn.edu)
>---
>:=) Do unto others as you would wish to be done by others. :=)
Received on Tue Jan 03 1995 - 17:03:43 CET