![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: QUOTA
Definition: ALTER USER <user_name> QUOTA <quota size> ON <tablespace name>; Example Usage: This example will allocate 50 megabytes to the user "bob": ALTER USER bob QUOTA 50M ON tspace_1; This example will allow unlimited space to the user "bob": ALTER USER bob QUOTA unlimited ON tspace_1; For more QUOTA examples and options, please view the page on Oracle Users & Schema Owners.
Related Links:
Related Code Snippets:
|
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 42 users online © 2009 psoug.org |