oracle user quota on tablespace
Solutions on MaxInterview for oracle user quota on tablespace by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle user quota on tablespace"
Emilia
09 Jan 2021
1SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME='MY_USER';
2ALTER USER my_user QUOTA 500M ON my_tablespace;
3ALTER USER my_user QUOTA UNLIMITED ON my_tablespace;similar questions
oracle tablespace datafile max sizeoracle gather table statisticsoracle tablespace autoextendoracle tablespace usagecreate table employees oracleoracle grant roleoracle simple quoteoracle create tablespace autoextendtablespace oraclehow to check last gather stats on table in oracleoracle create role privilegeoracle list grants on procedureoracle table privilegesoracle user tablesoracle allow space to useroracle table statisticsoracle list tablespaceshow to check table lock in oracle sql developerhow to see all table partition in oracleoracle list datafiles in tablespaceoracle show grants on tableoracle table sizeoracle tablespace free spaceoracle undo tablespace list by useroracle tablespace size your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful