help: grant problem
From: NORHISHAM BIN MAIN <med10054_at_leonis.nus.sg>
Date: 1995/12/28
Message-ID: <4buoc4$i11_at_nuscc.nus.sg>#1/1
Date: 1995/12/28
Message-ID: <4buoc4$i11_at_nuscc.nus.sg>#1/1
Hi,
Currently, I cannot create any grants in my database, The following command will fail as follows:
SQL> grant select, insert, delete on MY_TABLE to SCOTT;
ERROR at line 1:
ORA-00604: error encountered at recursive level 1
ORA-01547: failed to allocate extent of size 131490 in tablespace 'SYSTEM'
What is the units of the size mentioned above ? Is it in blocks or bytes ? I have about 46M free space in my SYSTEM tablespace. Would appreciate any help....
thanxs,
mars
Received on Thu Dec 28 1995 - 00:00:00 CET