【DBA脚本】使用spool命令将sqlplus屏幕内容输出到文件
使用spool命令将sqlplus屏幕内容输出到文件
用法
SQL> spool c:\spooltest.log
SQL操作
SQL> spool off
------------------------------
例子：
-----------------------------
以上。
------------------------------
例子：
SQL> spool c:\spooltest.log
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
SCOTT OPEN
HR OPEN
OUTLN EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
ANONYMOUS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
TSMSYS EXPIRED & LOCKED
BI EXPIRED & LOCKED
PM EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
IX EXPIRED & LOCKED
SH EXPIRED & LOCKED
DIP EXPIRED & LOCKED
OE EXPIRED & LOCKED
已选择27行。
SQL> spool off
SQL>
SQL> get c:\spooltest.log
1 SQL> select username,account_status from dba_users;
2 USERNAME ACCOUNT_STATUS
3 ------------------------------ --------------------------------
4 MGMT_VIEW OPEN
5 SYS OPEN
6 SYSTEM OPEN
7 DBSNMP OPEN
8 SYSMAN OPEN
9 SCOTT OPEN
10 HR OPEN
11 OUTLN EXPIRED & LOCKED
12 MDSYS EXPIRED & LOCKED
13 ORDSYS EXPIRED & LOCKED
14 EXFSYS EXPIRED & LOCKED
15 DMSYS EXPIRED & LOCKED
16 WMSYS EXPIRED & LOCKED
17 CTXSYS EXPIRED & LOCKED
18 ANONYMOUS EXPIRED & LOCKED
19 XDB EXPIRED & LOCKED
20 ORDPLUGINS EXPIRED & LOCKED
21 SI_INFORMTN_SCHEMA EXPIRED & LOCKED
22 OLAPSYS EXPIRED & LOCKED
23 TSMSYS EXPIRED & LOCKED
24 BI EXPIRED & LOCKED
25 PM EXPIRED & LOCKED
26 MDDATA EXPIRED & LOCKED
27 IX EXPIRED & LOCKED
28 SH EXPIRED & LOCKED
29 DIP EXPIRED & LOCKED
30 OE EXPIRED & LOCKED
31 已选择27行。
32* SQL> spool off
33
SQL>
-----------------------------
以上。
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20335819/viewspace-713590/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
