oracle quota

创建用户导入数据

create user dldb identified by dldb default tablespace DLDATA

grant connect,resource,create view to dldb;
revoke unlimited tablespace from dldb
alter user dldb quota unlimited on DLDATA
imp dldb/dldb fromuser=dldb touser=dldb file=dldb.dmp ignore=y commit=y

查看quota值

select * from dba_ts_quotas where username ='DLDB';