OraFAQ Forum: Server Administration » Error ora-01536...pls help?

Home » RDBMS Server » Server Administration » Error ora-01536...pls help?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error ora-01536...pls help? [message #113531]

Mon, 04 April 2005 07:45

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi
i m unable to insert in some table,
error is
ORA-01536: space quota exceeded for tablespace 'SYSTEM' coming.
the size fo table in which i m entering is of 1mb ...
it is in system tablespace ...
now what should i do ..?
please give me steps to get out of this trouble

thanks
sunil mishra

Report message to a moderator

Re: Error ora-01536...pls help? [message #113532 is a reply to message #113531]

Mon, 04 April 2005 07:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

login as DBA user.
here USERNAME is the user as for which the error is thrown.

sql> alter user USERNAME quota unlimited on tablespace system;

note:

Creating custom objects in system tablespace is BAD.

Report message to a moderator

Re: Error ora-01536...pls help? [message #113536 is a reply to message #113532]

Mon, 04 April 2005 08:30

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production

SQL> alter user iqkil quota unlimited on tablespace system;
alter user iqkil quota unlimited on tablespace system
*
ERROR at line 1:
ORA-00922: missing or invalid option

note :- iqkil is username.....

can any user get unlimited quota on system tablespace? .... in my case here user is inserting into one table which is in system table space and the size of that table is now 1MB ...

what to do now ?

sunil

Report message to a moderator

Re: Error ora-01536...pls help? [message #113539 is a reply to message #113536]

Mon, 04 April 2005 08:37

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

apologies.
Thats my typo.
COrrect syntax would be
SQL> alter user iqkil quota unlimited on system;

Report message to a moderator

Re: Error ora-01536...pls help? [message #113542 is a reply to message #113539]

Mon, 04 April 2005 09:16

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

thanks you very much mahesh... by the way i had alter that user who was usng system tablespace as he was creating table and inserting into it .. and now his default tablespace is no more system... yea i had give him unlimited quto on that tablespace to the user .... and he is now moving his table from system tablespace to his default tablespace... he also told me that now everything is working properly and he is able to insert record into table ...

-------------------------------------------------------------
query ....showing how to move table
SQL>alter table <tablename> move tablespace <tablespace name>;
-------------------------------------------------------------
once again thank you very much
sunil.

Report message to a moderator

Re: Error ora-01536...pls help? [message #113588 is a reply to message #113531]

Mon, 04 April 2005 14:57

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

And yes, putting anything in system tablespace is a BAD idea, best to not give anyone permission to do so. Same for sysaux.

Report message to a moderator

Previous Topic:	Buffer Cache
Next Topic:	Oracle 8i 32 bit to Oracle 9i 64 bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:26:07 CDT 2024