Wednesday, September 30, 2009

How to set unlimited quota on tablespace to oracle user

You can set the quota when you create the user like this:


create user username identified by password

  default tablespace tablespaceName

  temporary tablespace temp

  quota unlimited on tablespaceName;


Or You can alter the user after creation like this:


alter user username
   quota unlimited on tablespaceName; 


No comments:

Post a Comment