You can use a script to do this , I have a demo for you :
D:\>type user.sql
set termout off
set feedback off
set verify off
set echo off
set pagesize 0
spool d:\user.lst
select username from dba_users;
spool off
D:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on 星期二 10月 21 11:24:26 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> @user.sql
SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production中断开
D:\>type user.lst
SYS
SYSTEM
DBSNMP
EYGLE
REPADMIN
SCOTT
OUTLN
WMSYS
-Eygle
取消
评论