ALTER USER test1 QUOTA 10m on test_tbs; --设置限额=10m
ALTER USER test1 QUOTA; --不受限制
ALTER USER test1 QUOTA 0 ON test_tbs; --收回限额
select * from DBA_TS_QUOTAS; --查看所分配的配额情况
Oracle关于配额的几条简单命令
最新推荐文章于 2022-01-02 10:34:18 发布
ALTER USER test1 QUOTA 10m on test_tbs; --设置限额=10m
ALTER USER test1 QUOTA; --不受限制
ALTER USER test1 QUOTA 0 ON test_tbs; --收回限额
select * from DBA_TS_QUOTAS; --查看所分配的配额情况