create tablespace you datafile 'E:\app\Administrator\oradata\you\you1.dbf'
size 500M
autoextend on next 100M
maxsize unlimited
logging online permanent;--创建表空间

create user you_user identified by you_user default tablespace fuyou;--创建用户

grant connect,resource to you_user;  
grant create any sequence to you_user;  
grant create any table to you_user;  
grant delete any table to you_user;  
grant insert any table to you_user;  
grant select any table to you_user;  
grant unlimited tablespace to you_user;  
grant execute any procedure to you_user;  
grant update any table to you_user;  
grant create any view to you_user;  
grant dba to you_user;--可以不要这个权限

--授权

多个数据库，多个ORCL的OID切换方式：

set ORACLE_SID=sids1

添加数据文件：

alter tablespace venn add datafile '/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'
size 10M
autoextend on next 100M
maxsize 500M ;

------------正 文 已 结 束， 感 谢 您 的 阅 读 （折雨的天空）--------------------

转载请注明本文标题和链接：《oracle命令行下创建账户》