Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> window solution :-)

window solution :-)

From: jazzz_ <jazzz__at_poczta.onet.pl>
Date: Tue, 22 Feb 2005 14:33:32 +0100
Message-ID: <cvfcjf$slk$1@nemesis.news.tpi.pl>


OK, thanks for your help
I found solution.

here is Windows version:

  1. Make batch file 1.sql which include:

sqlplus @c:\username.sql

2. Make file username.sql and inside put:

us/pass_at_db
spool c:\parm1.txt
set pages 1000
set pause off
set feedback off
set head off
begin
select username from all_users where username<>'DEMO' AND username<>'SYS' AND username<>'SYSTEM' AND username<>'SCOTT' AND username<>'DBSNMP'; exit;

3. run 1.sql Received on Tue Feb 22 2005 - 07:33:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US