csq39 发表于 2017-11-28 11:12:09

创建表空间以及用户

<p>1：创建表空间</p><pre class="brush:java;toolbar:false">create&nbsp;tablespace&nbsp;ksk&nbsp;logging&nbsp;datafile&#39;/u01/app/oracle/oradata/orcl/ksk.dbf&#39;&nbsp;
size&nbsp;1024m&nbsp;autoextend&nbsp;on&nbsp;next&nbsp;100m&nbsp;maxsize&nbsp;unlimited&nbsp;extent&nbsp;management&nbsp;local;</pre><p>2：创建用户</p><pre class="brush:java;toolbar:false">create&nbsp;user&nbsp;ksk&nbsp;identified&nbsp;by&nbsp;ksk&nbsp;default&nbsp;tablespace&nbsp;ksk&nbsp;temporary&nbsp;tablespace&nbsp;temp;</pre><p>3：用户授权</p><pre class="brush:java;toolbar:false">grant&nbsp;dba&nbsp;to&nbsp;ksk;</pre><p><br/></p><p><br/></p>

csq39 发表于 2017-12-18 16:33:52

su - oracle

sqlplus / as sysdba
页: [1]
查看完整版本: 创建表空间以及用户