Re: Test mesg

JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re[2]: IMP using the same DMP file

://www.orafaq.net -- Author: Robert Eskridge 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: How to add ' (comma) at the begining and end of each line? Either Unix or Windows

://www.orafaq.net -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: Cary's Book - new topic

ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: Physical I/O and databases other than oracle

, there's no reason to poke fun at me -rje [oh and here's the :-) ] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re[4]: DB2 has a foot in the door

Hey, how come my butterfly ballot has a staple in it's navel!?!?? M Nope, that's what voting machines are invented for. M They work almost perfectly in almost every state. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED

Re: GREAT SCOTT!! 1.21 GIGAWATTS!!

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: dba age

://www.orafaq.net -- Author: Robert Eskridge 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

Re[2]: dba age

of an experienced oracle dba ? P -ak -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re[2]: dba age

and in some special archetectures with 286's. I hadn't relived that nightmare in many years. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re[2]: Recent reports on outages caused by DB2 and 9iRAC issues

this time it ISN'T me -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: (solved?) cannot disable or drop the ON DATABASE trigger !

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: utl_smtp error

the official ORACLE-L FAQ: http://www.orafaq.net -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

OT: sar on Solaris 9

that line for me? Thanks, -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: Know 1 database, know them all?

Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[4]: Know 1 database, know them all?

then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network

Re: Send Mail in Unix

| uuencode spreadsheet.xls | mail \ [EMAIL PROTECTED] -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: OT: Cron not working

was scheduled on 11:40, however job wasn't executed. VB How do I see whether cron is running or not? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re[2]: awk and ksh question - solved

$PAGER $$.log KL done -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[4]: awk and ksh question - solved

-- S In a lot of companies, if a DBA managed to get into this file, the DBA would S have a short career there. Those are the companies that you'd use the $HOME/.mailrc for. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat

Re: awk and ksh question

for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)}; K do K print $PAGER K done -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: awk and ksh question

it and the script no longer works. Like this K -- K export FILE=$1 K print File is $FILE K for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)}; K do K print $PAGER K done -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL

Re: SQL Net connection.

? Assuming you are connecting TCP, I'd be shocked if it didn't stay alive -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re[2]: Americas Cup

in the modern yachts are running SQL Server. G Larry couldn't have won with a software like that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: BCHR Tuning

So, I have undone all the changes I made and will begin looking at other F methods to improve performance! -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: BCHR Tuning

undone all the changes I made and will begin looking at other F methods to improve performance! -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Metalink and HTML (GRRRRR!)

that'll read that article properly because it's a Microslop-only J webpage! GR! | -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re[2]: Automatic backup on Oracle 9i -- For Jared

. I guess I should have taken the class -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: ORA-1410 Silliness

your mailers auto-reply :-) -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: API for TNSPING

program that logs on and reports the results could give what you want. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re[2]: OT: OS/2 is officially dead as of Dec 10, 2002

/2 I wonder. B http://www.pcmag.com/article2/0,4149,767456,00.asp BPJ The reports of OS/2's death are somewhat exaggerated: BPJ http://www.russharvey.bc.ca/rhc/os2/ecs.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat

Re: OT: OS/2 is officially dead as of Dec 10, 2002

: Robert Eskridge 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

Re[2]: Semi-OT: Pics from OracleWorld

web page -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re[2]: Anyone else had a Virus alert for Stephane Faroult's email ?

the list ... S If anybody has any hint about how to check for viruses on a Linux S machine, BTW ... S -- S Regards, S Stephane Faroult S Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services

Re[2]: Ltrim?

-- Author: Robert Eskridge 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

Re: DROP DEVELOPER not working

R Raj R -- R Please see the official ORACLE-L FAQ: http://www.orafaq.com -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re[2]: Oracle and NAS (more Q's)

rewrite unless it is a member of a snapshot. Thus while reserving BL unlinked blocks is inefficient from a storage perspective, it is a BL factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET

Re[2]: Oracle and NAS storage systems

it is a member of a snapshot. Thus while reserving R unlinked blocks is inefficient from a storage perspective, it is a R factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City

Re: OT - a good list for UNIX (Solaris) system administration topics

? A I'm also interested in other sources of knowledge for UNIX sysadmin-ism - A URLs , papers etc... A Please share your knowledge ! A Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network

Re[2]: So, What is a 'Production DBA'?

FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: ORA_ENCRYPT_LOGIN

a trivial session before you turn the trace off. -rje R Anyone using this and if so, do you know of a way to verify that the R password is actually being encrypted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network

Re[4]: Oracle wants your job

J Good points all. J Reminds me of Larry E's statement last year that businesses J should be run the way the software works: no customizations. J Can you see why he said that? :) J Oracle corp knows best. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert

Re[2]: data cleansing question

environment here, I want to say it's LK VSAM, there definately is no database. It is so old, it's the type of LK mainframe where everything is on TAPE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services

Re[2]: Number of CPUs vs. Speed of CPUs

. It was replaced by the per cpu pricing. If you had SE on a RISC processor at 666MHz the pricing stayed the same, if your processors are slower it got more expensive, with faster processors you got a bargain. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert

Re[2]: SQL Tuning - How to avoid TOCHAR function against a date

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[2]: Fav. Urban Legend...Mem vs Disk

) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Another partitioning question

; -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[2]: Strangeness

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[2]: Secret maximum for INITRANS?

size? Ours is 2k (which I RE figure is part of the problem). RE Other vital stats: 8.0.5 on Solaris 2.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Secret maximum for INITRANS?

on block size? Ours is 2k (which I figure is part of the problem). Other vital stats: 8.0.5 on Solaris 2.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Tracing sequences (was re: freelist tesing)

discrepancies in the select/insert and sessions that were trying to insert without actually making the select. Has anyone tried this level of tracing/logging before? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network

Re[4]: address parse

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: How to restart SNMP daemon process

be run with either a start or a stop parameter. Of course you can look inside the rc start script and see exactly what commands it uses to start the daemon and do it yourself. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED

Re: address parse

S Anybody already have an address string parser (plsql) already written that S they would care to share? Address? IP? Internet mail? USPS? Memory address? URL? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City

Re[2]: address parse

Shaw, S street address How is it formatted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re[2]: address parse

ORACLE-L S Anybody already have an address string parser (plsql) already written S that S they would care to share? S Address? IP? Internet mail? USPS? Memory address? URL? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL

Re: MIGRATION

to another Data g center.Let me know what precausion should I take care please? g Thx g -Guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re[2]: MIGRATION

don't have much time g to take cold backup also.I think if Can take cold backup on another disk g partition would be fine. g Any suggestion please? g Thx g guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network

Re[2]: ftp from unix session to your local harddrive-How?

the other way C round.) C I hope I am making myself clear. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: testing freelists

problems, at least in my experience. It will certainly help you develop insight and intuition as to what is going on with your database though. HTH Jared Robert Eskridge [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/02 08:15 PM Please respond to ORACLE-L

Re: The use of schemas

Has anyone seen such a approach? And what's the benefit of doing so? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re[2]: Screen

S:screen, sex, skiing, sleep, sushi Snip Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

testing freelists

the situation. Any suggestions? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[2]: SQL Injection and Oracle?

. Limited fields and some javascript pre-processing. But now I've got some concerns about what our developers have done in our big app. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858

SQL Injection and Oracle?

Server centric. But in my quick reads, I didn't see anything that made me think it would not work against many HTML forms backed by CGI scripts hitting Oracle databases that I've seen. Am I missing something? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert

Re[2]: TOAD Software???

Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

re: Procom NetForce

anymore. The ProCom NetForce is certainly listed there. http://otn.oracle.com/deploy/availability/htdocs/oscp_papers.html So, has anyone seen a features comparison between NetApp and NetForce? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET

Re[2]: using Net8 through NAT router

ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Converting UPU Licenses

there would be an easy formula to convert UPU's to the new scheme within a week. Unfortunately I can't find that formula. Does anyone have it? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services

Re[2]: Converting UPU Licenses

bry UPU's to the new scheme within a week. Unfortunately I can't find bry that formula. Does anyone have it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re[2]: Network Appliance Options

it generally receives sporadic and light use. I am told that it D cost much less than conventional disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Network Appliance Options

. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[3]: Interesting News..

, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services

Re[2]: Yahoo!

accordingly) Here's how I hear it used: yahoo (yah'-who) - interjection, an exclamation of wild exuberance yahoo (yay'-who) - noun, a person of cloddish and ungenteel behavior, a dolt, a yokel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL

Re[2]: Q: Oracle Year End???

to confirm that May is Oracle's T fiscal year-end. Does anyone have any information regarding this? T I have also heard that May, being Oracles' year-end is the best month to T buy. Has anyone had experience with this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert