Default Quota size
What is the default quota size for the user on default tablepsace?
it is 0.
Seriously, try testing some things out before you ask questions, you might learn something
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;
SQL> create table emp(id number);
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?
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.
Click Here to Expand Forum to Full Width