| ORA-01950.......... [message #263055] |
Tue, 28 August 2007 23:22  |
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  |
|
|
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 #263142 is a reply to message #263056] |
Wed, 29 August 2007 03:41 |
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 |
|
|
| 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 |
|
|
| 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;
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
