摘要: 1、清理工作清除用户gsfund201SQL> drop user gsfund201 cascade;用户已删除。清除表空间如果有,就清除;没有可以省略此步骤;创建表空间SQL> create tablespace app_132gsfund datafile 'D:\APP\ARCERZHANG\ORADATA\AZDB\app_gsfund01.dbf' 2 size 200m 3 autoextend on 4 NEXT 200m MAXSIZE UNLIMITED 5 extent management local;表空间已创建。创建用户gsfunddev 阅读全文
posted @ 2014-03-07 21:33 ArcerZhang 阅读(163) 评论(0) 推荐(0) 编辑
摘要: 1、查询SQLSQL> select machine,address,piece,sql_text from v$session,v$sqltext where address=sql_address and osuser 'SYSTEM' order by address,piece;2、SQL... 阅读全文
posted @ 2014-03-07 08:45 ArcerZhang 阅读(214) 评论(0) 推荐(0) 编辑