Default Quota size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Default Quota size

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Default Quota size

    Hi,

    What is the default quota size for the user on default tablepsace?

    Thanks,
    Malru

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    it is 0.

    Seriously, try testing some things out before you ask questions, you might learn something

  3. #3
    Join Date
    Jul 2002
    Posts
    335
    The guy's a student

  4. #4
    Join Date
    Feb 2006
    Posts
    162
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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

  6. #6
    Join Date
    Feb 2006
    Posts
    162
    Sorry,I made a mistake,but anyhow by this mistake i'll never forget this concept.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width