lake 发表于 2018-7-11 14:10:56

oralce数据库创建用户以及导入数据

<p>linux下安装完数据库后，新建表空间的地址不在oracle安装目录内，相关操作记录如下:<br/></p><p>用root用户授权：</p><pre class="brush:java;toolbar:false">chown&nbsp;-R&nbsp;oracle.dba&nbsp;/mnt/</pre><p>切换回oracle用户，<br/></p><pre class="brush:java;toolbar:false">su&nbsp;-&nbsp;oracle</pre><p>登录sqlplus<br/></p><pre class="brush:java;toolbar:false">sqlplus&nbsp;/&nbsp;as&nbsp;sysdba</pre><p>创建表空间<br/></p><pre class="brush:java;toolbar:false">create&nbsp;tablespace&nbsp;usc&nbsp;logging&nbsp;datafile&#39;/mnt/oracle/oradata/orcl/usc/usc.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>创建用户</p><pre class="brush:java;toolbar:false">create&nbsp;user&nbsp;usc&nbsp;identified&nbsp;by&nbsp;usc&nbsp;default&nbsp;tablespace&nbsp;usc&nbsp;temporary&nbsp;tablespace&nbsp;temp;</pre><p>用户授权</p><pre class="brush:java;toolbar:false">grant&nbsp;dba&nbsp;to&nbsp;ups,usc;</pre><p><br/></p><p>数据库的连接地址</p><pre class="brush:java;toolbar:false">ups-cloud&nbsp;=
&nbsp;&nbsp;(DESCRIPTION&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS_LIST&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=IP地址)(PORT&nbsp;=&nbsp;1521))
&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;(CONNECT_DATA&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SERVER&nbsp;=&nbsp;DEDICATED)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SERVICE_NAME&nbsp;=&nbsp;orcl)
&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;)</pre><p>导入数据库</p><pre class="brush:java;toolbar:false">impdp&nbsp;ups/ups@ip:1521/orcl&nbsp;schemas=dmp内用户&nbsp;dumpfile=ups.dmp&nbsp;remap_schema=dmp用户:ups&nbsp;REMAP_TABLESPACE=dmp表空间:ups&nbsp;&nbsp;REMAP_TABLESPACE=mp表空间::ups&nbsp;REMAP_TABLESPACE=mp表空间::ups&nbsp;&nbsp;&nbsp;version=10.2.0</pre>

lake 发表于 2018-8-15 16:19:23

create tablespace uscdsq logging datafile'/u01/app/oracle/oradata/orcl/uscdsq.dbf' size 1024m autoextend on next 100m maxsize unlimited extent management local;

lake 发表于 2018-12-7 16:52:08

<p>百度：</p><p>create tablespace hos05 logging datafile&#39;/data/oracle/oradata/orcl11g/hos05.dbf&#39; size 1024m autoextend on next 100m maxsize unlimited extent management local;</p><p>create user hos05 identified by xxxx default tablespace hos05 temporary tablespace temp;<br/></p><p>grant dba to ups,usc,mps,mhs,hos01,hos02,hos03,hos04,hos05;<br/></p><p><br/></p>

lake 发表于 2019-3-25 11:33:38

<p>&nbsp; &nbsp;开发库：&nbsp;</p><p>create tablespace uhq logging datafile&#39;/u01/app/oracle/oradata/orcl/uhq.dbf&#39; size 1024m autoextend on next 100m maxsize unlimited extent management local;&nbsp;</p><p>create user uhq identified by uhq default tablespace uhq temporary tablespace temp;&nbsp;</p><p>grant dba to uhq; &nbsp; &nbsp;</p>
页: [1]
查看完整版本: oralce数据库创建用户以及导入数据