Sql

Search

oracle user quota on tablespace

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME='MY_USER';
ALTER USER my_user QUOTA 500M ON my_tablespace;		
ALTER USER my_user QUOTA UNLIMITED ON my_tablespace;

Comment

PREVIOUS	NEXT

Code Example
Sql :: last 6 months postgresql
Sql :: mysql mediumint max value
Sql :: helptext in sql
Sql :: oracle alter table add not null constraint
Sql :: update select
Sql :: how to get weekday from old date in sql
Sql :: the package java.sql is not accessible
Sql :: sqlserver create table from select
Sql :: sql drop table statement
Sql :: replace null with 0 in sql
Sql :: drop all database tables oracle sql developer
Sql :: postgresql get year
Sql :: mysql shell ERROR: Not connected.
Sql :: sql myisam vs innodb
Sql :: alter table in mysql
Sql :: run mysql xampp shell
Sql :: show tables postgresql
Sql :: Uncaught Error: Cannot use object of type mysqli_result as array
Sql :: mysql remove user privileges
Sql :: where to locate set password for mysql
Sql :: sql server format datetime
Sql :: create table with select
Sql :: mysql error incompatible with sql_mode=only_full_group_by
Sql :: mysql alter table modify column
Sql :: zsh: command not found: mysql mamp
Sql :: sql decimal to 2 places
Sql :: mysql how to change default charset
Sql :: mysql sort descending
Sql :: postgresql change default value
Sql :: select top 10 rows in sql

Search

SQL

oracle user quota on tablespace

ADD CONTENT