Oracle 工具SQL

<span style="font-family: Arial, Helvetica, sans-serif;"></span><pre name="code" class="sql">--创建数据表空间
create tablespace TEST
logging
datafile 'D:\app\hanjianxiang\oradata\orcl\TEST.DBF' 
size 32m 
autoextend on 
next 32m maxsize 8000m;
--删除用户
drop user ynzc cascade;
--新建用户
create user ynzc identified by ynzc  default tablespace TEST  ;
--授权
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,DBA,CONNECT,RESOURCE,CREATE SESSION TO ynzc;
--导出  
exp hanjianxiang/hanjianxiang@orcl file=d:\20151207_hjx.dmp owner=hanjianxiang;  
expdp hanjianxiang/hanjianxiang@orcl schemas=hanjianxiang dumpfile=expdp.dmp DIRECTORY=dpdata1;  
--imp 导入  cmd命令行操作  （更具系统配置，指定用户）
imp ZCGL_QGRD/ZCGL_QGRD@ORCL   file=D:\datebase\20160224.dmp  log=D:\datebase\201604011029.log ignore=y  fromuser=ZCGL_QGRD touser=ZCGL_QGRD ; imp hanjianxiang/hanjianxiang@ORCL  file=D:\datebase\ynyj2015年12月28日23.dmp  log=D:\datebase\20151229.log ignore=y  full=y;
--增大表空间
ALTER DATABASE DATAFILE 'D:\app\hanjianxiang\oradata\orcl\TEST.DBF' 
AUTOEXTEND ON NEXT 100M 
MAXSIZE 10240m;
<pre name="code" class="sql">--增加游标
alter system set open_cursors=1000;
select USER_NAME, count(*) from  v$open_cursor GROUP BY USER_NAME;
--创建10g+表空间
create bigfile tablespace BJ_ZCGL datafile 'D:\app\hanjianxiang\oradata\orcl\BJ_ZCGL.DBF' size 1G autoextend on next 1G maxsize 90G;
--数据泵导入
--建立目录
create directory dump_TOTEST as'D:\datebase'
Select * from dba_directories
--赋权
Grant read,write on directory dump_TOTEST to BJ_ZCGL
--cmd导入<span style="font-family: Arial, Helvetica, sans-serif;">数据泵导入</span>

Impdp BJ_ZCGL/BJ_ZCGL DIRECTORY=dump_TOTEST  DUMPFILE=BJ_ZCGL_ALL_10G_EXPDP_2016-02-17.dmp  logfile=impdp_201603281304.log FULL=y 

<span style="font-family: Arial, Helvetica, sans-serif;">--未完待续</span>