Oracle创建用户和表空间

create user clover identified by 12345;

create tablespace clover_tablespace datafile ‘E:Oracle_11gappCloveroradataorclclover_local.dbf‘ size 1000M autoextend on next 100M;

create temporary tablespace clover_space tempfile ‘E:Oracle_11gappCloveroradataorclclover_temp.dbf‘ size 50M autoextend ON next 10M maxsize 100M; 

alter user clover default tablespace clover_tablespace temporary tablespace clover_space;

grant connect,RESOURCE,dba to clover;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!