Home » RDBMS Server » Server Administration » Qouta
icon5.gif  Qouta [message #155548] Tue, 17 January 2006 03:27 Go to next message
fahim140
Messages: 5
Registered: January 2006
Junior Member
hi all
i m new in oracle.
i want change my tables qouta but i cant .it need some privilage and i set them but i cant change the qouta yet.
when i log in with admin account , i have this problem too.
would u plz help me?

(actualy i cant insert data to my table from my application,so i think its qouta has some problem).

thx so much.

Report message to a moderator

Re: Qouta [message #155551 is a reply to message #155548] Tue, 17 January 2006 03:40 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

In Oracle quota is assigned for tablespaces and not for tables. And tables are stored inside the tablespaces.

What is the error that you are getting??

Are you getting the same error when you issue the insert command from SQLPLUS prompt?

Report message to a moderator

Re: Qouta [message #155553 is a reply to message #155551] Tue, 17 January 2006 03:55 Go to previous messageGo to next message
fahim140
Messages: 5
Registered: January 2006
Junior Member
hi
i login with system account as a sys dbaand select security item then the scott(the user i use.it has the dba roll).when i click the Qouta tab recive this message:

Resource roll,or Unlimited System Privilage Granted.

what can i do?

thx for ur help.

Report message to a moderator

Re: Qouta [message #155556 is a reply to message #155553] Tue, 17 January 2006 04:07 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Sorry Fahim but No body can guess what is happening at your end with the information you have posted.

post the output of the SQL queries that you are running and what table you are using, under which user ??

What application you are using ??


Report message to a moderator

icon5.gif  Re: Qouta [message #155564 is a reply to message #155556] Tue, 17 January 2006 04:44 Go to previous messageGo to next message
fahim140
Messages: 5
Registered: January 2006
Junior Member
hi
plz let me ask another question.
i use developer 6i and create some forms .i want insert data to my tables from these forms.i have a button and write a very simple query for it in every forms.

when_button_pressed
commit_form;

i run the .fmb file and start to enter data then press button
i recive this error:
FRM-40508 ORACLE error : Unable to insert Record.

so i think my tables setting may not complete.(and asked privieus question)

i use Scott user.create 4 tables in its schema and assinged DBA roll to Scott user.

Thanks & regards

Report message to a moderator

Re: Qouta [message #155576 is a reply to message #155564] Tue, 17 January 2006 05:29 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Good ,

This is the way to ask question, now anyone can understand.

Look, first of all try to insert records in the table from SQLPLUS rather than Developer.

If you are able to insert records from SQLPLUS then no issues from the table side i.e. some problem with developer and if not then come back with the specific error.

Report message to a moderator

Previous Topic: Copying tables from one database to another database(urgent)
Next Topic: Statement Performance - SGA Cache
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 10:55:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.