RE: Need Script!!

[Seefelt, Beth]

There's great freeware smtp client called BLAT that you can use.  You
can probably google search for it or find it on www.download.com

HTH.


-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L


Hi Group,

In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.

Here we need to send mails if the DB is down or if the listener is down
or
any errors in the alert log is found. In Unix we can use shell scripts
and
awk to do this. What about in NT/

Guru's do you have any scripts to do the same.

Please help me in this.

TIA,
Senthil.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Senthil Kumar D
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

[Seefelt, Beth]

Hi,

I think FORFILES is probably overkill here.  And it probably is only
going to return the errorlevel for the last file checked.  Just use
FINDSTR with a wildcard.

FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end


HTH.


-Original Message-
Sent: Tuesday, July 01, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L


Hi listers,

I am working on a nt script. I download FORFILE exe, it works fine. My
intention is finding the ORA-03113 string in the log. If there is a
match, then reboot the server, else do nothing. I don't have problem
with the findstr part. However, the errorlevel always return 0, no
matter it find the error or not. So the if statement is not working. Can
somebody give me some light on NT syntax? On unix, it is so easy to
script the condition. Please help,

Thanks,

Joan


 FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -cCMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113
if errorlevel 1 goto run_proc
echo 'there is a match'

if errorlevel 0 goto end
echo 'there is no match'

:run_proc
d:\start_proc.bat
goto end

:end
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

[Seefelt, Beth]

Yes.  

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND ORA-03313 %x
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF


What this does is list each file in order of oldest to newest.  It does
the FIND on each one, but the errorlevel is only reported for the *last*
one which will be the latest file.

It will not traverse the subdirectories though.

HTH.






-Original Message-
Sent: Tuesday, July 01, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L


Thanks Seefelt,

I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?

Jon



Seefelt, Beth wrote:
 
 Hi,
 
 I think FORFILES is probably overkill here.  And it probably is only
 going to return the errorlevel for the last file checked.  Just use
 FINDSTR with a wildcard.
 
 FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 
 HTH.
 
 -Original Message-
 Sent: Tuesday, July 01, 2003 12:15 PM
 To: Multiple recipients of list ORACLE-L
 
 Hi listers,
 
 I am working on a nt script. I download FORFILE exe, it works fine. My
 intention is finding the ORA-03113 string in the log. If there is a
 match, then reboot the server, else do nothing. I don't have problem
 with the findstr part. However, the errorlevel always return 0, no
 matter it find the error or not. So the if statement is not working.
Can
 somebody give me some light on NT syntax? On unix, it is so easy to
 script the condition. Please help,
 
 Thanks,
 
 Joan
 
  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-cCMD
 /c type d:[EMAIL PROTECTED]|findstr ORA-03113
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Joan Hsieh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Seefelt, Beth
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

[Seefelt, Beth]

Small correction

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND ORA-03313 %~fx
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF



And when you use FOR in a bat file, you have to replace all % with %%


-Original Message-
Sent: Tuesday, July 01, 2003 2:18 PM
To: [EMAIL PROTECTED]



Yes.  

FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND ORA-03313 %x
if errorlevel 1 ( echo 'there is a match'
  d:\start_proc.bat )
goto :EOF


What this does is list each file in order of oldest to newest.  It does
the FIND on each one, but the errorlevel is only reported for the *last*
one which will be the latest file.

It will not traverse the subdirectories though.

HTH.






-Original Message-
Sent: Tuesday, July 01, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L


Thanks Seefelt,

I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?

Jon



Seefelt, Beth wrote:
 
 Hi,
 
 I think FORFILES is probably overkill here.  And it probably is only
 going to return the errorlevel for the last file checked.  Just use
 FINDSTR with a wildcard.
 
 FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 
 HTH.
 
 -Original Message-
 Sent: Tuesday, July 01, 2003 12:15 PM
 To: Multiple recipients of list ORACLE-L
 
 Hi listers,
 
 I am working on a nt script. I download FORFILE exe, it works fine. My
 intention is finding the ORA-03113 string in the log. If there is a
 match, then reboot the server, else do nothing. I don't have problem
 with the findstr part. However, the errorlevel always return 0, no
 matter it find the error or not. So the if statement is not working.
Can
 somebody give me some light on NT syntax? On unix, it is so easy to
 script the condition. Please help,
 
 Thanks,
 
 Joan
 
  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-cCMD
 /c type d:[EMAIL PROTECTED]|findstr ORA-03113
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Joan Hsieh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Seefelt, Beth
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you

RE: nt script

[Seefelt, Beth]

Correct.  FORFILES will not work.  

-Original Message-
Sent: Tuesday, July 01, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L


Hi Seefelt,

with or without match, I added ORA-03113 and deleted it later to test
both case. They all run ERRORLEVERL 1 condition. No matter what.

Joan

CODE:

FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0 -cCMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113 

IF ERRORLEVEL 1 ( echo 'there is no match' ) 
goto :no
IF NOT ERRORLEVEL 1 (echp 'there is a match')
GOTO :RUN_PROC
:run_proc
rem d:\psfm\start_proc_sched.bat
echo run
pause
goto end
:no
echo do nothing

TEST RUN WITHOUT MATCH;

D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -cCMD /c echo @FILE
PSPRCSRV_PSNT_0630.log
PSPRCSRV_PSNT_0701.log

D:\oracle\adminecho on

D:\oracle\adminrem FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -cCMD /c type d:\
[EMAIL PROTECTED]|findstr ORA-03113
D:\oracle\admin\test.log

D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -cCMD /c type d:\pslo
[EMAIL PROTECTED]|findstr ORA-03113

D:\oracle\adminIF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admingoto :no
D:\oracle\adminecho do nothing
do nothing
D:\oracle\admingoto end
D:\oracle\adminecho finished
finished

TEST RUN WITH A MATCH;

D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log  -d+0 -cCMD /c type d:\pslog
[EMAIL PROTECTED]|findstr ORA-03113
ORA-03113

D:\oracle\adminIF ERRORLEVEL 1 (echo 'there is no match'  )
D:\oracle\admingoto :no
D:\oracle\adminecho do nothing
do nothing
D:\oracle\admingoto end
D:\oracle\adminecho finished
finished


Seefelt, Beth wrote:
 
 BTW, it can also be written like this.  Just FYI.
 
 FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
 if errorlevel 1 ( echo 'there is a match'
   d:\start_proc.bat )
 goto :EOF
 
 -Original Message-
 Sent: Tuesday, July 01, 2003 12:35 PM
 To: [EMAIL PROTECTED]
 
 Hi,
 
 I think FORFILES is probably overkill here.  And it probably is only
 going to return the errorlevel for the last file checked.  Just use
 FINDSTR with a wildcard.
 
 FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 
 HTH.
 
 -Original Message-
 Sent: Tuesday, July 01, 2003 12:15 PM
 To: Multiple recipients of list ORACLE-L
 
 Hi listers,
 
 I am working on a nt script. I download FORFILE exe, it works fine. My
 intention is finding the ORA-03113 string in the log. If there is a
 match, then reboot the server, else do nothing. I don't have problem
 with the findstr part. However, the errorlevel always return 0, no
 matter it find the error or not. So the if statement is not working.
Can
 somebody give me some light on NT syntax? On unix, it is so easy to
 script the condition. Please help,
 
 Thanks,
 
 Joan
 
  FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log  -d+0
-cCMD
 /c type d:[EMAIL PROTECTED]|findstr ORA-03113
 if errorlevel 1 goto run_proc
 echo 'there is a match'
 
 if errorlevel 0 goto end
 echo 'there is no match'
 
 :run_proc
 d:\start_proc.bat
 goto end
 
 :end
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Joan Hsieh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Seefelt, Beth
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing

RE: nt script

[Seefelt, Beth]

 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051
http://www.fatcity.com
   San Diego, California-- Mailing list and web
  hosting services
  
 
-
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
   the message BODY, include a line containing: UNSUB ORACLE-L (or
the
   name of mailing list you want to be removed from).  You may
  also send
   the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Joan Hsieh
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
services
 
-
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
  and in the message BODY, include a line containing: UNSUB
  ORACLE-L (or the name of mailing list you want to be removed
  from).  You may also send the HELP command for other
  information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Bob Metelsky
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: nt script

[Seefelt, Beth]

FIND or FINDSTR should work equally well, I think.  Maybe it depends on
your exact platform.

-Original Message-
Sent: Tuesday, July 01, 2003 5:07 PM
To: Multiple recipients of list ORACLE-L


Hi...

I could not follow this thread, so, I do not know the
current status...

anyway... I tested this and it works...

1.- First, I saw that you asked for: string called ORA
and your errorlevel statement failed.

2.- Second, the script sent by: Seefelt, Beth looks
like it works (I did not test it), EXCEPT that you
HAVE to change this line:

 FIND ORA-03313 psprcsrv_psnt_%MMDD%.log

with this one:

 FINDSTR ORA-03313 psprcsrv_psnt_%MMDD%.log

HTH
JL

there you go... (modify at your own needs...)

copy con test.cmd
findstr %1 alert_develop.log
if errorlevel 1 goto no
if errorlevel 0 goto si
:no
   echo no se encontr#8804; la cadena: %1
   goto fin
:si
   echo si se encontr#8804; la cadena: %1
:fin
ctrl-Z

--- Seefelt, Beth [EMAIL PROTECTED]
wrote:
 
 That actually makes it alot easier
 
 FOR /F tokens=1-5 delims=/,  %%i in ('date/t') DO
 SET MMDD=%%j%%k
 if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
 FIND ORA-03313 psprcsrv_psnt_%MMDD%.log
 if errorlevel 1 ( echo 'there is a match'
 d:\start_proc.bat )
 goto :EOF
 
 :no_file
   echo Can't find todays log!
   exit /b 2
 
 
 
 -Original Message-
 Sent: Tuesday, July 01, 2003 3:51 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Bob,
 
 I tested it out, it works on one hard code file. If
 I set thisfile it
 works. But in reality, I need to find today's log,
 the log file name
 convention is always goes psprcsrv_psnt_0701.log
 with the date suffix to
 the end. I can't hard code the file name in the bat
 file. Is there
 anyway how to get around with this?
 
 Thanks,
 
 Joan
 
 Bob Metelsky wrote:
  
  Don't run it line by line
  Save it to a file called myfind.bat
  
  Then call from a command prompt
  
  C:\ myfind.bat
  
  Or click the batch file, be sure to leave the
 pause so you can see an
  error if any. Once its working, you can then
 implemet blat as someone
  suggested
  
  Here is a version using variables
  
 

##
  
  [myfind.bat]
  :: Find example by BMetelsky on 
 Friday-April-11-2003-9:22:53 AM
  :: This script searches thefile for a string and
 if it finds it, sends
  an email message to dbamail
  :: 0 =is found
  echo off
  set themess=A Database SERVICE on %computername%
 is NOT running on
  %date% at %time%
  set [EMAIL PROTECTED]
  set blatfile=D:\dbmon\blattext.txt
  set thefile=D:\dbmon\runit.log
  set subject=A DB SERVICE IS NOT RUNNING
  set [EMAIL PROTECTED]
  echo starting %blatfile%
  
  find ERROR: %thefile% NUL
  
  IF ERRORLEVEL 1 GOTO no
  IF NOT ERRORLEVEL 1 GOTO yes
  :no
  goto end
  
  :yes
  echo A db service is down on
 %computername%%blatfile%
  blat D:\dbmon\blattext.txt -subject %subject%
 -to %dbamail% -i
  %from% -body %themess%
  goto end
  
  :end
  @exit
  rem echo %errorlevel%
  
 

##
  
   Hi Bob, thanks for the reply. I added your code
 and tested
   still no good. I tested the case without a
 match. Still go to run.
  
   Joan
  
   D:\oracle\adminFORFILES
   -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
  -d+0 -cCMD
   /c echo @FILE PSPRCSRV_PSNT_0630.log
 PSPRCSRV_PSNT_0701.log
  
   D:\oracle\adminecho on
  
   D:\oracle\adminFORFILES
   -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
  -d+0 -cCMD
   /c type d:\pslog
 [EMAIL PROTECTED]|findstr ORA-03113
   D:\oracle\admin\test.log
  
   D:\oracle\adminrem FORFILES
   -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
  -d+0 -cCMD
   /c type d:\p
 [EMAIL PROTECTED]|findstr ORA-03113
 NUL
  
   D:\oracle\adminIF ERRORLEVEL 1 GOTO no
  
   D:\oracle\adminIF NOT ERRORLEVEL 1 GOTO
 RUN_PROC
  
   D:\oracle\adminrem d:\psfm\start_proc_sched.bat
  
   D:\oracle\adminecho run
   run
  
   D:\oracle\adminpause
   Press any key to continue . . .
  
   D:\oracle\admingoto end
  
   D:\oracle\adminecho finished
   finished
  
   D:\oracle\adminrem if errorlevel 1
 @d:\psfm\start_proc_sched.bat
  
   Bob Metelsky wrote:
   
echo off
@cls
find ORA-124 C:\yourlog.txt NUL
   
IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes
   
:no
ECHO NOT FOUND
goto end
   
:yes
 ECHO String IS found
pause
goto end
   
:end
exit
   

 Hi listers,

 I am working on a nt script. I download
 FORFILE exe, it
   works fine.
 My intention is finding the ORA-03113 string
 in the log.
   If there is
 a match, then reboot the server, else do
 nothing. I don't have
 problem with the findstr part. However, the
 errorlevel
   always return
 0, no matter it find the error or not. So
 the if statement is
 not
 working. Can somebody give me some light on
 NT syntax? On
   unix, it
 is so easy to script the condition. Please
 help,

 Thanks

RE: Event to show Query Rewrite

[Seefelt, Beth]

Title: Message



Its not an event, 
but maybe this will help.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/qr.htm#39292



-Original Message-From: Arup Nanda 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:05 
PMTo: Multiple recipients of list ORACLE-LSubject: Event 
to show Query Rewrite
Listers,

Does anyone know how to set an event, or some other 
method, to see what query Oracle rewrites for a Materialized View and how it 
arrives at that decision? I am seeing a problem here in my DW database where the 
query "select count(*) from base_table" is rewritten as "select count(*) from 
MV_on_the _base_table", a clearly wrong rewrite of the query.

Oracle 9.2.0.3 on Tru64 Unix.

The base table is (col1 date, col2 varchar2(20), 
col3, col4, col5...) range partitioned on col1 and list subpartitioned on col2. 
the MV is "select col1, col2, count(*) totrows from base group by col1, col2", 
also partitioned in the same manner as the base table. The MV is first as a 
table and then the MV is built with "on prebuilt table" clause.

Query_rewrite_enabled = true and 
query_rewrite_integrity = stale_tolerated.

A query "select count(*) from base" is probably 
rewritten as "select count(*) from MV_base", and of course, the results are 
wrong. Oracle Support asks to provide a test case and I am unable to reproduce 
it. Upon examination, the STALENESS column in user_mviews is "UNKNOWN" for this 
MV; STALE for all others. Oracle Support can't explain what could be the cause 
of this status except that "it happens when an MV is created on a prebuilt 
table".

My only recourse at this time is to identify the 
decision making process Oracle used to arrive at the queryit rewrites to 
and perhaps explain that somehow. Any help will be greatly 
appreciated.

Thanks a lot in advance.

Arup Nanda

RE: oracle authentication from windows

[Seefelt, Beth]

No, that's not true.  It actually uses your NT security token to
validate that you are authenticated in the domain.  You can't just give
a rogue PC the same domain name, boot it up, and log into the database
with external authentication.  The PC would have to be a domain member,
which means you have to have the domain admin password to join the
domain, along with the users password so that you could log into the
domain as them.  The same is not true if you use another prefix such as
OPS$.


-Original Message-
Sent: Friday, June 20, 2003 4:00 PM
To: Multiple recipients of list ORACLE-L


Beth,

You are right in stating that OPS$ accounts are not inherently insecure.

How is teh inclusion of domain name any more secure than using OPS$?
Granted, the hacker has to guess the domain name in addition to user
name, but so is using any other prefix other than OPS$.

Besides if the users are not static, the domain names will be different.
How will you address that issue? For instance, you domina name is
MYCODOMAIN1 and your windows userid is mycodomain1\bseefelt, so the
Oracle userid, as you propose should be mydomain\bseeth. If you login
to another domain, say, MYDOMAIN2, this account is no longer valid. So,
I would say, mixing domains with username may not be a good idea, unless
ofourse you have a single domain.

Arup


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 20, 2003 10:10 AM



 I disagree.  Remote OS authentication is not inherently insecure in 
 Windows like it is in Unix.  If you prefix the account names with the 
 domain name, a user would not only have to spoof the username, he 
 would have to spoof the domain name too.  At that point, you probably 
 have bigger problems than access to your database.  Also, in that 
 situation, only the security token is going over the network, not your

 password in clear text.  The caveat is that you should be using the 
 *domain name* as the prefix, not OPS$.

 -Original Message-
 Sent: Friday, June 20, 2003 6:20 AM
 To: Multiple recipients of list ORACLE-L


 Hi Arup,

 Remote OS authentication whether with OPS$ or not is still a risk. You

 are intimating that SYSTEM is the only risky account involved here. 
 What if any of the newly created OPS$ accounts have useful privileges.

 I have seen a similar application to the one described recently. There

 were forms within the application for administration and user 
 management (in oracle, not the application) and the users who had 
 access to these were assigned the DBA role and were of course external

 accounts.

 I think what you should add to your comment is that the issue is 
 overrated is that any OPS$ / external accounts should not have any 
 dangerous privileges granted and certainly not DBA. If you can guess 
 the name of an admin account even if its OPS$ then the issue is still 
 severe.

 cheers

 Pete

 --
 Pete Finnigan
 email:[EMAIL PROTECTED]
 Web site: http://www.petefinnigan.com - Oracle security audit 
 specialists Book:Oracle security step-by-step Guide - see 
 http://store.sans.org for details.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Pete Finnigan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from).  You may also send 
 the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Seefelt, Beth
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from).  You may also send 
 the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L

RE: oracle authentication from windows

[Seefelt, Beth]

Because external authentication checks the domain name you are logged
into.  You can't log into a local user JKILCHOE and connect to the
externally authenticated database user MYDOMAIN\JKILCHOE.

Beth

-Original Message-
Sent: Friday, June 20, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L


(my question follows)

 -Original Message-
 From: Seefelt, Beth [mailto:[EMAIL PROTECTED]
 
 I disagree.  Remote OS authentication is not inherently insecure in 
 Windows like it is in Unix.  If you prefix the account names with the 
 domain name, a user would not only have to spoof the username, he 
 would have to spoof the domain name too.  At that point, you probably 
 have bigger problems than access to your database.  Also, in that
 situation,
 only the security token is going over the network, not your 
 password in
 clear text.  The caveat is that you should be using the 
 *domain name* as the prefix, not OPS$.


I don't understand how to accomplish this in practice. I currently sign
on to the Windows Network for domain MYDOMAIN with userid JKILCHOE. By
running the query suggested by Mr. Nanda I see that Oracle thinks my
username is jkilchoe:
SQL select sys_context ('userenv', 'os_user') from dual

SYS_CONTEXT('USERENV','OS_USER')
-
jkilchoe

If I set
os_authent_prefix = MYDOMAIN
and create an Oracle username MYDOMAINJKILCHOE

how does that stop someone else from creating a local user JKILCHOE on
their machine, signing on to their local machine as JKILCHOE, and then
using SQL*Net to connect to the database as MYDOMAINJKILCHOE ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: oracle authentication from windows

[Seefelt, Beth]

Hi Pete,

I don't think that's true about booting a PC with the same domain name
that's not really part of the domain.  Have you ever tried it?  I'd be
really interested if it works.

I don't understand the part about booting into Linux and changing the
username as its sent.  Isn't the only username passed / ?  Or are you
talking about poking things at the packet level to make sqlnet think the
user is domain authenticated.

Cheers,

Beth

-Original Message-
Sent: Friday, June 20, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L


Hi Beth

OK, I get your point but Arup was talking about automatic connections by
setting remote_os_authent to true where you can either set the prefix to
OPS$ or use identified externally. For these connections the user should
not be prefixed by the domain name in the database. On the other hand
using windows NT authentication and prefixing with the domain name can
be spoofed by using a client that is not trusted such as windows 95 or
98 and setting the context to any domain you wish and adding the correct
user. The other option is to insert a linux bootable CD and alter the
username as it is sent.

I agree with you that use of the domain method is better, BUT the point
i was trying to make is still valid. That is to ensure that any external
account observes the least privilege principle.

cheers

Pete



In article [EMAIL PROTECTED], Seefelt, Beth
[EMAIL PROTECTED] writes

I disagree.  Remote OS authentication is not inherently insecure in 
Windows like it is in Unix.  If you prefix the account names with the 
domain name, a user would not only have to spoof the username, he would

have to spoof the domain name too.  At that point, you probably have 
bigger problems than access to your database.  Also, in that situation,

only the security token is going over the network, not your password in

clear text.  The caveat is that you should be using the *domain name* 
as the prefix, not OPS$.

-Original Message-
Sent: Friday, June 20, 2003 6:20 AM
To: Multiple recipients of list ORACLE-L


Hi Arup,

Remote OS authentication whether with OPS$ or not is still a risk. You 
are intimating that SYSTEM is the only risky account involved here. 
What if any of the newly created OPS$ accounts have useful privileges. 
I have seen a similar application to the one described recently. There 
were forms within the application for administration and user 
management (in oracle, not the application) and the users who had 
access to these were assigned the DBA role and were of course external 
accounts.

I think what you should add to your comment is that the issue is 
overrated is that any OPS$ / external accounts should not have any 
dangerous privileges granted and certainly not DBA. If you can guess 
the name of an admin account even if its OPS$ then the issue is still 
severe.

cheers

Pete

--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the

message BODY, include a line containing: UNSUB ORACLE-L (or the name of

mailing list you want to be removed from).  You may also send the HELP 
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
specialists Book:Oracle security step-by-step Guide - see
http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from

RE: oracle authentication from windows

[Seefelt, Beth]

I disagree.  Remote OS authentication is not inherently insecure in
Windows like it is in Unix.  If you prefix the account names with the
domain name, a user would not only have to spoof the username, he would
have to spoof the domain name too.  At that point, you probably have
bigger problems than access to your database.  Also, in that situation,
only the security token is going over the network, not your password in
clear text.  The caveat is that you should be using the *domain name* as
the prefix, not OPS$.

-Original Message-
Sent: Friday, June 20, 2003 6:20 AM
To: Multiple recipients of list ORACLE-L


Hi Arup,

Remote OS authentication whether with OPS$ or not is still a risk. You
are intimating that SYSTEM is the only risky account involved here. What
if any of the newly created OPS$ accounts have useful privileges. I have
seen a similar application to the one described recently. There were
forms within the application for administration and user management (in
oracle, not the application) and the users who had access to these were
assigned the DBA role and were of course external accounts. 

I think what you should add to your comment is that the issue is
overrated is that any OPS$ / external accounts should not have any
dangerous privileges granted and certainly not DBA. If you can guess the
name of an admin account even if its OPS$ then the issue is still
severe.

cheers

Pete

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: INDEX REBUILD

[Seefelt, Beth]

8i which release?  It was broken in 8.1.6 and before, but fixed in
8.1.7.


-Original Message-
Sent: Thursday, June 19, 2003 2:01 PM
To: Multiple recipients of list ORACLE-L


Anup
this view will not help in 8i.
thanks anyway!


From: Arup Nanda [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: INDEX REBUILD
Date: Thu, 19 Jun 2003 08:20:06 -0800

Seema,

Select last_ddl_time and timestamp from user_objects where the
object_name 
=
'index'

HTH

Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:29 AM


  Hi,
 
  Is any view available which can tell us indexe rebuild status in 8i?
  Means how can we know these are indexes rebuilded recently?
  thx
  -Seema
 
  _
  The new MSN 8: smart spam protection and 2 months FREE*
  http://join.msn.com/?page=features/junkmail
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Seema Singh
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
services
 
-
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
   INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Performance improvement required :-)

[Seefelt, Beth]

Why can't you use bind variables?  I thought using .Parameters method
(property?) of ADODB.Command would use bind variables.

What function, and where can't you use it?


-Original Message-
Sent: Friday, June 13, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L


It's Friday, and I'm having a brain storm. Just to check:
The developers are using ADO to connect to a VB application and want to
pull back a record set. Using ADO means they can't use bind variables.
Returning more than 1 record means they can't use a function (which
WOULD use bind variables). Am I correct in saying that other than tuning
the SQL (done that, it isn't a complex query) or playing around with
Oracle session parameters, there isn't anything else I can do?
(The query takes 1 second the first time it is run, but 10 ms after. It
is used all the time in the callcentre to search postcodes.)

TIA

Craig Healey



**

This email and any files transmitted with it are confidential and
intended solely
for the use of the individual or entity to whom they are addressed and
may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination
or other use of, or taking of any action in reliance upon, this
information by 
persons or entities other than the intended recipient is prohibited.
Statements
and opinions expressed in this e-mail may not represent those of the
company.
  
If you have received this email in error please notify
[EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)


***

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Healey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Performance improvement required :-)

[Seefelt, Beth]

I'm sure you can.  You should see it in an ODBC trace log, or you can
use trace events on the database.  Here's a really simplistic test I did
to verify it.  I ran this VB code that executes a really dumb query that
could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE
DUMMY = 'X'  but passed 'X' as a bind variable

Private Sub Form_Load()

Dim conn1 As New ADODB.Connection
Dim cmd1 As New ADODB.Command
Dim rs1 As New ADODB.Recordset
Dim STRSQLSTRING As String
Dim param1 As New Parameter

strConnect = UID=produser;PWD=prodpass;DSN=WAREHOUSE;
STRSQLSTRING = SELECT DUMMY FROM DUAL WHERE DUMMY = ?

With conn1
.ConnectionTimeout = 0
.CommandTimeout = 0
.CursorLocation = adUseClient
.Mode = adModeRead
.Open strConnect
End With
If Err.Number Then
  MsgBox Err.Number
  Exit Sub
End If
With cmd1
.ActiveConnection = conn1
.CommandText = STRSQLSTRING
.CommandType = adCmdText
Set param1 = .CreateParameter(DummyValue, adChar,
adParamInput, 1, X)
param1.Value = X
.Parameters.Append param1
Set rs1 = .Execute
End With

MsgBox rs1.Fields(DUMMY)

End Sub


Afterward, executed this on the database -


SQL select sql_text from v$sqlarea where sql_text like 'SELECT DUMMY
%';

SQL_TEXT



SELECT DUMMY FROM DUAL WHERE DUMMY = :1


It shows the parameter was definitely passed as a bind variable.


Check out this document on Metalink -
Retrieving Record Set from Stored Proc Using ADO and VB (SCR 782)

It appears to have an example of passing a cursor back to a recordset,
though I've never tried it.


HTH.

Beth


-Original Message-
Sent: Friday, June 13, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


 
 
 Why can't you use bind variables?  I thought using .Parameters method
 (property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?

 
 What function, and where can't you use it?
 
Stored Procedure type function (i.e. user-written) called from VB. 'Cos
it's a Stored Procedure it will use bind variables, but you can't return
a result set to VB.

Craig


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Fragmentation ?

[Seefelt, Beth]

I think those guys work here now  :-)

-Original Message-
Sent: Friday, June 13, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L



That's one thing good about the databases here.  Tablespace
fragmentation is
rarely a problem.  Most of the database here are a Database Roach Motel:
Data checks in.  It doesn't check out.  Somehow, the data purge part
of
the application -- that they intended to put in one of these days --
never
got written.



(For non-USA dwellers, Roach Motel is a trap for roaches.  It has a
sticky
floor, and the sales motto is Roaches check in. They don't check out.)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: anyone have any soundex scripts?

[Seefelt, Beth]

There is a SOUNDEX sql function.  Check tahiti.oracle.com for info.

HTH.

-Original Message-
Sent: Monday, June 09, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L


I was on a project a few years ago where we used a soundex algorithm to
determine and eliminte duplicate data.

For example we would have:

301 Fairfield Lane
301 Faerfield Lane

Notice the typo? The soundex algorithm caught it. Unfortunately I forgot
to grab a copy before I left. Everytime I do a google search on soundex
I get a theory website explaining the math behind it. 

anyone have one written? or know where I can find one? It is incredibly
useful. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: anyone have any soundex scripts?

[Seefelt, Beth]

What advanced functionality are you looking for?

-Original Message-
Sent: Monday, June 09, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L


yes, Im familiar with that function. but you have to write a soundex
algorithm in order to get advanced functionality. I wouldnt even know
where to start with something like that. 

Im hoping there is one on the web some where. 
 
 From: Seefelt, Beth [EMAIL PROTECTED]
 Date: 2003/06/09 Mon AM 09:59:43 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: anyone have any soundex scripts?
 
 
 There is a SOUNDEX sql function.  Check tahiti.oracle.com for info.
 
 HTH.
 
 -Original Message-
 Sent: Monday, June 09, 2003 8:49 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I was on a project a few years ago where we used a soundex algorithm
to
 determine and eliminte duplicate data.
 
 For example we would have:
 
 301 Fairfield Lane
 301 Faerfield Lane
 
 Notice the typo? The soundex algorithm caught it. Unfortunately I
forgot
 to grab a copy before I left. Everytime I do a google search on
soundex
 I get a theory website explaining the math behind it. 
 
 anyone have one written? or know where I can find one? It is
incredibly
 useful. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Seefelt, Beth
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: International User Community

[Seefelt, Beth]

Title: Message



Were'nt US companies 
forbidden to do business with Iraq in 98-99?



-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:10 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
International User Community
When I worked for Oracle back in 1998-99 
Oracle had an office in the capitol of Iraq as I recall.

Ken Janusz, CPIM

  - Original Message - 
  From: 
  Richard 
  Ji 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 09, 2003 12:50 
PM
  Subject: RE: International User 
  Community
  
  I 
  thought Iran registered it first.
  
-Original Message-From: Gogala, Mladen 
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:35 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
International User Community
IOUG? Is that an "Iraqi Oracle User Group"? Boy, 
thing are developing fast!

Mladen Gogala Oracle DBA Phone:(203) 
459-6855 Email:[EMAIL PROTECTED] 


  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  International User Community
  While not trying to sound like this is coming off like a 
  shameless plug, because it isn't... I have an Apps 
  book going to publisher in a couple weeks and they want to do PR. To 
  that end, they have asked me to fill out a fairly extensive paper on who 
  might ever care about such a book... including International Organizations 
  they might push out PR stuff to.
  Thanks to Rachel, I got a list of IOUG OAUG UKOUG EOUG APOUG and ODTUG 
  Anyone know any others? This wasn't exaclty the kind 
  of reasearch I was planning on... =) . 
  Thanks in advance for any help and... sorry Jared for the 
  questionable content. 
  April 
  


  The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Shite of the day

[Seefelt, Beth]

What asked for 9.0.2?  Are you sure you didn't misread 9.2.0 ?

You said you set COMPATIBLE to 9.0.2 and then started getting these
errors -
 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0

Sounds like maybe you ran a migrate or downgrade script with an invalid
COMPATIBLE parameter and that's what hosed it.


-Original Message-
Sent: Thursday, June 05, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L


Yes.  But why is it asking for 9.0.2?  I set it to 9.2, 8.1.7, and 9.0.2
just to give it a try.
-Original Message-
Sent: Wednesday, June 04, 2003 7:30 PM
To: Multiple recipients of list ORACLE-L


I guess this is a silly question, but could it be that Oracle didn't
like the COMPATIBLE = 9.0.2 since there is no 9.0.2?
I don't know how the comparison is done, but if it's a string comparison
I wonder if there will be any bugs with the COMPATIBLE check when
version 10 comes out.
 -Original Message- 
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED] 
 
 No.  I guess by manual I mean I didn't use the gui. I ran the 
 appropriate upgrade script. 
 
 Gosh I hope it doesn't come to exp/imp... I can't even export 
 my database. 
 
 -Original Message- 
 
 Lisa, when you say you manually migrated, did you use 
 exp/imp after a 
 fresh CREATE DATABASE in 9i?  Also, what platform?  32-bit? 
 
 Rich Jesse   System/Database Administrator 
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA 
 
 
  -Original Message- 
  Lisa 
  
  Worry free?  I just upgraded another 8.1.7.4 database to 
 9.2.  When I 
  set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make 
  sense) I get 
  really messy errors: 
  
  ORA-00402: database changes by release 9.0.1.3.0 cannot be used by 
  release 135294976 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Service on Win2k

[Seefelt, Beth]

Hi,

Either -

1) ORADIM -EDIT -SID SID -STARTMODE MANUAL

or -

2) regedit.  Change HKLM\Software\Oracle\HomeX\ORA_SID_AUTOSTART.
Change the value to FALSE.

HTH.

-Original Message-
Sent: Friday, June 06, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


Hi list

On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the
service
OracleServiceSID, most of the times, the database will also be mounted
and
opened !
Doesn't matter wether I start the service via gui or via net start
OracleServiceSID or oradim  -STARTUP -SID SID -USRPWD PWD
-STARTTYPE
srvc, the database will be opened right away.
I definitely don't want that. That sh%%($t can sc%$/w up my instance.
Does
anybody encounter the same problems ? Couldn't find anything relevant on
metaling, though.

Help,
Stefan



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Seefelt, Beth]

I think that was exactly their strategy when they aquired RDB, but I
think Oracle underestimated how much RDB customers would resist losing
RDB.  You can't tick off customers of that magnitude who are willing to
spend big $$$ for the reliability and performance of RDB, which is tough
to match.  I think Oracle's done a decent job of continuing to develop
RDB.  Its even picked up a few nice features from Oracle RDBMS like role
based secutiry and logminer.  It definitely has given more than it got
though - partitioning, parallel query ...

-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





Mark Leith [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput  performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Off-Topic (InstallShield Installation Problem)

[Seefelt, Beth]

Hi,

Anything in the event log?

HTH.

-Original Message-
Sent: Thursday, June 05, 2003 6:10 AM
To: Multiple recipients of list ORACLE-L


Hello list,

I have installed InstallShield(comes along with Delphi) in my PC.
When i run it, it gives me the message : Installshield for Windows
Installer is unable to start. Ensure that the Windows Installer engine
has been installed properly.

but when i go to control panel/services/and try to start windows
installer, it gives me the message : Could not start windows installer
service on \\vsantosh. 

Any solutions will be highly appreciated.

Thanks and regards,
Santosh


 



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MS Access 97 to Oracle 8.1.7 Scheduler

[Seefelt, Beth]

Hi Bob,

I don't know if its possible to do it by those means, but it is
definitely possible, using heterogeneous services to have Oracle pull
the data from Access over a database link.  You could schedule that
through the Oracle scheduler, or have MS scheduler execute a sql script.

HTH.

Beth

-Original Message-
Sent: Thursday, June 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Gurus,

We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package. 

Please share your experience in this regard and let me
know what could be the best method to automate loading
data from MS Access 97 to Oracle 8.1.7.

Thank,
Bob

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: next week

[Seefelt, Beth]

oops... let's hope she's not a member of this list...

-Original Message-
Sent: Monday, June 02, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


Stephane,

Are we still on for dinner on the 10th? Have you contacted Sean? I
think the group is trying to organize a dinner for the speakers, but
knowing the person who is doing the organizing... it's not going to
happen. she's one of the more incompetent members of the board.

In any case... what time would you like to meet and where? I'm looking
forward to seeing you again.

Rachel



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: unusable indexes.

[Seefelt, Beth]

I think the problem is skip_unusable... isn't an init.ora parameter.  At
least it wasn't in earlier versions.  You can set it at session level
'alter session set skip_unusable_indexes...'.  I ended up adding it to a
logon trigger to make it affect all sessions.

HTH.


-Original Message-
Sent: Thursday, May 29, 2003 8:20 PM
To: Multiple recipients of list ORACLE-L


hi
i am trying to figure out how unusable indexes could
help me in certain cases like bulk loading etc. i am
trying to understand how it works.

i created a table with a index and used a query which
used this index.

later i made this index unusable and unless and until 
i make this index non-existent the query always
returns a 1502 error trying to access the table thru
the unusable index when i can see that full table scan
is still an option. the init.ora parameter
skip_unusable..is set up too.

version is 9.2.0.3 on aix 5l.

can someone clarify whether this is how it is supposed
to work or am i missing something .

thanks
sai
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sai Selvaganesan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unbreakable, my buns. Upgrade to 9.2/w2k

[Seefelt, Beth]

Title: Message



I upgaded 2 
productionservers. One running 9 instances, one running 3. 
Both are serving data warehouses. Had no problem.



-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 
2003 12:25 PMTo: Multiple recipients of list 
ORACLE-LSubject: Unbreakable, my buns. Upgrade to 
9.2/w2k
For those of you who have upgraded to 9.2 on 
w2k: 
How many of you have ended up with such a hosed 
server that you had to completely wipe Oracle off of it and start with a fresh 
install (9.2)? It was spectacular! I ended up in this situation and 
I sure hope it's something I did or didn't do. I sure don't have time for 
this when I upgrade my production databases. How I long for those days 
wading through problems in unix... it was so much easier and more 
enjoyable... I will say this was definately a learning experience. 

And Tom Mercadante, your document worked like a 
charm, and saved my a$$... Muchas Gracias! 
Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut 
Creek Parkway Ft. Lauderdale, FL, USA 
33063 Office: 954-935-4117 
Fax: 954-935-3639 
Cell: 954-683-4459 -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, 
Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 
858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and 
web hosting services 
- To REMOVE 
yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] 
(note EXACT spelling of 'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed 
from). You may also send the HELP command for other information (like 
subscribing). 

RE: OEM can't seem to discover 1 instance

[Seefelt, Beth]

-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM can't seem to discover 1 instance

[Seefelt, Beth]

I agree with Jay.  Everytime I use OEM there are 10 or 20 annoying
little things that make it incredibly frustrating to use.  

Jared mentioned a while back that the new product manager for OEM is on
this list.  Maybe he could set up something (like a *big* mailbox) to
take suggestions for changes.

I would love to bag it completely but we're stuck with it because of the
integration with OWB, for a little while longer anyway.


-Original Message-
Sent: Friday, October 18, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L


Scrap OEM.  Seriously, we ran into way too many of these little annoying
problems.  We decided that we had better things to do with our time.
Have you had to re-register all of your jobs, yet?  That one was a real
pain.

Jay

 [EMAIL PROTECTED] 10/18/02 09:38AM 
Hmm, thanks to all who are replying.  It looks like the instance is not
making
it into either snmp_rw.ora, snmp_ro.ora or the services.ora.  I have
manually 
edited them, but when I restart the agent, it wipes out the manual
entries
in
the snmp_ro.ora and the services.ora.

The oratab and listener look fine.

Any more good advice?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for
the use of the individual or entity to which they are addressed and may
contain information that is privileged, proprietary and confidential. If
you are not the intended recipient, you may not use, copy or disclose to
anyone the message or any information contained in the message. If you
have received this communication in error, please notify the sender and
delete this e-mail message. The contents do not represent the opinion of
DE except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: CA's AutoSys

[Seefelt, Beth]

We use CA-Workload which I think is the same product packaged
differently.  We schedule about 400 jobs each night through it.  The
jobs run on NT, VMS, Oracle, and Oracle Express with interdependencies
between jobs on different platforms.  I have to say it works pretty
well, but only after about a year of really banging at it to get it just
right.

It will do what they say it will, but takes a fair amount of (human)
resources to get there if your jobstream is large and complex.

And dealing with CA is no picnic either...

-Original Message-
Sent: Friday, October 18, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L


To All,

I'll admit this is somewhat off-topic, but since the project is
going to
handle all scheduled batch jobs that bang on our PeopleSoft Oracle
database, I
figured I'd ask if anyone has an opinion preferably from experience
using the
product.  The Complete A^^holes are here today to do a demo install so
any input
you all have would be appreciated.

Thanks in advance

Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem installing Oracle 8.1.7 on Windows 2000

[Seefelt, Beth]

Are you installing from the console?  Trying to install from a terminal
server session can give those kinds of problems on 2000.

HTH,

Beth

-Original Message-
Sent: Wednesday, October 16, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L


Hi,
I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I
get to
the Net8 Configuration assistant, process jrew.exe goes to 100% of the
CPU.
I have let it run for over 15 minutes before stopping it from the Oracle
installer. The process stops using the CPU but the Oracle installer
hangs. I
have to cancel the installer. If I try to create a database, I get a TNS
adapter error. I have installed 8.1.7 on Windows NT without a problem. I
have opened a TAR. Anyone experience this problem?
Any help will be greatly appreciated.
Thanks.
Larry Noble
DBA
Medrad Inc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Noble, Larry H.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OS authentication

[Seefelt, Beth]

I usually don't bother to set os_authent_prefix.  Its not necessary.  Instead make 
sure OSAUTH_PREFIX_DOMAIN is set to TRUE and prefix the user with the domain name.

  create user DOMAIN-NAME\USERNAME identified externally.

That way the user has to actually authenticate to the domain to be given access.  
Otherwise its fairly easy to spoof that username and gain access to the database.

You'll have to set SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora on the clients.

HTH,

Beth

-Original Message-
Sent: Tuesday, October 15, 2002 9:43 PM
To: Multiple recipients of list ORACLE-L


I want to use OS authentication.  On the server side (Windows2000), does the
user need to be created as OPS$USERNAME or just USERNAME?   For
authentication, do they need to be added to any other group besides User?  Is
there anything else that needs to be done for authentication to work?

In the init, I have os_authent_prefix = OPS$.
I created the user as Create OPS$USERNAME identified externally;

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric Richmon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ALTER TABLE MOVE command causes table to grow

[Seefelt, Beth]

 yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Can't create simple MV with FAST refresh

[Seefelt, Beth]

Maybe the IN clause is throwing it?

Try it with -

where trans_type = 'A' or trans_type = 'B'

Just a WAG...

Beth

-Original Message-
Sent: Monday, September 09, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Using 8.1.7.4.0 on HP/UX with COMPATIBILE set to 8.1.7, I'm not able
to
create the following simple MV:

CREATE MATERIALIZED VIEW qt_gl_trans_ab_mv
TABLESPACE qt_mat_view
BUILD IMMEDIATE
USING INDEX TABLESPACE qt_mat_view PCTFREE 15 INITRANS 2  
REFRESH FAST WITH ROWID
USING LOCAL ROLLBACK SEGMENT rbsbig  
START WITH SYSDATE 
NEXT (TRUNC(SYSDATE+1) + 4/24) 
AS
select fiscal_year, fiscal_period, account_no,
trans_type, trans_amount
from my_general_ledge
where trans_type in ('A','B')

It errors with ORA-12015 cannot create a fast refresh snapshot from a
complex query.  According to MetaLink doc 179466.1, a complex query in
a MV
on 8.1.7 is one that has at least one of:

- a distinct or unique keyword
- an aggregate function (e.g. avg, count, max, min, sum, )
- a connect by clause
- a group by or order by clause
- a set operator (UNION, UNION ALL, INTERSECT and MINUS)
- joins other than those in a subquery

But my query has none of those?  Thinking somethings hosed or I'm
completely
misunderstanding the IN operator of the WHERE clause, I tried where
trans_type = 'A', but with the same results.

Also, I've created the MV log for the fast refresh:

CREATE MATERIALIZED VIEW LOG ON my_general_ledger
WITH  ROWID

I'm just testing out MVs here, but I'm missing something real simple
and/or
stupid here, but for the life of me I can't see what (even after a lunch
break).

Anyone?

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Any woraround for this ....?

[Seefelt, Beth]

Title: Message




What 
is the line of code at line 119?

Beth

  
  -Original Message-From: Muthaiah, VSNL 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:58 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Any woraround for this ?
  Thanks. I did as you said but now with the 
  following error. It writes for the first table and then this error crops. 
  
  
  SQL exec extractBEGIN extract; 
  END;
  
  *ERROR at line 1:ORA-20001: 1User-Defined 
  ExceptionORA-06512: at "SCOTT.EXTRACT", line 119ORA-06512: at line 
  1
  
  Am i missing some thing?
  
  Rgds,
  
  Muths
  
- Original Message - 
From: 
    Seefelt, Beth 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, September 04, 2002 
7:18 PM
Subject: RE: Any woraround for this 
?


Remove all the dbms_output calls and use utl_file. It should 
get around this error, and its not possible to get the below error with 
utl_file so you must have missed something when you tried it the first 
time.

HTH,
Beth

  
  -Original Message-From: Muthaiah, 
  VSNL [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 04, 2002 6:48 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Any woraround for 
  this ?
  Hi,
  
  I'm writing a procedure/script for extract 
  the data of all the tables in a schema. When I am trying to spool/write 
  into a file, I am getting the following error. 
  
  ORA-20001: -2ORA-2: ORU-10028: line 
  length overflow, limit of 255 bytes per lineORA-06512: at 
  "SCOTT.EXTRACT", line 115ORA-06512: at line 1
  First I tried to spool to a file.But got the 
  error line length overflow. I have tried 
  using the UTL_FILE option also. But getting the same error. Can anyone in 
  the list has any work around for this?
  
  Thanks in Advance,
  
  
  Muths
  
  

RE:

[Seefelt, Beth]

Title: Message




Can 
you specify a logfile or errorfile with srw.run_report? Maybe its running 
and failing without reporting an error back to you. You can put an 
srw.message call right before the srw.run_report to see if its ever actually 
getting to that code.

HTH,
Beth

  
  -Original Message-From: sultan 
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 8:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  
  Hi friends
  
  I am using following command to call report from 
  report 
  
  srw.run_report ('report=d:\test.rdf destype=file desname=try.out 
  desformat=dflt batch=yes'); 
  
  I have tested this using After Report /Before Report/Action 
Trigger.
  But this is not calling the report.
  
  Any solution will be appreciated.
  
  Syed
  

RE: Any woraround for this ....?

[Seefelt, Beth]

Title: Message




Remove 
all the dbms_output calls and use utl_file. It should get around this 
error, and its not possible to get the below error with utl_file so you must 
have missed something when you tried it the first time.

HTH,
Beth

  
  -Original Message-From: Muthaiah, VSNL 
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 6:48 
  AMTo: Multiple recipients of list ORACLE-LSubject: Any 
  woraround for this ?
  Hi,
  
  I'm writing a procedure/script for extract the 
  data of all the tables in a schema. When I am trying to spool/write into a 
  file, I am getting the following error. 
  
  ORA-20001: -2ORA-2: ORU-10028: line 
  length overflow, limit of 255 bytes per lineORA-06512: at "SCOTT.EXTRACT", 
  line 115ORA-06512: at line 1
  First I tried to spool to a file.But got the 
  error line length overflow. I have tried using 
  the UTL_FILE option also. But getting the same error. Can anyone in the list 
  has any work around for this?
  
  Thanks in Advance,
  
  
  Muths
  
  

RE: MS Access from Oracle

[Seefelt, Beth]

Search on Metalink for 'Heterogenous Services'.  The documents there
describe how to setup a dblink to an MS Access database.

HTH,

Beth

-Original Message-
Sent: Tuesday, September 03, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L


Can someone tell me where to start to find out how to access an MS
Access
table from Oracle.  Basically what I want to do is be connected to an
Oracle
database in SQL*Plus and execute a query against an MS-Access table.  Is
this possible?

Thanks,
Jeff
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eberhard, Jeff
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Pls respond...: URGENT

[Seefelt, Beth]

What kind of reorgs did you do?

-Original Message-
Sent: Tuesday, September 03, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


My one of disk showing full active...very hot!!! by bground processes 
accessing...
hdisk51 88.7 926.6 139.3   2780 8

hdisk51 85.5 1217.0 176.2   3660 0

hdisk51 91.8 980.2 149.3   2948

From: Peter R [EMAIL PROTECTED]
To: LazyDBA.com Discussion [EMAIL PROTECTED]
Subject: Pls respond...: URGENT
Date: Tue, 03 Sep 2002 19:32:14 +



Hi Friends,

My all background processors accessing same file system, I did some
reorg 
this weekend, But I shut down database like 4 times...all processors
are 
waitingAny help will be highly appreicated!!!


oracle@baan1 $ ps -ef|grep 14816
  oracle 14816 1   2 13:59:00  -  0:49 ora_dbwr_baanIV
  oracle 80572 18974   2 14:27:27  pts/1  0:00 grep 14816
oracle@baan1 $ ps -ef|grep 15336
  oracle 15336 1   0 13:59:00  -  0:12 ora_lgwr_baanIV
  oracle 83158 18974   2 14:27:55  pts/1  0:00 grep 15336
oracle@baan1 $ ps -ef|grep 17644
  oracle 17644 1   0 13:59:00  -  0:16 ora_smon_baanIV
  oracle 85890 18974   2 14:28:21  pts/1  0:00 grep 17644
oracle@baan1 $ ps -ef|grep 18164
  oracle 18164 1   0 13:59:00  -  0:03 ora_db01_baanIV
  oracle 84380 18974   1 14:28:44  pts/1  0:00 grep 18164

Thanks
peter.

_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com



Oracle documentation is here: 
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to
[EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these 
terms:http://www.lazydba.com/legal.html




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com



Oracle documentation is here: 
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these 
terms:http://www.lazydba.com/legal.html




_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter R
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Function-Based Index not working

[Seefelt, Beth]

Hi,

Try 
running the query with a hint that forces the index. If it still doesn't 
use the index, then you missed one of the steps needed to enable function-based 
indexes. If it does use the index, then you've done everything right, but 
the optimizer is deciding the fts is a better option.

HTH,

Beth


-Original Message-From: Marul Mehta 
[mailto:[EMAIL PROTECTED]]Sent: Saturday, August 31, 2002 4:48 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Function-Based Index not working
Hi,

Can you please help me out in solving this weird 
problem of funcation-based index not being used when I query the 
table.
This is the comand I fired and the result it 
returned me.

1. SQL create table employees (last_name 
varchar2(20));
 Table created.

2. SQL CREATE INDEX upper_ix ON employees 
(UPPER(last_name));
 Index created.

Made the autotrace on and than:-

3. SELECT last_nameFROM employees WHERE 
UPPER(last_name) IS NOT NULL ORDER BY UPPER(last_name);
 no rows selected.

Execution 
Plan-- 
0 SELECT STATEMENT 
Optimizer=CHOOSE 1 0 SORT (ORDER 
BY) 2 1 TABLE ACCESS 
(FULL) OF 'EMPLOYEES'


I fired without order by clause also but no 
use.

Now can any body please let tell me why this Oracle 
is having a full scan of the employee table.

TIA,
Marul.

 

RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?

[Seefelt, Beth]

 FALSE
query_rewrite_integrity   enforced
rdbms_server_dn
read_only_open_delayedFALSE
recovery_parallelism  0
remote_dependencies_mode  TIMESTAMP
remote_login_passwordfile NONE
remote_os_authent FALSE
remote_os_roles   FALSE
replication_dependency_tracking   TRUE
resource_limitFALSE
resource_manager_plan
rollback_segments r01, r02, r03, r04
row_locking   ALWAYS
serializable  FALSE
serial_reuse  DISABLE
service_names sqcedi
session_cached_cursors0
session_max_open_files10
sessions  87
shadow_core_dump  partial
shared_memory_address 0
shared_pool_reserved_size 160
shared_pool_size  3200
sort_area_retained_size   80
sort_area_size80
sort_multiblock_read_count2
sql_trace FALSE
sql_version   NATIVE
sql92_securityFALSE
standby_archive_dest  ?/dbs/arch
star_transformation_enabled   FALSE
tape_asynch_ioTRUE
text_enable   FALSE
thread0
timed_os_statistics   0
timed_statistics  FALSE
tracefile_identifier
transaction_auditing  TRUE
transactions  95
transactions_per_rollback_segment 5
use_indirect_data_buffers FALSE
user_dump_dest/sscedre/data/sqcedi/admin/log
utl_file_dir
/var/spool/applmgr/sqcedi/common/log
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: LIST ADMIN: VIRUS Warning: Please Repsond

[Seefelt, Beth]

 Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: kkennedy
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Seefelt, Beth
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

 === message truncated ===


 __
 Do You Yahoo!?
 Yahoo! Finance - Get real-time stock quotes
 http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: working with datafile 2Gb in HadHat 7.3

[Seefelt, Beth]

Ltiu,

Intel hardware can only handle 2Gb files sizes max.

Are you sure?  I don't think that's true.



-Original Message-
Sent: Thursday, August 29, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L


It doesn't really matter what OS you have. Intel hardware can only 
handle 2Gb files sizes max. Even if the hardware can support large 
files, it is still recommended that you do not have large datafiles. You

need to partition your tablespaces into multiple datafiles. This 
facilitates backups and restores and you can put  the datafiles into 
different hard drives increasing i/o performance.

ltiu

Adriano Freire wrote:

Ok ltiu,
REDHAT 7.3 kernel-2.4.18-10 

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 1:18 PM


  

What's HadHat 7.3?

A new Linux distro pattered after RedHat 7.3?

ltiu

Adriano Freire wrote:



Gurus,
 
I've some problems with datafiles  2Gb in HadHat 7.3. I'm using 
datafile type ext3 and
when i try create a datafile with 2Gb the database is catching.
Anybody have the some problem?
any suggestion?
 
Thanks
 
Adriano.
  



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




  




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: LIST ADMIN: VIRUS Warning: Please Repsond

[Seefelt, Beth]

So basically you're saying that those of us using Microsoft products are
doing so because we're stupid or lazy to change?

-Original Message-
Sent: Thursday, August 29, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L


You always have a choice.  Sometimes it is difficult to make the right
choice.  Consider a high school student who is doing poorly -- they can
make the easy choice and drop out or they can make the difficult choice
and work harder.  In the case of M$, the easy choice is to accept
whatever M$ does and produces.  The difficult choice is to find a viable
alternative (and even more difficult is to sell that to management).  In
the past, M$ bought out or crushed any viable alternative; they have
been finding that more difficult lately.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Thursday, August 29, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


Gee, that's a helpful reply!  As if we have any choice!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 29, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L


Stop using MS products if you are seriously worried about viruses.

[EMAIL PROTECTED] wrote:

Got trigger happy, so I'm resending.

-Original Message-
Sent: Thursday, August 29, 2002 10:11 AM
To: DBA List (E-mail); Fat Dba (E-mail)


Hi,

   I recieved an email today as follows:

Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL
[EMAIL PROTECTED]@SUNGARD
Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL
[EMAIL PROTECTED]@SUNGARD

Recipient of the infected attachment:  Kelly Grigg\Inbox
Subject of the message:  Happy humour Epiphany
One or more attachments were deleted
Attachment URL.pif was Deleted for the following reasons:
Virus W32.Klez.E@mm was found.


Here is the repsonse from my guys:

It's sending out from other domains rather sungard.com, eg.
diamonddata.com
and lazydba.com to you.  I attached the description from your first
email.
It is stating that it's being blocked when it's trying to send to you,
in
which means it's infected on their end and are being scanned/blocked on
it's
way out from their systems.  Have you contact them about the possible of
virus attach on their end. In any case, we were alarmed and run the scan
anyway. See what they can find.



  




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP

Read application variable from Oracle Report

[Seefelt, Beth]

Hi everyone,

We have a few Oracle Reports that we need to create so that they take a
different code path depending on which web site its running under.  I'd
prefer to not have several copies of the same report with just minor
changes so I'm looking for a way that the report can identify its
environment.  

I don't think reading an environment variable will do it since all will
be running wit the context of the IUSR account.

Does anyone know if there's a way to get an Oracle Report to read an IIS
application or session level variable?  Then I could just set a flag in
each sites global.asa which I think would work well.

Anyone have any other ideas to make this work?

Thanks,

Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: List of all zip codes,city,state to load into table.

[Seefelt, Beth]

Hi Rick,

There are alot of services out there that will sell you a database, with

periodic updates.  Here's one -

www.zipinfo.com

Beth

-Original Message-
Sent: Wednesday, August 21, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Where can I get a list of all zip codes,city,states to load into a
table. I
have searched but cannot find anything to download.
Anyone have a URL that I can get this info.

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: drop tablespace including contents

[Seefelt, Beth]

Title: Message




Hi 
Russ,

I'm 
experiencing a very similar situation today. A batch job aborted last 
night after it couldn't extend the rollback segment beyond 4GB, and I'm still 
waiting for the rollback to complete. Before identifying that, my symptoms 
were very similar to yours. Any DDL or DML against the table would hang, 
the cpus are very active and there is very little i/o going on. 


Here's 
is what I'm using to monitor the rollback progress, and might be helpful to you 
if it happens again -

select 
a.sid,b.used_ublkfromv$session a, v$transaction 
bwherea.taddr = b.addr anda.username = 'PROD' 
;
substitute your username. Watch the USED_UBLK column. It 
decreases when a rollback is occuring, and the rollback will finish when it hits 
0. It gives you an idea how long before the rollback will 
complete.

HTH,

Beth

  
  -Original Message-From: Brooks, Russ 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 3:13 
  PMTo: Multiple recipients of list ORACLE-LSubject: drop 
  tablespace including contents
  Hi, This past weekend we experienced a problem on a production 
  database, and I would like to try to determine what went wrong, how to avoid 
  it in the future, and any better ways of dealing with it should it be 
  encountered again. After moving some large objects out of tablespace to 
  spread I/O, we wanted to reorganize the old tablespace to remove some 
  fragmentation. The tool we were using, sapdba, does not readily permit you to 
  drop the individual tables between the export and the drop tablespace 
  including contents. Since the tablespace had over 3500 tables the drop 
  tablespace was expected to take a long time. We also defined a large rollback 
  segment for use this weekend, although with only maxextents of 100. When 
  Oracle tried to allocate the 101 extent in the RBS, error messages were issued 
  and things came to a grinding halt. sar indicated disk I/O to the new RBS, but 
  not to any of the datafiles. We waited several hours, but the situation did 
  not appear to change. Shutdown immediate did not work. We could alter the 
  datafiles back online, but not the tablespace. Since it was production, the 
  decision was made to restore to a recent backup. 1. Was the rollback 
  activity due solely to storing and restoring DDL for the tables and indices? 
  2. Once the RBS was unable to extend, was the drop tablespace including 
  contents dead? We tried to alter maxextents on the RBS, but did not get a 
  response from the system. Was that the appropriate reaction to this problem. 
  3. A join of v$session and v$sql did not indicate any active SQL. How 
  should we have monitored the progress of what we assume was rollback 
  activity? Any way to estimate how 
  much or how long the rollback would take?
  4. If the 
  database were shutdown during the rollback I assume the rollback would 
  recommence when Oracle came back up. Would it start where it left off or 
  start from scratch. It was my impression that it is marking the header 
  blocks as it goes, but I would like to check.Thanks, Russ 
  Brooks 

RE: Win2000/8.1.7.3.0/SQL

[Seefelt, Beth]

Did you compare the explain plans between a database where it works and where is 
doesn't.  Anything interesting there?

-Original Message-
Sent: Tuesday, August 20, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L


John:

I checked it out with this...


SQL select owner, trunc(last_analyzed), count(*)
  2  from dba_tab_columns
  3  group by owner, trunc(last_analyzed);

OWNER  TRUNC(LAS   COUNT(*)
-- - --
AURORA$JIS$UTILITY$  69
OSE$HTTP$ADMIN   16
OUTLN21
PERFSTAT293
SIEBEL 12-JUL-02  17737
SIEBEL71877
SYS   15831
SYSTEM  172

8 rows selected.

SQL 


...and it looks like there's nothing here, either!

Thanks,
Mike


-Original Message-
Sent: Tuesday, August 20, 2002 2:48 PM
To: Multiple recipients of list ORACLE-L


Mike,

Just a thought - could you check DBA_TAB_COLUMNS too for LAST_ANALYZED in
the SYS schema?

John

   1  select owner, trunc(last_analyzed), count(*)
   2  from dba_tables
   3* group by owner, trunc(last_analyzed)
 SQL /

 So I'm confident it's not analyzed SYS objects.  But then I
 wondered what else Siebel may have done...so I did this...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: patch url needed please.

[Seefelt, Beth]

You can get the Windows one here -

http://ap103aru.oracle.com/ARULink/PatchSearch/process_download/p2376472
_8174_WINNT.zip?patch_file=p2376472_8174_WINNT.ziparu=1797444email=unk
nown

Don't know about other platforms...

-Original Message-
Sent: Monday, August 19, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Hi all.

Does anyone have the url for the ftp site to download the Oracle 8.1.7.4
patch?
Every time I click on the download button, it downloads the web page,
and
not the zip file.
So I am trying to download it via download accelerator, but need the
URL.

Any help would be great.

Thanks

Clint
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Clinton Naude
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-600 on insert over dblink to RDB

[Seefelt, Beth]

Hi everyone,

I just upgraded out development database from 8.1.7 to 9.2 and I'm
getting an ORA-600
error when trying to do 

insert into table1 (select * from table1@dblink)

The error is -

ORA-00600: internal error code, arguments: [qerrmOFBu1], [9100],
[], [], [],
[], [], []

The database on the other end of the dblink is an RDB 7.0.63 database.

I can select * from table1@dblink with any probem.  I can also insert
over a dblink from an Oracle 8.1.7 or 9.2 database without a problem.

I checked Metalink and this ORA-600 error isn't documented yet.

Has anyone seen this error before or have any suggestions for going
about debugging it?

Thanks,

Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Is port 1575 the standard for any Oracle product?

[Seefelt, Beth]

Yes, its the default port for the oracle names listener.

-Original Message-
Sent: Friday, August 16, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L



Is port 1575 the standard port number for any particular Oracle product?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cannot Connect to DB from 9i DS Release 2

[Seefelt, Beth]

Title: Message




Did 
you set your default home back to the 9.2 home after the install? The 
install will have changed it to the home for 9iDS.

Go to 
start - programs - Oracle installation products - Home selector and 
set it back.

You 
should also make sure you have TNS_ADMIN set in the registry so that everything 
looks for the same tnsnames regardless of the home setting.

HTH,

Beth

  
  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:58 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Cannot Connect to DB from 9i DS Release 2
  
  I have a DB connection problem that I cannot resolve and 
  need your help.
  
  Standalone Dell 8200 PC using XP Prof. with 61.6 GB of free 
  space.
  
  A couple of days ago I installed my9.2 DB successfully 
  and was able to connect with SQL*Plus and TOAD.
  
  Then yesterday I installed 9iDS Rel. 2 which finished with 
  no errors. 
  Destination for DS is:
  Name: IDSHome
  Path: C:\IDSHome1
  
  The 9.2 DB is located at C:\oracle\admin . . . \ora92 . . . 
  \oradata
  
  Now I'm having a problem connecting the DB. I can 
  connect via SQL*Plus but not TOAD. I tried connecting to the Forms 
  Developer/Builder, Designer, and Reports Developer/Builder and get the same 
  error message.
  
  ORA-12154:TNS: Could not resolve service name. Service 
  name specified is not defined in TNSNAMES.ORA file.
  
  And when I go to Services for DS I get:
  OracleIDSHomeAgent - fails (will not run even with 
  numerous start attempts)
  OracleIDSHomeClientCache - runs
  Both have startup type of manual.
  
  Attached is my TNSNAMES.ORA file.
  
  One thing I didn't do is reboot my PC prior to the start of 
  this installation. I didn't think I needed to since this is the first 
  installation for DS.
  
  
  Anyone have any idea what is wrong and how I go about 
  correcting it? 
  
  Any and all help will be greatly appreciated.
  
  Thanks,
  Ken 
  

RE: Using Microsoft Windows 2000 Active Directory userid to logon

[Seefelt, Beth]

Metalink doc 60634.1

but set OS_AUTHENT_PREFIX =  and OSAUTH_PREFIX_DOMAIN = TRUE 

HTH,

Beth

-Original Message-
Sent: Friday, August 16, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
logon



 Could you point me in the right direction?

 Thanks John

-Original Message-
Sent: August 15, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L
logon to 



I have it working and am pretty happy with it.  It doesn't allow a user
to connect to the database without entering anything, they still have to
enter a / for username, but they don't have to enter a password.

One tip - for security reasons you should preface the usernames with
your domain name and not OPS$ or some such nonsense.

You will occaissionally run into older products that don't support OS
authentication - eg. Oracle Reports 6.0.

Beyond user ease, the other reason I like it is that I can script DBA
tasks in .bat files without hardcoding username/password 

HTH,

Beth

-Original Message-
Sent: Thursday, August 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
to 



 I have some users who use both Oracle and Microsoft SQL Server.  They
like
the fact they don't have to type in a userid and password when they
logon to
SQL server, they are authenticated with their Windows logon.

 They'd like the same thing when they logon to Oracle.

 I seem to recall that Oracle can use the userid and password from the
operating system but has anyone got this working under NT?

 Thanks John
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Using Microsoft Windows 2000 Active Directory userid to logon to

[Seefelt, Beth]

I have it working and am pretty happy with it.  It doesn't allow a user
to connect to the database without entering anything, they still have to
enter a / for username, but they don't have to enter a password.

One tip - for security reasons you should preface the usernames with
your domain name and not OPS$ or some such nonsense.

You will occaissionally run into older products that don't support OS
authentication - eg. Oracle Reports 6.0.

Beyond user ease, the other reason I like it is that I can script DBA
tasks in .bat files without hardcoding username/password 

HTH,

Beth

-Original Message-
Sent: Thursday, August 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
to 



 I have some users who use both Oracle and Microsoft SQL Server.  They
like
the fact they don't have to type in a userid and password when they
logon to
SQL server, they are authenticated with their Windows logon.

 They'd like the same thing when they logon to Oracle.

 I seem to recall that Oracle can use the userid and password from the
operating system but has anyone got this working under NT?

 Thanks John
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to connect rdb Oracle 7 database under VMS using Sql*Net ?

[Seefelt, Beth]

Hi Jean,

Yes, you can use SQLNet to access the RDB databases.  If you are
accessing by ODBC now, then chances are you already have the SQL
Services software installed.  And you have created a service in
SQLSRV_MANAGE which uses the SQL/Services protocol.

Now, to use SQLNet you have to create a service that uses the OCI
protocol.  Something like this -

Owner:sqlsrv$deflt
Protocol: OCI clients
Default Connect Username: not specified
SQL version:  STANDARD
Autostart:on
Process init: not specified
Attach:   ATTACH 'filename accounting_db'
Schema:   not specified
Reuse:SESSION
Database Authorization:   CONNECT USERNAME
dbsrc file:   not specified
SQL init file:not specified
Appl Transaction Usage:   SERIAL
Idle User Timeout:3600 seconds
Idle Exec Timeout:120 seconds
Min Executors:0
Max Executors:50
Clients Per Executor: 1
Active Clients:   0

Access to service FINANCE_PROD_OCI
Granted to users:
PRIVILEGED_USER 'SQLNET_USER'


There are also scripts provided with RDB that have to be run on the RDB
databases.  They create the data dictionary views - DBA_USERS,
DBA_TAB_PRIVS  that Oracle is used to seeing, so that SQLnet will
think its just connecting to another Oracle database.  You should look
at the SQL/Services administation manual and Metalink to get all the
steps to running those.

Then, on the client you have to update tnsnames to add an entry for the
RDB database -

ACCOUNTING_DB =
  (DESCRIPTION =
(ADDRESS = (COMMUNITY = TCP)(PROTOCOL = TCP)(Host = Alpha)(Port =
1526))
(CONNECT_DATA =
  (SERVICE = Accounting_DB_OCI)
)
  )

where the service is the name of the service you created in
SQLSRV_MANAGE.  Note that it uses port 1526 instead of 1521 becauses RDB
is using the older sqlnet version (at the least the version I'm running
does).

Feel free to email me offline if you have other questions.

HTH,

Beth

-Original Message-
Sent: Friday, August 09, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L


Hello,

Currently we use ODBC drivers to establish connection
between Windows clients and Rdb databases installed on VMS servers.

We have several Oracle databases under Solaris, but I don't know Oracle
RDB databases under VMS ...

In this case, is it possible to user Sqlnet tools to avoid ODBC drivers
?

If it is possible, do we need to install some software on the VMS server
?

Thanks for your help and have a nice day !

Jean Berthold


--


Jean Berthold
EOS - energie ouest suisse
Chemin de Mornex 10 , CP 570
CH-1001 Lausanne , Switzerland
Tel. : +41 (0)21 341 24 58
Fax  : +41 (0)21 341 20 49
E-Mail : [EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jean Berthold
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unix Script Quest : Urgent

[Seefelt, Beth]

I think that will give you files that it successfully accessed, but not
the ones that were referenced but not found.

You can do what you're asking on VMS and NT, so it seems like there
should be a way in Unix, although I asked my Unix SA's that same
question a few years back and they said that there isn't.  They were
pretty sharp guys so I tend to believe them.



-Original Message-
Sent: Friday, August 09, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L



 Is there a way to capture all files hit by a process/user in unix (Sun
 Solaris 9, ksh)?  I am seeing an OCI file not found on my production
box.
 I can't resovle it.
 So, I want to run the same process on my development box (where it
works)
 and get a list of files that it is hitting (I can grep by username)
for
 comparison in production.  Only I am definitely NOT the Unix guru and
as
 this is for a prod issue, so my time is very limited.
 Thanks in advance,


touch BEFORE;
...
find $wherever -newer ./BEFORE;

will give you a list of files that have changed since the
BEFORE file. If you are sure that the files are being
created (vs. modified or accessed) by one specific userid
then:

find / -newer BEFORE -user id

will work also.

If you are going to run the thing regularly then take a
look at find2p, which will spit out a perl script to
match your find command. The perly code will give you
finer control and better sanity checks (e.g., comparing
to a list in memory of what has already been found to
avoid dup's) than find can.

enjoi.


--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OWB 9.0.3.x on NT4

[Seefelt, Beth]

Hi,

Is anyone running OWB 9.0.3.33.0 or 9.0.3.35.0 on NT 4?  I'm having some
problems and would like to compare configurations with anyone that has
it working.

Thanks

Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to Access

[Seefelt, Beth]

Title: Message




Hi 
Lee,


Here is what I did to get it workingon NT 
for an excel spreadsheet.

1. Create the ODBC DSN to the data 
source
2. Make sure heterogeneous services is installed in 
%ORACLE_HOME%\HS\ADMIN
3. Add the entry in tnsnames.ora with 
(HS=OK)
4. Add an entry in listener.ora with 
(PROGRAM=hsodbc)
5. Create the database link to the 
spreadsheet.

If you want some specific examples of the tnsnames and 
listener entries let me know and I'll dig them 
up.

HTH,

Beth

-Original 
Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 31, 2002 5:48 AMTo: Multiple 
recipients of list ORACLE-LSubject: Oracle to 
Access

  Hi,
  
  Oracle 
  8.1.7.3
  Tru64 
  5.1
  MSAccess 
  2000
  
  Preparing to be 
  shot down in flames but I have been looking through some documentation and 
  also some White Papers but for some reason I just don't get 
  it.
  
  I need to see 
  Access tables from an Oracle DB. The paper I am reading (from Metalink) states 
  that I should be able to do this via Heterogeneous Services and ODBC agent but 
  I cannot see how it all hangs together.
  
  Has anyone done 
  this and if so could you point me in the right direction please. I don't need 
  an idiots guide (or maybe I do) but a gentle nudge in the right direction 
  should suffice.
  
  Regards
  
  Lee
  
  The 
  information contained in this communication isconfidential, is intended 
  only for the use of the recipientnamed above, and may be legally 
  privileged.If the reader of this message is not the intendedrecipient, 
  you are hereby notified that any dissemination, distribution, or copying 
  of this communication is strictlyprohibited.If you have received this 
  communication in error,please re-send this communication to the sender 
  anddelete the original message or any copy of it from yourcomputer 
  system. Thank You.

RE: There are even more plots to go around.

[Seefelt, Beth]

Jared?  Please?

-Original Message-
Sent: Wednesday, July 31, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L


insipid, boring, devoid of substance



On 30 Jul 2002 at 14:29, Gogala, Mladen wrote:

 
 
 
 Microsoft Bids to Acquire 
 Catholic Church

...


try this instead:

http://www.transform.org/transform/dlc/rapids/rapids.html

-

http://www.amazon.com/exec/obidos/ASIN/0195111303


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Heterogenous Services

[Seefelt, Beth]

The advantage is that you're not loading data from an ODBC source into
the database.  You are viewing the source over a DB Link and so see a
real time view of it.  If you have production data in Excel spreadsheets
or Access databases then it can be very convenient to have a current
view of that from Oracle.

(This is not an invitation to flame me about the prudence of keeping
production data in Access or Excel.  If it were my choice, it wouldn't
be there).

Beth

-Original Message-
Sent: Wednesday, July 31, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


And is it needed?. I am sure I have set up odbc connections between
Oracle
8i databases on Unix and Access/Excel and I have never heard of
Heterogeneous Services before

-Original Message-
Sent: 31 July 2002 13:24
To: Multiple recipients of list ORACLE-L


I did a bit of research on Heterogeneous Services, apparently it lets
you
create ODBC connections between Oracle on UNIX and Windows apps.
 
Can this be true?
 
Does it actually work?
 
What is the performance like?
 



Regards, 
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

.

-Original Message-
Sent: Wednesday, July 31, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L


Hi,
 
Oracle 8.1.7.3
Tru64 5.1
MSAccess 2000
 
Preparing to be shot down in flames but I have been looking through some
documentation and also some White Papers but for some reason I just
don't
get it.
 
I need to see Access tables from an Oracle DB. The paper I am reading
(from
Metalink) states that I should be able to do this via Heterogeneous
Services
and ODBC agent but I cannot see how it all hangs together.
 
Has anyone done this and if so could you point me in the right direction
please. I don't need an idiots guide (or maybe I do) but a gentle nudge
in
the right direction should suffice.
 
Regards
 
Lee



 





The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

dbsnmpj access violation

[Seefelt, Beth]

Title: dbsnmpj access violation







Hi all,


I've just finished installed 9.2 on W2K. Whenever I submit a job through the OEM console the dbsnmpj.exe process gets an access violation and the job fails to run. When I enable tracing on dbsnmpj, it works fine. Disable tracing and it dies again. Has anyone seen this problem?

Thanks,


Beth

RE: Slightly OT: Chart generation tool for db monitoring scripts out

[Seefelt, Beth]

MRTG is one.

-Original Message-
Sent: Monday, July 29, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
out


Does anyone know of any simple utility that will take a data file and
generate a quick chart. I'd like to generate a chart of number of
transactions per time period. I can generate the output through a SQL
query.

Actually I'd like to do this for more data, but this is just an example.

Thanks
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Chart generation tool for db monitoring scripts

[Seefelt, Beth]

Hi Raj,

What do you want to generate the output in if not html?

Beth

-Original Message-
Sent: Monday, July 29, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
scripts 


Thanks Ron, Beth,

That is the last option. Do we have anything that can be used without a
supporting web server? I'd like to run this off my file system. 

TIA
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Monday, July 29, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
scripts out



Do a google search for RRD Tool
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Chart generation tool for db monitoring scripts

[Seefelt, Beth]

Raj,

I still think MRTG is an option, although I'm sure there are other
better ones, like gnuplot that someone else mentioned.

Beth

-Original Message-
Sent: Monday, July 29, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
scripts 


Beth,

Okay ... here is the whole story (I should have done this in my first
mail,
but I didn't have time then) ...

1. I currently generate a bunch of HTML reports using SQLPLUS. all these
are
stored on my file system. Updated periodically by (gasp) MS task
scheduler.
2. I have a navigation page that lets me go to a page of my choice and
see
the tabular data which is in html format.

I'd like to have some graphs generated to give more visual clues than
having
to scan the data manually. This is the reason why I am asking. An
important
one is to measure the 'current block receive time' for our RAC instance.

Thanks for any pointers.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Monday, July 29, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L

Hi Raj,

What do you want to generate the output in if not html?
Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

NLS questions

[Seefelt, Beth]

Title: NLS questions







Hi everybody,


Ive been asked to incorporate the data from our remote sites in France, Portugal, Switzerland and Sweden into our existing data warehouse in the UK. I expect I'll have characterset and currency issues to deal with, but I've done very little with NLS. Are there other things I should be thinking about ahead of time? Can I or should I even attempt to put all of the data into 1 database and handle the NLS settings on the client, or should I keep it in separate databases?

I appreciate your comments,


Beth

RE: oracle 9i

[Seefelt, Beth]

Yes, it does.

-Original Message-
Sent: Thursday, July 25, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


Hi All!
We will use Oracle 9i db and I would like to know if Oracle8i client
works fine with 9i database?

Thanks.

Greg.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Faktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: View error msg

[Seefelt, Beth]

Does the WHERE clause on your view contain all of the fields from both
primary keys?  Maybe you should post the table/view definitions.

Beth

-Original Message-
Sent: Tuesday, July 23, 2002 11:33 PM
To: Multiple recipients of list ORACLE-L



Hi,
I created a view as a join of two tables, each of which has a 
primary key defined on it. When I am trying to insert values into the
view 
I see the following error msg,

ORA-01779: cannot modify a column which maps to a non 
key-preserved table

What could the error be?
Thanks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vandana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Windohs client problems

[Seefelt, Beth]

BTW, 9iAS is not required for OWB.  I'm running it on a 9.0.1 database
with no 9iAS.  You lose a couple of features, but nothing major.

Beth

-Original Message-
Sent: Wednesday, July 24, 2002 5:58 AM
To: Multiple recipients of list ORACLE-L


are you talking about reinstalling windows, or oracle?

did you take it down to bare metal, and remove all 
oracle products, including following the instructions 
from oracle tech support for doing a manual cleanout?

do you have a production db installed on that box?

backups?


On 23 Jul 2002 at 13:34, Jesse, Rich wrote:


 OK, my hair is thinning fast enough without this.  On WinTuke SP2,
I've got
 a 9.0.1 full install of EE.  I also have an install of the 8.1.7
client in a
 second ORACLE_HOME.
 
 I've been using this setup fine and well until I installed Oracle
Warehouse
 Builder into a separate ORACLE_HOME, then de-installed it after
finding out
 it needs 9iAS.  Then Quest products started flaking out, so Quest had
me
 fiddle with the LAST_HOME registry entry.  After that, the Microslop
ODBC
 for Oracle driver fails to find the Oracle driver, stating:
 
 [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of
 ODBC behavior that the application requested (see SQLSetEnvAttr)
 
 And now, after uninstalling the 8.1.7 client, cleaning the registry,
 reinstalling and rebooting, I can only connect *HALF OF THE TIME*
using 9i.
 The other half I get a TNS-12154, net name not found error.  I'm using
 ONames for names resolution, but I don't understand what the hell is
going
 on here.  And seeing that it'll take me days to uninstall, reinstall,
and
 reconfig I'd just as soon not do it.
 
 Anyone else have to deal with this hoo-ha that has a solution?
 
 I'd rather be at home diazinoning earwigs...  sigh
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech International, Sussex,
WI USA
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Customized reporting for STATSPACK?

[Seefelt, Beth]

Take a look at www.oraperf.com

-Original Message-
Sent: Monday, July 22, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L


Hey all,

Finally have installed STATSPACK on 8.1.7.2.0, but am disappointed at
the
archaic two-lines-per-row 80-columns in spreport.sql.

Anyone have any links to some report SQL that formats STATSPACK reports
a
little better?  I'll probably use TOAD for my usage, but I'll take
anything
to start.

Just trying to prevent the reinvention of the wheel before I go thru the
whole SQL and do it myself.  (Ick!)

TIA!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: finding pasword emails. Virus ???

[Seefelt, Beth]

I have gotten one also.  It appears to be some type of attempted virus.
Its an html message that attempts to execute an attachment as an
application.  The attachment is called password.txt, I assume to fool
the email filters.  As far as I can tell, it didn't work on my machine,
and I did a search through Symantec's web site for the signature, but
didn't find one.  If anyone knows what to look for to tell if the virus
did anthing, I'd appreciate the info.

Beth

-Original Message-
Sent: Thursday, July 18, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L


Hello list,

I'm getting many finding pasword emails from non-registered users.
have you got this type of email ? is it a spam or virus ?

regards...

--
Danisment Gazi Unal
http://www.ubTools.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Sql query

[Seefelt, Beth]

select field from table1 where (select 1 from table2 where table2.field
= table1.field) is null;

-Original Message-
Sent: Wednesday, June 26, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone whom can give me an example on how to pick out field id and name
from table one and get only the id's  that exists in table one doesnt
exist in table2.

Thanks in advance

Roland




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sqlloader tuning

[Seefelt, Beth]

Ravi,

You can't use sql functions in the control file with direct=true.  You
can do a direct load, and then run a sql script on the loaded data to
make changes.  Sometimes the performance gains from the direct load make
that worthwhile.

Set bindsize=rows*rowlength where rows is the number of rows you want to
load before each commit, rowlength is the length of the records in the
flat file.

To see if you selected appropriate values, run a load of 1 record and
generate a log file -

sqlldr rows=2 bindsize=500 load=1 log=load.log

Check the log to see if you sized appropriately

Space allocated for bind array:4999560 bytes(10245 rows)
Read   buffer bytes: 500

Adjust accordingly - bindsize = 2*(4999560/10245) = 976

sqlldr rows=2 bindsize=976 load=1 log=load.log

Space allocated for bind array:976 bytes(2 rows)
Read   buffer bytes: 976

HTH,

Beth



-Original Message-
Sent: Wednesday, June 26, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Can any one please tell me what is the deciding factor
to specify rows value and bindsize value in sqlloader
option? 

is there  any option to use direct=true while using
function in control file?

DB:8.1.7 os:SUN SS
thanks for your help.

Cheers,
Ravi

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Log file synch / direct path writes

[Seefelt, Beth]

Ramon,

For one thing, LGWR will write the log buffer when it is 1/3 full, or if
it reaches 1MB.  So, its useless to have the log buffer more than 3MB.
The space beyond 3MB could never possibly be used.  

My .02

Beth

-Original Message-
Sent: Monday, June 24, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Jared,

Just to clear my thoughts, doubts and keep learning from the list.

What implications can cause having a big log buffer.

As I can remember, LGWR copy data from the log buffer to the redo logs
when
log buffer is 1/3 full, timeout, commit and a few more.

So it will fire when the first one occurs, base on that theory, what
matters
if the log buffer is 1mb, 10mb, 100mb.  Anyway LGWR will copy the data
to
the redo logs.

I had some problems of performance the last week and some of you got
surprised because I had a log buffer of 100MB.

I have never read some documentation, obviously have to read more and I
am
doing it believe me, that tells not to do it.

I would like some comentaries or your considerations about this,

TIA

Ramon


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 1:33 PM



 Just how large is your overly large log buffer?

 10 meg?

 100 meg?

 1 Gig???  ( ok, I've never heard of one this big,
 but you never know ;)

 Jared

 On Friday 21 June 2002 12:48, Erik Williams wrote:
  I have an instance that is waiting on log file synchs. I suspect
that
the
  waits are a result of a overly large redo log buffer. There are also
  considerable waits on direct path writes. The redo logs are on
QuickIO,
so
  I assume that the writes LGWR is writing asynchronously and not a
source
of
  the log file synchs. I want to be sure that the log file synchs and
direct
  path writes are not related before I begin to experiment with the
size
of
  the redo log buffer. How can I be sure that the waits are being
caused
by
  DBWR and not LGWR? What are possible fixes for the direct path
writes if
it
  is the DBWR causing them? Multiple DBWR? The datafiles are not on
QuickIO,
  just the redo.
 
  Thanks
  Erik
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jared Still
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Wait event problems

[Seefelt, Beth]

Excellent information!  Thanks for taking the time to write it all down.

Beth

-Original Message-
Sent: Friday, June 14, 2002 10:42 AM
To: '[EMAIL PROTECTED]'
Cc: Seefelt, Beth


Well, with all the caveats that's a long and boring story, so I'll
shorten
it up.  ;)

1)  SDU/TDU values of 32768, as were specified by our 3rd-party vendor
in
their extremely non-OFA f'd-up install, are not valid.

2)  Specifying SDU/TDU in TNSNAMES.ORA (or ONAMES) is useless unless
it's
corresponding value is also in the server's LISTENER.ORA.  If you don't
specify the value in LISTENER.ORA, you will be using the default SDU
value
of 2048.

3)  Specifying SDU/TDU in a LISTENER.ORA will not work out-of-the-box in
8i.
I've verified this thru a client trace.  Apparently, in 8i, the
automatic
registry of an instance to the listener will overwrite any SDU/TDU
values
specified in the LISTENER.ORA.  The workaround to override the auto
registry, you must declare a bogus SERVICE_NAMES and LOCAL_LISTENER in
the
DB's init.ora and restart the instance.

4)  What value to set SDU?  Test!  On a TEST client set an SDU value in
the
TNSNAMES.ORA (see Oracle docs for how/where).  Then, set the following
in
the client's SQLNET.ORA:

TRACE_LEVEL_CLIENT = SUPPORT
TRACE_FILE_CLIENT = sqlnet
TRACE_DIRECTORY_CLIENT = /some/directory
TRACE_UNIQUE_CLIENT = on

4a)  If you aren't using TNSNAMES, make sure your NAMES.DIRECTORY_PATH
in
the SQLNET.ORA starts with TNSNAMES.

5)  Connect a test client.  Do some work from this client, preferrably
as
close to a real user as possible.  Note that the tracefile created
will
contain every bit from every packet sent to and from the client, as well
as
all the overhead involved for debugging, so the file can grow large
quick.
It only less than 5 minutes of testing to produce a 55MB trace file for
us.

6)  Disconnect the test client.  Before running trcasst, you'll need to
edit
the trace file in order to workaround a bug in trcasst.  If you're
Unix-y,
you can use this instead of trying to pull 50+MB into mem (VERY crude
SED --
there's a much more elegant way of doing this!):

mv sqlnet_.trc t.t
sed -e 's/nspsend: /nspsend:/g' t.t t.tt
rm t.t
sed -e 's/nsprecv: /nsprecv:/g' t.tt t.t
rm t.tt
sed -e 's/nsprcvs: /nsprcvs:/g' t.t t.tt
rm t.t
rm sqlnet_.trc
mv t.tt sqlnet_.trc

The rms are in there to reduce the amount of disk needed.  PLEASE
adjust
for your own environment!  If you're using Winders, get CygWin to use
sed
(or use any of a number of tools for search/replace).

7)  trcasst -od sqlnet_.trc sqlnet_.lis

8)  Examine the .lis file for send/receive packet sizes.  I dumped the
output from a grep of the .lis file to MS Exhell to graph the send and
recieve packets.  It's easier for me to see the need for a larger SDU
when
the graph shows a nice square wave pattern.  The theory being that if
SQL*Net is pushing the maximum SDU size several packets in a row (a
nice,
flat horizontal line at the top of the graph), that the SDU could stand
to
be larger so as to minimize the length of that line.

9)  Repeat steps 5 thru 8 with different values of SDU, remembering to
change both the client and the server, and to restart the listener after
each change.

Anyone care to comment on this?  This is pretty much just what I figured
out
yesterday, so I'm interested to know of any whoopses I may have made.
One
thing I'm not sure of is How big is too big for an SDU value?.

HTH!  GL!  Happy Flag Day!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA


 -Original Message-
 From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 13, 2002 7:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Wait event problems
 
 
 
 Hi Rich,
 
 I'm curious, what value did you decide on for SDU?  Let us know how it
 works out.
 
 Thanks,
 
 Beth
 
 
 -Original Message-
 Sent: Thursday, June 13, 2002 1:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi Lee,
 
 I'm investigating a very similar problem on 8.1.6.0.0 on Solaris.  So
 far,
 I've found out that the 3rd-party vendor who setup this debacle had
 inserted
 invalid values for SDU/TDU in tnsnames.ora on the client and
 listener.ora on
 the server.  I'm correcting them now as we speak.  
 (Incidentally, Oracle
 recommends NOT modifying TDU and gives no guidelines as to 
 how to select
 a
 value.)
 
 Also, our clients are Java apps, which would be my guess as 
 to the root
 of
 the problem.  The clients just aren't fast enough to deal with the
 rather
 large overhead of Java.  But I'm cautiously optimistic on the SDU/TDU
 fix...
 
 And www.fatcity.com doesn't want to respond, so we'll have to 
 wait a bit
 to
 search the archives.
 
 GL!
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech International, 
 Sussex, WI
 USA
 
 
 -Original Message-
 Sent: Thursday, June 13

RE: 9i R2 not automatically starting up after upgrade

[Seefelt, Beth]

The database should start when you start the service if the registry
entry ORA_SID_AUTOSTART is set to TRUE.  When you upgraded the
database, did the ORA_SID_* registry keys get moved into the new
HKLM\Software\Oracle\HOMEx key, and removed from the old one?  ORA-27101
can indicate its trying to start from the wrong ORACLE_HOME.

Beth

-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L


I tried that...didn't fix the problem.  The service actually starts
without any problems, but for some reason, starting the service doesn't
actually start the database.  I have to actually login to SQL*Plus in
/nolog mode, connect / as sysdba and then do a startup manually to get
the database running.  Thanks though.

_YEX_
)))

-Original Message-
Sent: Friday, June 14, 2002 3:38 AM
To: Multiple recipients of list ORACLE-L


Are you using a domain to connect to your PC.

You should go into services and OracleServiceSID --- Properties. In
the Log On tab go and choose log on as this account and choose your
username and password that you are connecting to the domain.

Stop and restart the service, and check that the memory is reserved for
the instance.

Regards
Theodoros

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 8:22 PM
To: Multiple recipients of list ORACLE-L


I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0),
and am now having problems with the database starting up automatically
on system reboot.  This is on a Windows 2000 Pro machine.  The error
that I get when I try to connect with SQL*Plus is ORA-27101: shared
memory realm does not exist.  If I run SQL*Plus with the /nolog option,
connect / as sysdba, and startup manually, everything works fine.
Anyone have any idea why it won't startup automatically, or what I could
try to get it to?  Thanks.

_YEX_

/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/

 Robert D. Yexley (E-mail).vcf 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Theodoros Demosthenous
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yexley Robert D Contr Det 1 AFRL/WSI
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Port access cancelling

[Seefelt, Beth]

Try it without the pipe to grep and see if the netstat -a is returning
anything at all.  


-Original Message-
Sent: Friday, June 14, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L


When I gave this command on my db  server nothing
responded for 10 mnts. then I cancelled the command ;
please advice.

--- Hemant K Chitale [EMAIL PROTECTED] wrote:
 
 On Unix, use netstat -a | grep port_number
 to see if there is any service listening on the
 port.
 
 At 11:58 PM 13-06-02 -0800, you wrote:
 Hello Unix Guru's!
 
 One of the port supposed to be used by db server
 has
 been occupied by application servers. When I want
 start a particular interface programs on DB which
 access the particular port is right now busy
 because
 it is used by apps server which is not supposed to
 be.
 I cancelled the PID on apps server and tried run
 ning
 the application interface on db server, but I still
 get the port in use error. How do I check that this
 port is in use by which apps server. We have 4 apps
 servers. Last time when we had this issue we did
 rebooted the apps servers to release this port. I
 guess that not the perm. solution.
 
 Please advice.
 
 
 =
 Thank You.
 
 Best Regards,
 Steve Johnson
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Steve Johnson
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Hemant K Chitale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


=
Thank You.

Best Regards,
Steve Johnson

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: VB and Oracle...memory limiting the amount of records returned?

[Seefelt, Beth]

Hi Chris,

I'm not sure I understand the problem, but we have VB apps that routinely retrieve 
tens of thousands of records at a time, and occaissionally more, if that helps.  We 
have not run into any limitation.  If you want to send me more details on the problem 
I'd be happy to try to help.

Beth

-Original Message-
Sent: Friday, June 14, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L


We have a VB app that uses Oracle as the database.  The users noticed a
limitation in the amount of records being returned from the database.  So
they decided to increase the memory of the PC and some additional volume of
records were returned.  ??

Has anyone using VB/Oracle noticed this??  Is this simply a sign of bad
coding?  Trying to load up all the records into memory, and therefore
failing?  

Any clues, references or links would be appreciated.

TIA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cleanup of child records...

[Seefelt, Beth]

Title: Message




delete 
from childtable a
 
where not exists (select 1 from parenttable b where b.key1=a.key1 and 
b.key2=a.key2...) ;

try it 
as -


select 
*from childtable a
 
where not exists (select 1 from parenttable b where b.key1=a.key and 
b.key2=a.key2...) ;

to make sure it is going to delete what you 
think it is.

HTH,

Beth

  
  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 
  12:59 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Cleanup of child records...
  TIA List, 
  What is the most efficient way to remove child records from a 
  table that have no parent records in it's parent 
  table. I want to build a FK, to keep this from 
  happening, but I need to do some cleanup first. 

RE: Wait event problems

[Seefelt, Beth]

Hi Rich,

I'm curious, what value did you decide on for SDU?  Let us know how it
works out.

Thanks,

Beth


-Original Message-
Sent: Thursday, June 13, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L


Hi Lee,

I'm investigating a very similar problem on 8.1.6.0.0 on Solaris.  So
far,
I've found out that the 3rd-party vendor who setup this debacle had
inserted
invalid values for SDU/TDU in tnsnames.ora on the client and
listener.ora on
the server.  I'm correcting them now as we speak.  (Incidentally, Oracle
recommends NOT modifying TDU and gives no guidelines as to how to select
a
value.)

Also, our clients are Java apps, which would be my guess as to the root
of
the problem.  The clients just aren't fast enough to deal with the
rather
large overhead of Java.  But I'm cautiously optimistic on the SDU/TDU
fix...

And www.fatcity.com doesn't want to respond, so we'll have to wait a bit
to
search the archives.

GL!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA


-Original Message-
Sent: Thursday, June 13, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


All,
 
Oracle 8.0.5.0.0
Tru64 v4.0f
 
We are running a job and statspack reports show that our only problem
(it is
running like a dog) is the following
 
SQL*Net more data from client.
 
Done some reading and still none the wiser. Anyone else had this sort of
problem and if so how did you get around it ??
 
Regards
 
Lee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Messing with SDU/TDU in listener.ora

[Seefelt, Beth]

Turn on sqlnet tracing on a client and see what the sqlnet log says.
Here's an example from one of mine.  I am using the default SDU/TDU,
supposedly.

nsconneg: vsn=310, gbl=0x0, sdu=2048, tdu=32767


-Original Message-
Sent: Tuesday, June 11, 2002 5:10 PM
To: Multiple recipients of list ORACLE-L


Hey all,

Running the response_time_breakdown.sql from Steve Adams
(http://www.ixora.com.au) on an 8.1.6.0.0 Solaris instance, I'm seeing
40%
of the execution time in SQL*Net more data from client.  I figured
that
this was due to the clients being  sluggish 3rd-party Java apps, but
thought
I'd check into to it anyway.

One thing I noticed is that the SDU and TDU have been set to 32768 in
the
listener.ora.  First, according to Metalink note 44694.1, this isn't
even
valid, since the max size is 32767.  Second, I know that the Oracle
Names
entry for this instance does not have either of these set.  The
tnsnames.ora
does, however, and I can't tell which one is being used by the client.

So, before I go ahead and remove these entries from the listener.ora:

1)  Is there a way to tell from the server what the SDU/TDU values of a
client are?  This way I can tell if the Oracle Names entry is being used
by
the app or if it's using the tnsnames.ora

2)  Does 32768 have an effect if it's not in the range of valid numbers
for
SDU/TDU?

3)  Can these parameters affect the SQL*Net more data from client wait
times?

TIA!


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Newline char in oracle files

[Seefelt, Beth]

Title: Newline char in oracle files







Hi everybody,


I have a very odd problem I hope someone can help me with. I've installed Oracle, OEM and OWB on a couple of NT 4.0 servers in the UK. The text files that Oracle generates during the install - the .config, .ora and the .ctl files from OWB - are generated using a lf as the newline character instead of a cr. The result is that in notepad they all appear as one run-on line with embedded control characters (line feeds). I have not had this problem on any of the servers in the US.

I'm using the same installation media in both places. Is there UK specific media I should be using? Or is there is something in the regional settings on the servers that would determine what newline character is used? 

I've checked the Oracle and Microsoft support sites and even opened a tar but am still stumped, so any suggestions will be appreciated. I've tried contacting our sysadmin about it but I don't expect any response until the England/Argentina match is over :-)

TIA,


Beth

RE: Newline char in oracle files

[Seefelt, Beth]

Title: Message




Tom,

Consider it done! Thanks for the advice. I hadn't tried 
wordpad and prefer notepad, but its definitely a step up from Word which was 
what I have been using.

Beth

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 
  2002 11:34 AMTo: '[EMAIL PROTECTED]'Cc: Seefelt, 
  BethSubject: RE: Newline char in oracle files
  Beth,
  
  Use 
  WordPad - it interprets and opens the files just fine.
  Most 
  of newer Oracle *.sql files have the same issue - if you use WordPad, they 
  open fine.
  
  This 
  bit of advice just cost you a virtual glassof Tetley Tea. Please 
  submit ASAP!
  
  thank you!
  
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Seefelt, Beth 
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 
11:38 AMTo: Multiple recipients of list 
ORACLE-LSubject: Newline char in oracle 
files
Hi everybody, 
I have a very odd problem I hope someone can help 
me with. I've installed Oracle, OEM and OWB on a couple of NT 4.0 
servers in the UK. The text files that Oracle generates during the 
install - the .config, .ora and the .ctl files from OWB - are generated 
using a lf as the newline character instead of a cr. The result is 
that in notepad they all appear as one run-on line with embedded control 
characters (line feeds). I have not had this problem on any of the 
servers in the US.
I'm using the same installation media in both 
places. Is there UK specific media I should be using? Or is 
there is something in the regional settings on the servers that would 
determine what newline character is used? 
I've checked the Oracle and Microsoft support 
sites and even opened a tar but am still stumped, so any suggestions will be 
appreciated. I've tried contacting our sysadmin about it but I don't 
expect any response until the England/Argentina match is over :-)
TIA, 
Beth 

RE: SQL*Loader question

[Seefelt, Beth]

I don't know if you can load the first 100 records, but you could load
the last 100 by setting the skip value to the total - 100.

HTH,

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.6.3 on Sun 2.6.

I have tried reviewing the docs, but I didn't see anything that answered
the
question.  Is it possible to limit the number of records being loaded?
We
have a file that has records in the 6 digit range.  I'd like to test the
controlfile, but I don't want to load the whole file.  Is there a way to
tell loader to only load, say the 1st 100 records?

TIA

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1800

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ball, Terry
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on NT

[Seefelt, Beth]

Hi Paul,

I believe you are correct on all counts.  I have not used RMAN on NT, but if it will 
handle UNCs that might be the way to go. 

I believe that the local system account runs with the profile of the .Default user.  
If you could get the drive map into that profile that might work for you also.

Beth

-Original Message-
Sent: Tuesday, June 04, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L


A couple of basic questions, if you'll indulge me:

1.  Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)?
2.  If so, would that explain why RMAN can't write to a network drive
that's mapped by a different user who is logged in to the domain rather
than the local machine?

Side question:  Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?

Many TIA.

Paul Baumgartel


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle 8i on Terminal server

[Seefelt, Beth]

Yes, there is a workaround.  I use terminal services for everything,
including installs and have not had any issues.

You have to force everything to go through sqlnet by using @sidname, and
never use the bequeath adapter.

SVRMGRL connect internal@yoursid

SQLPLUS username/pwd@yoursid

or

c:\ sqlplus
Username: user@yoursid

hth,

Beth


-Original Message-
Sent: Monday, June 03, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L


http://metalink.oracle.com/oracleinstall/oracle8i/windows.html

this and a couple other links i've read, give the impression that oracle
with  terminal server/services is not supported.  is there a work around
to
allow you to user terminal services and oracle?

i'd like to use sqlplus and connect using internal or some other
oracle-based credentials, can this be done using a thin-client
connection?
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Streeter, Lerone  A LBX
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Server to Oracle DB

[Seefelt, Beth]

Title: Message




If 
your Oracle platform is Windows, take a look at Heterogeneous Services. I 
just tried it Friday for the first time to load data from an Excel spreadsheet 
and it seems to work pretty well. Should work for SQL 
Server.

HTH,

Beth

  
  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:03 
  AMTo: Multiple recipients of list ORACLE-LSubject: SQL 
  Server to Oracle DB
  Anyone know of an easy way to grab data from tables 
  in an SQL Server DB and insert into tables in an Oracle DB? 
  Thanks. 

RE: Do you ever have days where you dont want to think ?

[Seefelt, Beth]

 spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Root, Melanie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle RDB vs. Plain Oracle

[Seefelt, Beth]

Hi,

Oracle RDB is the database originally produced by Digital Equipment Corporation.  Its 
runs on OpenVMS and originally competed with Oracle on that platform.  Oracle bought 
it from DEC and still develops it separately from Oracle RDBMS.  It has alot of the 
same features as Oracle - parallel query, partitioning, bitmap indexes etc... but is 
an entirely separate product and only runs on OpenVMS.  They tried porting it to NT at 
one point, but I think that effort was abandoned.

HTH,

Beth

-Original Message-
Sent: Thursday, May 16, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L


Hello,

What are the differences between the two?
Thanks.

ltiu
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Create synonyms in externally authenticated user's schema

[Seefelt, Beth]

Title: Create synonyms in externally authenticated user's schema







Hi all,


When I create a new nt OS authenticated user I need to create several synonyms in that users's schema? How can I create synonyms as that user easily?

I know that I can get them to give me their nt password and log in as them, or create a stored procedure that executes as that user, or a user logon trigger, but I'm hoping there is a more straight forward way to do this?

TIA,


Beth

RE: DBA_EXTENTS problem

[Seefelt, Beth]

Sounds like a fragmentation problem.

This will help you identify the segments with a large number of
fragments.  They are good candidates for reorganization.

HTH,

Beth

select  a.tablespace_name as tablespace,
cast(a.segment_name as char(30)) as segment,
a.partition_name as partition,
count(1) as count,
decode(b.extent_management,'LOCAL','Y','N') as LMT
  from  dba_extents a,
dba_tablespaces b
 where  a.tablespace_name = b.tablespace_name
 having count(1)  1
 group by a.tablespace_name,
a.segment_name,
a.partition_name,
decode(b.extent_management,'LOCAL','Y','N')
  order by count(1) desc



-Original Message-
Sent: Thursday, May 09, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L


Dear List,

When I query dba_extents , Iam getting response after half an hour to 40
minutes, but when I query any other dictionary view it is spontaneous.
Everything else is fine in the database and there are no problems,
except
the above problem. Iam not getting any clue how to fix this. Iam
thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it
would
fix the problem. Please let me know if there is any other way to fix
this
problem. 

Thanks,
Babu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA_EXTENTS problem

[Seefelt, Beth]

 subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA_EXTENTS problem

[Seefelt, Beth]

what does

select count(*) from uet$

return?

-Original Message-
Sent: Thursday, May 09, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L


Dennis,

It is happenning for any table in the database. I have just created a
new
table:
create table x1 (col1  number) tablespace data_ts, inserted one row and
run:
select * from dba_extents where segment_name = 'X1'; It is still sitting
there. The response to any other dictionary view is spontaneous except
this
dba_extents, which is confusing me.
I issued: select * from dba_objects where ..., select * from
dba_segments
where  etc. They are all responding fine.

There are not many users at the moment. System tablespace is 500M size
and
300MB is free. DB is 40Gig in size. It is on HP_UX 11.0 and Oracle
8.1.7.2.0
(64bit) database.

Any other ideas?

Thanks,
-- Babu

-Original Message-
Sent: Thursday, May 09, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L


Babu - Wow, never had that one. Of course, I don't use that table much.
How
many rows are in this table? Mine has 12,937 rows, and is kinda slow to
respond compared to the other system tables. Do you have a test database
to
compare with? Is it possible that your system tablespace has become
badly
fragmented? What is your system load, is it possibly a contention
problem of
some type. Why not run STATSPACK (or utlbstat) while you do this query
and
see what is being waited for? Why don't I shut up and send this?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 09, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


Dear List,

When I query dba_extents , Iam getting response after half an hour to 40
minutes, but when I query any other dictionary view it is spontaneous.
Everything else is fine in the database and there are no problems,
except
the above problem. Iam not getting any clue how to fix this. Iam
thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it
would
fix the problem. Please let me know if there is any other way to fix
this
problem. 

Thanks,
Babu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBA_EXTENTS problem

[Seefelt, Beth]

or more accurately -

select count(*) from sys.uet$;



-Original Message-
Sent: Thursday, May 09, 2002 2:03 PM
To: '[EMAIL PROTECTED]'



what does

select count(*) from uet$

return?

-Original Message-
Sent: Thursday, May 09, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L


Dennis,

It is happenning for any table in the database. I have just created a
new
table:
create table x1 (col1  number) tablespace data_ts, inserted one row and
run:
select * from dba_extents where segment_name = 'X1'; It is still sitting
there. The response to any other dictionary view is spontaneous except
this
dba_extents, which is confusing me.
I issued: select * from dba_objects where ..., select * from
dba_segments
where  etc. They are all responding fine.

There are not many users at the moment. System tablespace is 500M size
and
300MB is free. DB is 40Gig in size. It is on HP_UX 11.0 and Oracle
8.1.7.2.0
(64bit) database.

Any other ideas?

Thanks,
-- Babu

-Original Message-
Sent: Thursday, May 09, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L


Babu - Wow, never had that one. Of course, I don't use that table much.
How
many rows are in this table? Mine has 12,937 rows, and is kinda slow to
respond compared to the other system tables. Do you have a test database
to
compare with? Is it possible that your system tablespace has become
badly
fragmented? What is your system load, is it possibly a contention
problem of
some type. Why not run STATSPACK (or utlbstat) while you do this query
and
see what is being waited for? Why don't I shut up and send this?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, May 09, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


Dear List,

When I query dba_extents , Iam getting response after half an hour to 40
minutes, but when I query any other dictionary view it is spontaneous.
Everything else is fine in the database and there are no problems,
except
the above problem. Iam not getting any clue how to fix this. Iam
thinking of
running catalog.sql and catproc.sql as a last resort. Iam not sure it
would
fix the problem. Please let me know if there is any other way to fix
this
problem. 

Thanks,
Babu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: optimizer not using function based indexes

[Seefelt, Beth]

Another requirement is that your compatibility init.ora parameter must
be set to 8.1.7 or higher, I believe, but check the doco.

If that doesn't fix it, then trying using a hint to force the use of
that index.  If it doesn't work with the hint, then you know you have an
environment problem that is preventing the use of function-based
indexes.  If it does work with the hint, then you know that function
based is working but you have to figure out why the optimizer is not
choosing it.

HTH,

Beth

-Original Message-
Sent: Thursday, May 09, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L


Hi,

We are trying to use function based indexes in our application but it
looks like 
optimizer is  not using them.
So we created a sample table emp with 3 columns empno,ename,sal and
populate
this table with 10 rows and created function based index on
upper(ename).
we try to run simple query like below and optimzer is not using index:
select sal from emp
where upper(ename)=upper('abc98');

Even we use index hint optimizer is still not using index.

1) table is analyzed as compute after creating index.
2) query rewrite is granted to user
3) query_rewrite_enabled=true.
4) optimzer mode is choose.
5) optimer should use index as there is no way full scan can be faster
than index in this case as i tried to create simple
index on ename and remove upper function from where clause of query..


What can be the possible reason that optimzer is not using index??

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Advice on going about a minor upgrade.

[Seefelt, Beth]

I did this exact upgrade a very short time ago, using Option1.  It
worked just fine.  I would add step (6a) install patches up to 8.1.7.3.,
after the database has moved to the new version.

I would stay away from Option2.  You have no fallback.



-Original Message-
Sent: Thursday, May 02, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L


Greetings fellow-DBAs,

We have a web application which exists on a Windows/NT 4 box running
Oracle
Standard Server 8.1.6.  A new application to be added to that platform
needs
Oracle 8.1.7 (They've even specified needing Patch Set  8.1.7.2.1 and
ODBC
driver 8.01.74.00).

I have just ordered the Oracle 8.1.7 Server for Windows NT and would
like to
ask what you think in terms of direction I should take for the upgrade.

Here is my plan:
(1) Have the NT System Administrator back up the entire system
(2) Take a full export of the existing database

Either Option1:
(3a) Install Oracle 8.1.7
(4a) Build the database from scratch
(5a) Import the full export from #2

Or Option 2:
(3b) Deinstall Oracle 8.1.6
(4b) Install Oracle 8.1.7
(5b) Build the database from scratch
(6b) Import the full export from #2

Or Option 3:
(3c) Install Oracle 8.1.7
(4c) Migrate the existing database.

Any pros, cons, or suggestions with respect to what I've laid out here?

As always, thank you very much in advance for all the sound advice
you've
historically offered.

Jim Damiano


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Damiano
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Database Normalization-Outdated?

[Seefelt, Beth]

I agree whole-heartedly.  Besides, what that consultant is describing is
just the logical view of x.500, LDAP or something like it.  Its how you
logically view that type of database.  If you look at most LDAP
products, the internal structure of the database is relational and
highly normalized.  That logical view is presented through rigid RI,
triggers and stored procedures to make data retrieval very fast and
simple for a very specific type of application.


-Original Message-
Sent: Wednesday, May 01, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L


List-

My Opinion:

The purpose of Normalization is to reduce redundant storage. It is a
trade 
off between affording redundancy(as far as you can?)and avoiding to many

joins later. It can not be true accross the board. Designers should go
by 
the merit/requirements of the application. If database is normalized as
and 
where it is possible(i.e. up to Boyce-Codd Normal Form); it might become
a 
nightmare while trying to run BUSINESS OBJECTS/COGNOS/etc against it. As

Hanna just mentioned joining 17 tables. AT my present work place I am 
dealing with a db which is so poorly designed. Now to be able to support

BUSINESS OBJECT the developers are kind of taking band aid approach -
asking 
for denormalizing the db tables with so called WORK TABLES - It is
serving 
two purposes, saving them from coding nightmares and improving apps 
performance.

As far as RI is concerned I have seen in places they do not use RI
rather 
loves to maintain data integrity by using triggers. My opinion on this -

This is more of a preference than to do with any technicality.
I am for RI.

Shaibal


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Database Normalization-Outdated?
Date: Wed, 01 May 2002 04:03:29 -0800



_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaibal Talukder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SIMPLE QUESTION

[Seefelt, Beth]

Switch the logfile location to another directory using 'lsnrctl set
log_directory', rename the old log, switch the destination back.



-Original Message-
Sent: Wednesday, May 01, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


HI AGAIN,

JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY
TO
RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING
BY
ORACLE.
HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR
NOT?
THANKS FOR HELP.




Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement
=== 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement
=  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ITS THE PHB, STOOOOPID (was: anti-virus spam)

[Seefelt, Beth]

Hmmm, I'm guessing you're a student at csus and not a professional
there.  Grow up.


-Original Message-
Sent: Wednesday, May 01, 2002 4:42 PM
To: Multiple recipients of list ORACLE-L


It is kind of amazing how irrelevant and lacking in substance this 
discussion is.

It has been explained that the original offender's email server was 
configured in *stupid mode* because of damagement, not because of 
the techies.

fyi: PHB = pointed headed boss

( http://kltp.kldp.org/eunjea/jargon/?idx=PHB ) 


to clarify: it is a complete outrage that an email server is set up 
to barf out a whole screen full of worthless, erroneous and time 
wasting virus warning messages back to a message sender *MONTHS* 
(almost a *YEAR*?) after a text attachment has been sent to the 
list.

certainly the above situation qualifies for the WHAT THE F* award 
of the week, doesn't it?

certainly the list owner's attention ought to be brought to bear on 
whether or not a subscriber ought to be allowed to remain if their 
system is generating such a huge pile of unwanted fecal material, 
and certainly consideration should be given to pressuring the email 
admin, or other f*ing d*kheads in positions of respoinsibility at 
said subscriber's corporation/organization into reversing their 
f*ing stupid email configuration policy, no?

presumably an expression of outrage at the f*ing stupidity of said 
f*ing email server configuration would tend to put the issue on 
someones f*ing radar screen more than some polite request that 
everyone ignores?

anyways, Tim was wrong in thinking that I was insulting fatcity's 
email admin.

Tim's observations about language and tone were irrelevant and 
lacking in substance, and frankly, regardless of Tim's many other 
undoubtedly great/vast/endless virtues, culinary or not, I don't 
care about such ninny-like posturing and false rectitude anyway, so 
his advice was completely wasted on me.

I'm sure everyone was infinitely amused and entertained by your 
story of being fooled into eating a dead animals' testicles 
(apparently that topic wasn't covered in 5th grade).

regards,
ep


ORACLE-L Digest -- Volume 2002, Number 121
 --
 
  From: Mogens =?ISO-8859-1?Q?N=F8rgaard?= [EMAIL PROTECTED]
  Date: Tue, 30 Apr 2002 18:17:09 +0200
  Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD
 
 --030707020805030006050203
 Content-Type: text/plain; charset=us-ascii; format=flowed
 Content-Transfer-Encoding: 7bit
 
 Sigh. I wish I understood half the words used in this exchange. Or
maybe
 not. But I still think Tim is a cool guy and I'm looking forward to
 drinking beer with him next time we meet. The first time I met with
Tim
 was in Denver where he tricked me into eating  something he called
Rocky
 Mountain Oysters. If he ever makes it to Denmark I'll trick him into
 eating our world-famous blood sausage.
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Curious question about flushing the Pool

[Seefelt, Beth]

Oh, you have no idea.  I could show you code that would make your hair
stand on end.  The manager of that department believes in working in a
complete vacuum, and there is so much custom and undocumented code here,
the management above him is terrified of ticking him off.  It used to
frustrate me, but after a few years now, its just kind of comical to sit
back and watch the whole situation.

-Original Message-
Sent: Friday, April 26, 2002 9:18 AM
To: [EMAIL PROTECTED]; Seefelt, Beth



 That its not as easy as just using embedded sql.  

That kind of duhveloper should quit immediately and
get a job in sales or damagement, since they aren't
interested in doing anything properly.

That kind likes to see the glitter on the screen and 
cares little about what goes on behind the scenes.

Jared

On Thursday 25 April 2002 14:08, Seefelt, Beth wrote:
 Greg,

 That its not as easy as just using embedded sql.  I don't agree, it
 takes just a little bit more thought and a couple extra lines of code
 per call, but I lost that battle...


 -Original Message-
 Sent: Thursday, April 25, 2002 4:40 PM
 To: Multiple recipients of list ORACLE-L


 Beth,

 What reasons do your programmers give for not wanting to use bind
 variables?

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, April 25, 2002 8:43 AM



 Wow, I think that's a brilliant idea.  It would be a huge benefit to
me,
 where all of our code is VB, and the developers refuse to use bind
 variables.  My sql area is .5 GB and is 95% garbage.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Which Server Machine?

[Seefelt, Beth]

IMHO, I would never opt for only 1 cpu.  There should be at least 2, if
you are going to be using parallel query, then 4 cpus.  After 4, on many
platforms, there is diminshing return on investment.  That's my rule of
thumb, and I have nothing to base it on but gut feeling.

HTH,

Beth

-Original Message-
Sent: Thursday, April 25, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L


Hi,

What should be the basis of selecting a type of server machine? Single
processor, two processor, four processor
How many years down the road should one plan for?

In web deployment, the web server will have connection(s) with data
server
and can be configured for connection sharing. What role the number of
connections between data and web server plays in server selection?

Please do give some solid guidelines.

TIA!

Aleem
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).