oracle sql实行工具,Oracle 工具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 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;

--增加游标

alter system set open_cursors=1000;

select USER_NAME, count(*) from v$open_cursor GROUP BY USER_NAME;--未完待续