| 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 #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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
