Hi,
What is the default quota size for the user on default tablepsace?
Thanks,
Malru
Printable View
Hi,
What is the default quota size for the user on default tablepsace?
Thanks,
Malru
it is 0.
Seriously, try testing some things out before you ask questions, you might learn something
The guy's a student
Thanks davey23uk & bazza,
Why i asked this question was, i thought that without assigning any quota,the user can't create any database objects,but i created a user without assinging any quota & the user can create objects. The activities i did are given below(I'm using ORACLE 9i),
SQL> create user hir identified by hir
2 default tablespace HIREDATATBS
3 temporary tablespace temp;
User created.
SQL> create table emp(id number);
Table created.
SQL> insert into emp values(1);
1 row created.
Now,clear my doubts,
1) Is it possible to create objects without having quota(by default as you said 0) on default tablespace?
2) If it's so,then what is the need of assigning QUOTA?
Thanks,
Malru
that either isnt a full copy and paste of what you did. or you did it in the schema as you created the user as.
Doing what you did there, there is no way that user would even be able to connect to the database let along create anything.
Stop making things or do things properly, or better still LEARN something
Sorry,I made a mistake,but anyhow by this mistake i'll never forget this concept.