oracle相关命令

发表于 | 分类于 ， ， |
字数统计: 71 | 阅读时长 ≈ 1

正文

新建一个库

1
2
3
4
5
su - oracle
sqlplus / as sysdba
create tablespace xxljob datafile '/opt/oracle/db01/app/oracle/product/11.2.0/oradata/orcl/xxljob.dbf' size 3000m;
create user xxljob identified by xxljob default tablespace xxljob quota 1000m on users;
grant all privileges to xxljob;

这样就建立了一个xxljob的库，用户名为xxljob 密码为xxljob

参考资料

Cream Bing wechat
subscribe to my blog by scanning my public wechat account