oracle创建库
创建表空间
create tablespace TBS_DATA datafile ‘/u01/oradata/tbs_data01.dbf‘ size 16G autoextend off; create tablespace TBS_DATA_IDX datafile ‘/u01/oradata/tbs_data_idx01.dbf‘ size 8G autoextend off;
创建用户
create user ora001 identified externally account unlock; grant connect to ora001; grant resource to ora001;
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/15315.html