RE: DECODE AND SELECT

2003-07-11 Thread Kevin Lange
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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Recommended Init File for Standby

2003-07-11 Thread Kevin Lange
he official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

RE: Recommended Init File for Standby

2003-07-11 Thread Kevin Lange
racle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Recommended Init File for Standby

2003-07-11 Thread Kevin Lange
ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange 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

RE: Space Remaining in Current Extent - Done

2003-05-29 Thread Kevin Lange
de 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: Kevin Lange INET: [EMAIL PROTECTE

RE: Space Remaining in Current Extent

2003-05-27 Thread Kevin Lange
asked to find out, down to the byte, how much free space is available . on the fly (which means not only after every analyze) Any suggestions ??? I am sure Oracle has a table with the information somewhere . Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.ne

Space Remaining in Current Extent

2003-05-27 Thread Kevin Lange
. on the fly (which means not only after every analyze) Any suggestions ??? I am sure Oracle has a table with the information somewhere . Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network

RE: sort ip addresses

2003-03-25 Thread Kevin Lange
-- 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

RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database instan

2003-03-24 Thread Kevin Lange
We just went 8.0.5 to 8.1.7 and the instructions explicitly said to NOT apply logs from the 8.0.5 on the 8.1.7.   Not sure on the 9.2.0. -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 2:24 PMTo: Multiple recipients of list ORACLE-LSu

RE: Job Needed

2003-03-18 Thread Kevin Lange
-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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Corrected SQL Question...

2003-03-13 Thread Kevin Lange
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- M

RE: BMC Patrol

2003-03-12 Thread Kevin Lange
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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Rollback Segments on 8.1.7.4

2003-03-11 Thread Kevin Lange
dropped and recreated or upgraded inline? -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Kevin Lange wrote: >Even

RE: Rollback Segments on 8.1.7.4

2003-03-11 Thread Kevin Lange
nks > > Kevin > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Kevin Lange > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting s

Rollback Segments on 8.1.7.4

2003-03-10 Thread Kevin Lange
has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: nt script

2003-03-07 Thread Kevin Lange
Title: RE: nt script If you just do a HELP COMMAND, where command is the name of the command you need help on, you can find out as much as you really need to know about BATCH.   In your sample of  FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B They were trying to set a variable ca

Another Question on Authority and Security

2003-03-05 Thread Kevin Lange
Title: RE: Question related to security Given:   User_A Owns procedure 'MY_PROCEDURE'.   User_B originally compiles procedure ''USER_A.MY_PROCEDURE", thereby allowing 'MY_PROCEDURE" to be able to do whatever User_B can.   User_C recompiles "USER_A.MY_PROCEDURE"  by issuing the "ALTER PROCE

RE: Big SGA.......

2003-03-04 Thread Kevin Lange
...  large burlap sack and a small bat -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 7:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Big SGA... duct tape -Original Message-From: Tim Go

RE: db create with DBCA and scripts

2003-03-03 Thread Kevin Lange
he 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: Kevin Lange INET: [EMAIL

RE: AIX question

2003-02-21 Thread Kevin Lange
- 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 s

RE: AIX question

2003-02-21 Thread Kevin Lange
Title: AIX question Lisa;   Here is a set of 3 scripts that I used to map our disks on an IBM S70a with a large SSA Disk set that used the AIX Logical Disk Manager.  You might be able to glean all the commands from the scripts or just use them yourself if they work on your system.  The

RE: GRRRRR OWS

2003-02-19 Thread Kevin Lange
Title: Message I had a meeting once with the VP in charge of support for the south when I worked for my last job in Texas.  We had been having major support problems with Oracle and were tired of paying such high prices for crap.   One of the things he told me was that you can always tell th

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Kevin Lange
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: Kevin Lange INET: [EMAIL PROTEC

RE: Send Mail in Unix

2003-02-13 Thread Kevin Lange
on (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: Borderline OT - Unix for Oracle at home

2003-01-30 Thread Kevin Lange
Definitely use SUN equipment if you use Solaris.   Way too many questions and problems on the Solaris message boards related to getting Intel hardware to work right with solaris.   Ugly. -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2

RE: Borderline OT - Unix for Oracle at home

2003-01-30 Thread Kevin Lange
Hey Dan;   I currently am running a Sun Sparc 20 at home with oracle 8.1.7.4 and am adding 9.0.2.   I got mine off of e-bay as you were talking about.     The Sun software was prety easy to load and configure so far.  I have a DSL setup and its working just fine.  I can even get to the DB

RE: Base conversion

2003-01-28 Thread Kevin Lange
you've guessed, the deadline is yesterday :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: strange SQL with TOAD

2003-01-14 Thread Kevin Lange
n 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: Kevin Lange INET: [EMAI

RE: Some of you may find this useful

2003-01-10 Thread Kevin Lange
d 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: Kevin Lange INET: [EM

RE: Orawomen

2003-01-08 Thread Kevin Lange
] (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.

RE: Orawomen

2003-01-08 Thread Kevin Lange
Title: RE: Orawomen April, I could tell back when I was in 8th grade that the Teaching System in Texas was a joke.   I moved from Missouri to Texas that year and went from a math class where we were doing geometry, trig, and algebra to a math class where they were teaching the Metric System.

RE: ora -1002

2003-01-07 Thread Kevin Lange
moved 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: SavePoint doubts

2003-01-03 Thread Kevin Lange
  No. -Original Message-From: Shishir Kumar Mishra [mailto:[EMAIL PROTECTED]]Sent: Friday, January 03, 2003 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: SavePoint doubts Hi List, One dumb question  I want to ask is :   Is it possible to declare Savepoint w

RE: strange issue with setting transaction

2003-01-03 Thread Kevin Lange
RACLE-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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services

RE: Automatic backup on Oracle 9i -- For Jared

2003-01-02 Thread Kevin Lange
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://

RE: doubt

2003-01-02 Thread Kevin Lange
Excuse the heresy for answering an SS question on this list.   When I first read that statement I was wondering why you would be asking a question about the Nazi SS on an Oracle List .  then it dawned on me that you were talking about Microsoft SQL Server ...  at which point it did

RE: ORA-1410 Silliness

2002-12-31 Thread Kevin Lange
= vegas_raw_rec.id;   Makes no sense at all.  And if you read this far, don't say I didn't warn you.     -----Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: R

RE: ORA-1410 Silliness

2002-12-31 Thread Kevin Lange
Title: ORA-1410 Silliness How about posting the table structure and the lines around 1970 in the Elvis package. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-141

RE: Versioning the Database !

2002-12-27 Thread Kevin Lange
d 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: Kevin Lange INET: [EMAI

RE: Those Pesky Little Audit Files (ora_99999.aud)

2002-12-27 Thread Kevin Lange
Thanks. Guess its clean-up job time. -Original Message- Sent: Thursday, December 26, 2002 7:59 PM To: Multiple recipients of list ORACLE-L IIRC, these files are generated whenever someone logs in as sysdba or internal. I don't know of any way to stop them. --- Kevin Lange &l

Those Pesky Little Audit Files (ora_99999.aud)

2002-12-26 Thread Kevin Lange
to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: compile errors

2002-12-26 Thread Kevin Lange
ling 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.n

RE: compile errors

2002-12-26 Thread Kevin Lange
ing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: Happy Holidays

2002-12-19 Thread Kevin Lange
ease 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 ---

API for TNSPING

2002-12-19 Thread Kevin Lange
FAQ: http://www.orafaq.net -- Author: Kevin Lange 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 th

RE: kinda OT: veritas netbackup

2002-12-19 Thread Kevin Lange
.   Brian Spears   -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: kinda OT: veritas netbackup How about running a script just before the backup that   1) Reads the

RE: kinda OT: veritas netbackup

2002-12-19 Thread Kevin Lange
How about running a script just before the backup that   1) Reads the current log number.   2) Forces a log switch.   3) Copies the logs to a seperate directory.   4) Backups up that seperate directory   Leave the archive directory alone.  Do not back it up. -Original Message-Fr

RE: Methods to get DDL

2002-12-18 Thread Kevin Lange
;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

RE: Sun Solaris

2002-12-16 Thread Kevin Lange
he 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: Kevin Lange INET: [EMA

RE: archiving redo logs

2002-12-10 Thread Kevin Lange
Title: RE: Oracle 9i installation - Basic Qs - HELP! Well, one of us is probably wrong not sure which.  But, I thought that , as long as the file structures are the same that there should not be any difference in an archive log for one OS over another.   Since you are coming from Solaris

RE: archiving redo logs

2002-12-10 Thread Kevin Lange
Title: RE: Oracle 9i installation - Basic Qs - HELP! And what is the problem with having a standby DB on a different OS than the primary ???   -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 2:06 PMTo: Multiple recipients of li

RE: Help Urgent Where is Tablespace Manager??

2002-12-10 Thread Kevin Lange
Title: RE: Help Urgent Where is Tablespace Manager?? OEM had the tablesapce manager in it.  Its called the Storage Manager now.  Maybe that is where the mixup is ?   Run oemapp by itself.  It will tell you which applications are loaded.  If you have loaded it, you should see STORAGE in the l

RE: To_Number

2002-12-05 Thread Kevin Lange
Title: RE: To_Number Lisa;   I wonder if it depends on the DB version.   I did this on an 8.0.5 and got the invalid number error running the exact query that succeeded on yours.  I had to do a replace on both the commas and the dollar sign. -Original Message-From: Koivu, Lisa [

RE: To_Number

2002-12-05 Thread Kevin Lange
Title: To_Number I believe its the $ and , in the data.   I got the same error until I did   select to_number(replace(replace(unit_cost,'$',''),',','')) from elas.qdr -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 1:24 PMTo: Mu

RE:

2002-11-25 Thread Kevin Lange
bing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Identifying indexes

2002-11-22 Thread Kevin Lange
mation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Identifying indexes

2002-11-22 Thread Kevin Lange
cial ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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 you

RE: Ltrim?

2002-11-22 Thread Kevin Lange
nformation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: catrepad - how tell if run

2002-11-15 Thread Kevin Lange
B 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Urgent : Shell Script is needed !!!!!

2002-11-14 Thread Kevin Lange
Title: Blank Madhu   Three years ago we wrote a system that would except files from an outside data system, take those files and , in a rotating 18 month cycle, load the data into a partitioned view dropping the oldest set of data and adding the next set in its place.   Ifs complicated,

RE: AIX vs Solaris

2002-11-13 Thread Kevin Lange
cial ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: RE: Oracle DBA with SAP Needed

2002-11-06 Thread Kevin Lange
-- 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

RE: Oracle to Excel

2002-11-06 Thread Kevin Lange
02-11-06 at 13:12, Kevin Lange wrote: Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file.  Then import the file into a spreadsheet.   If you have it, Toad will save data into spreadsheets for you. -Ori

RE: Oracle to Excel

2002-11-06 Thread Kevin Lange
Title: Oracle to Excel Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file.  Then import the file into a spreadsheet.   If you have it, Toad will save data into spreadsheets for you. -Original Message-From: Burton, Laura

RE: SQL Brain Teaser Challenge

2002-11-05 Thread Kevin Lange
t;>>>>>>>>>>>>>>>>>>>> >>>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Serv

RE: End of Communication Channel Error

2002-11-01 Thread Kevin Lange
nks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Dbf Files, Mount Points and Oracle 7

2002-11-01 Thread Kevin Lange
ACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOV

End of Communication Channel Error

2002-11-01 Thread Kevin Lange
st just in case anyone had any insight. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Kevin Lange
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mai

RE: Error ORA-12638 Credential Retrieval Failed During DB Creatio

2002-10-25 Thread Kevin Lange
ng 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fat

RE: Error ORA-12638 Credential Retrieval Failed During DB Creatio

2002-10-25 Thread Kevin Lange
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: DB monitoring using SNMP MIBs

2002-10-24 Thread Kevin Lange
= Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califo

RE: secure connection

2002-10-24 Thread Kevin Lange
ing: 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: Kevin Lange INET: [EMAIL PROTECT

RE: Flat file generation integrity ideas...

2002-10-24 Thread Kevin Lange
Title: Flat file generation integrity ideas... Chris;   I would suggest the following:   1. Generating Check Sums of the files before they are sent.   2. Send the files.   3. Generating an after Check Sum and compare.   Here are the steps I go thru to make sure our Oracle Archive Logs are c

RE: Flat file generation integrity ideas...

2002-10-24 Thread Kevin Lange
Title: Message Trouble with this is that there is a possibility that a change in the number in the file could result in the same sum.   Then you have different data but your checks says everything is ok.     Checksums are far more accurate. -Original Message-From: Grabowy, Chris

RE: DB monitoring using SNMP MIBs

2002-10-24 Thread Kevin Lange
ine 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: Kevin Lange INET: [EMAIL PROTECTED] Fa

RE: DB monitoring using SNMP MIBs

2002-10-23 Thread Kevin Lange
Title: RE: DB monitoring using SNMP MIBs Yes.  You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP:   #!/usr/local/bin/perl   use BER;   use SNMP_Session;use SNMP_util;use Getopt::Std;   getopts("h:i:");   my($host, $

RE: Theory v Practice

2002-10-23 Thread Kevin Lange
ACT 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 offici

RE: Rollback segment space usage

2002-10-23 Thread Kevin Lange
ODY, 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: Kevin Lange INET: [EMAIL PROTECT

RE: oracle or mssql

2002-10-23 Thread Kevin Lange
st, 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 subscribin

RE: OEM can't seem to discover 1 instance

2002-10-17 Thread Kevin Lange
vices - 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

RE: SNP acronym?

2002-10-17 Thread Kevin Lange
Title: SNP acronym? Snapshot Refresh Processes.  -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 4:29 PMTo: Multiple recipients of list ORACLE-LSubject: SNP acronym? What does the background job queue acronym SNP stan

RE: OEM can't seem to discover 1 instance

2002-10-17 Thread Kevin Lange
'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). -- Ple

RE: kill session

2002-10-17 Thread Kevin Lange
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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www

RE: HP-UX11/Oracle 8.1.6/Constraint Question

2002-10-17 Thread Kevin Lange
formation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: Elementary question about triggers

2002-10-14 Thread Kevin Lange
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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cali

RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..

2002-10-14 Thread Kevin Lange
Dpeneding on the state of course .   at least here in Texas there is not (currently) state income tax. -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle 8i

RE: Re: Shell scripting

2002-10-08 Thread Kevin Lange
emember what it was called. This is what I was describing in my previous email. Jared Kevin Lange <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/08/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:

RE: Re: Shell scripting

2002-10-08 Thread Kevin Lange
lid > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 > >http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting > >services > >--

RE: SQL and case structure

2002-10-07 Thread Kevin Lange
f 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 inform

RE: rollback_segment who is using?

2002-10-04 Thread Kevin Lange
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: svrmgrl echo v$database in script

2002-10-03 Thread Kevin Lange
-- 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 c

RE: Restrict certain database access using 3rd party tools.

2002-10-03 Thread Kevin Lange
x27;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: K

RE: Selecting Next X Values From Dual

2002-09-27 Thread Kevin Lange
bscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing lis

RE: Apologies for Off-Topic Question - Where has Oracle-l-OT gone

2002-09-19 Thread Kevin Lange
Its still out there on Yahoo Groups. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 19, 2002 7:18 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies for Off-Topic Question - Where has Oracle-l-OT gone ?Has the Off-T

RE: Staspack Grapher/Viewer ?

2002-09-19 Thread Kevin Lange
7;) 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: Kevin Lange IN

RE: Listener load balance

2002-09-18 Thread Kevin Lange
ROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526))   ---> Added   Ramon   - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03

RE: backup controlfile to trace

2002-09-17 Thread Kevin Lange
ing: 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services

RE: Listener load balance

2002-09-17 Thread Kevin Lange
Your HOSTNAME of 'myserver' would tell you which.   Since you have the same hostname on the listener, both ports would currently be using the same IP address.   Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTEC

RE: RBO/CBO question

2002-09-11 Thread Kevin Lange
. You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

  1   2   3   4   5   >