摘要:
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 阅读全文
摘要:
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... 阅读全文