Home » RDBMS Server » Security » ORA-01950..........
ORA-01950.......... [message #263055] Tue, 28 August 2007 23:22 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,
I have searched a lot on net for the meaning of QUOTA and i found a lot of information but i was not able to understand, because

I have created a user by name "Naveen" and allocated a default tablespace by name "Navtbs", but when i tried to create object i got following error:-

SQL> create table Student
2 (
3 num number
4 );
create table Student
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'Navtbs'


I have already created default tablespace for user Naveen then again why i need to give space(quota) for creation of table, but if i give quota on default tablespace "Navtbs" i am able to create table.

I am getting really confused by QUOTA. Please guide me.

Regards,
Naveen

[Updated on: Tue, 28 August 2007 23:23]

Report message to a moderator

Re: ORA-01950.......... [message #263056 is a reply to message #263055] Tue, 28 August 2007 23:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quota is quota.

You can have clear understand if you are using windows XP/2003. There is quota management.Also in Unix it have. That is there are differnt users and assign different disk space to them so that they could not limit the usage that are assigned to them.

In tablespace there is also quota. Unless you give some quota on that tablespace the user can't use disk space of that tablespace.

Quota is fully related with disk space usage.

If you give default then that tablespace is default but he have no disk space to store data/objects. And give quota means you have allocated him permission to use some part/disk space of that tablespace to the specified tablespace.
Re: ORA-01950.......... [message #263135 is a reply to message #263055] Wed, 29 August 2007 03:07 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#15298
Re: ORA-01950.......... [message #263142 is a reply to message #263056] Wed, 29 August 2007 03:41 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Are you sure...creating objects in the default tablespace is throwing you error.

Quote:
In tablespace there is also quota. Unless you give some quota on that tablespace the user can't use disk space of that tablespace.


By default the quota is unlimited...so you dont need to specify it.

Quote:
If you give default then that tablespace is default but he have no disk space to store data/objects. And give quota means you have allocated him permission to use some part/disk space of that tablespace to the specified tablespace.


I dont think so....he can use it for storing objects once it has been assigned to the user
Re: ORA-01950.......... [message #263148 is a reply to message #263055] Wed, 29 August 2007 03:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
creating objects in the default tablespace is throwing you error.


Yes. Unless you don't give quota permission to the specified user.


Quote:
I dont think so....he can use it for storing objects once it has been assigned to the user


What I told???
Re: ORA-01950.......... [message #263165 is a reply to message #263055] Wed, 29 August 2007 04:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
By default the quota is unlimited...so you dont need to specify it.



Never , ever, never it will be. By default when you create user no quota is granted, unless you assign quota on the user.

If you assign dba then quota by default will be unlimited.

However you can set to a specific value, by

ALTER USER test
QUOTA 100K ON tablespace;
Re: ORA-01950.......... [message #263174 is a reply to message #263165] Wed, 29 August 2007 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Arju wrote on Wed, 29 August 2007 11:33
Quote:
By default the quota is unlimited...so you dont need to specify it.



Never , ever, never it will be.

It was in version before 8 (or maybe 7) but for SYSTEM tablespace.

Regards
Michel

Re: ORA-01950.......... [message #263177 is a reply to message #263055] Wed, 29 August 2007 05:00 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thanks Michel for the information.
Previous Topic: Row-level auditing
Next Topic: how to make a user able to use tables in diferent table spaces
Goto Forum:
  


Current Time: Fri Aug 01 19:54:04 CDT 2014

Total time taken to generate the page: 0.09729 seconds