Re: tablespace 'SYSTEM'

In article <D1tnsp.D9F_at_mail.auburn.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'
>
> But, I could generate and execute the form. What do I need to do to save the form in this situation.
>
> 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.

In SQL*Forms 3.0, Save means saving the records into the database SQL*Forms tables normally created in the SYSTEM tablespace. Make sure if this is exactly what you want. If this is the case, I would recommend recreating the tools tables in a separate tablespace, say "TOOLS", and leave the SYSTEM tablespace alone. The error you see is definitely an ORACLE error, not a FORMS error, since saving simply means a series of inserts/updates/deletes in the RDBMS' point of view, and the RDBMS in your case fails to allocate more space for the SYSTEM tablespace.

Doing a Generate will save the form into the Filesystem (as the .frm file).

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel