TOAD Login Problem

[kjanusz]

Oracle 9i (9.0.1) on XP Professional on DELL 8200.
TOAD VI freeware ver. 6.3.11.1g

I keep gettint this error when I try to connect to 9i:

Initialization error.
Could not locate OCI dll

I can connect using SQL*Plus with no problems.

Any idea as to what the problem is with TOAD?

Thanks much,
Ken Janusz, CPIM
-- 
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).

Re:Eval copy of 91

[kjanusz]

Dick:

I'm just going to use it as a learning tool. I looked 
into downloading the three zip files but it would have 
taken forever with my regular phone line connection.  
So, it was just easier to purchase the CD pack.

Ken
> Ken,
> 
> To Oracle's good and bad, no nothing will happen.  For a number of years now
> Oracle has allowed us (the user community) to experiment with their software for
> nothing as long as that tinkering only results in understanding of how the
> software works and it's potential applications.  Once you really start making
> use of it, they expect you to pay for it which is only fair.  Now in your case,
> if all your doing is tinkering/experimenting fine.  Start using it to track your
> collection of CD's and you owe someone.
> 
> Dick Goulet
> 
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   1/23/2002 7:15 PM
> 
> I have purchased an eval copy of 9i for my PC using XP 
> Prof.  The eval is for 30 days.  What happens at the 
> end of the eval period?  Does my PC melt, does the DB 
> lock up, or nothing?
> 
> TIA, 
> 
> Ken Janusz, CPIM
> -- 
> 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: 
>   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).

Re: Eval copy of 91

[kjanusz]

Joe:

I belong to OTN and tried that route.  But I only have 
a regular speed phone line and it would have taken 
about two weeks to download the three zip files.  So it 
was just easier to pay $39.95 plus shipping.  And I 
also get other tools and doc. in the CD Pack.

Ken
> Yes your PC melts down.
> 
> my question is why would you purchase an eval copy when you can join 
> technet and download the latest version and play with it to your heart's 
> content(single user developer license)?
> 
> 
> joe
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> > I have purchased an eval copy of 9i for my PC using XP 
> > Prof.  The eval is for 30 days.  What happens at the 
> > end of the eval period?  Does my PC melt, does the DB 
> > lock up, or nothing?
> > 
> > TIA, 
> > 
> > Ken Janusz, CPIM
> > 
> 
> 
> -- 
> Joe Testa, Oracle DBA
> Want to have a good time with a bunch of geeks? Check out:
> http://www.geekcruises.com/standard_interface/future_cruises.html
> I'm presenting, when registering drop my name :)
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joe Testa
>   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).

Eval copy of 91

[kjanusz]

I have purchased an eval copy of 9i for my PC using XP 
Prof.  The eval is for 30 days.  What happens at the 
end of the eval period?  Does my PC melt, does the DB 
lock up, or nothing?

TIA, 

Ken Janusz, CPIM
-- 
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).

OCP Study Materials - Your Opinion

[kjanusz]

I found both of these OCP study materials on Amazon.com 
and would like your opinion of them.

OCP: Oracle8i DBA Cert. Kit: Study Guide
by Chip Dawes
Book and CDROM
from Sybex

OCP: Oracle8i DBA Virtual Test Center
from Sybex

Your comments will be very helpful.

Thanks,
Ken Janusz, CPIM
-- 
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).

Re: OT RE: How do you audit a DBA?

[kjanusz]

Write a letter to the IRS stating that he did not report 
all his income last year.  They will be happy to audit 
him.

Ken Janusz, CPIM
> I think i see where this thread is going. 
> 
> You'd better audit change to the trigger that audits changes to the data
> that
> audits the DBA that you don't trust. 
> 
> Maybe throwing another trigger at it will help?
> 
> Maybe installing a 24x7 "DBA-cam" above his cube?
> 
> Maybe feeding him a higher grade of "DBA Food Pellets" would
>   cut down on theft?
> 
> Maybe regular sodium pentathol for lunch followed by "re-interviews"
>   on a weekly basis?
> 
> 
> 
> -Original Message-
> Sent: Thursday, August 23, 2001 12:52 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> you'd better audit changes to the trigger, and then changes to SYS.AUD$
> 
> otherwise the DBA could disable the trigger, make the changes and re-enable 
> it
> 
> 
> 
> 
> >From: Dave Leach <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: How do you audit a DBA?
> >Date: Thu, 23 Aug 2001 07:56:29 -0800
> >
> >Anyone who can help,
> >
> >I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if
> >the DBA were to execute DML statements against sensitive tables, this
> >assumes the DBA has the SYS password.  I thought this was a pretty
> >reasonable question but couldn't think of an answer.  My trail of though 
> >was
> >maybe an email alert to a designated member of staff sent via a trigger on
> >the table.
> >
> >Any comments would be very appreciated.
> >
> >Dave Leach
> >
> >
> >
> >
> >**
> >The above information is confidential to the addressee and may be
> >privileged.  Unauthorised access and use is prohibited.
> >
> >Internet communications are not secure and therefore this Company does
> >not accept legal responsibility for the contents of this message.
> >
> >If you are not the intended recipient, any disclosure, copying,
> >distribution or any action taken or omitted to be taken in reliance on
> >it, is prohibited and may be unlawful.
> >
> >Claybrook Computing Limited is a subsidiary of
> >Claybrook Computing (Holdings) Limited
> >Registered Office: Abbey House. 282 Farnborough Road, Farnborough,
> >Hampshire GU14 7NJ
> >Registered in England and Wales No 1287205
> >
> >A Hogg Robinson plc company
> >**
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Dave Leach
> >   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).
> 
> 
> _
> 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: Rachel Carmichael
>   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: Mohan, Ross
>   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
--

Re: OCP Test timeframe

[kjanusz]

I have not seen anything of a time frame for the OCP 
exams.  The only time frame is when the next release 
comes out and the previous release becomes obscolete.  I 
am APICS CPIM certified and APICS has a time limit of 
about 3 years (?).

Ken Janusz, CPIM
> Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 
> 8i track?  More specifically, from when the first test is taken, do you have to 
> complete the others in a specified amount of time, say within 1 year?
> 
> Thanks
> Traci
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Traci Rebman
>   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).

RE: How do they get the answer?

[kjanusz]

I want to thank everyone who gave me input on this 
question.  It was most helpful.

Ken Janusz, CPIM
> um, I can see possible answers to this question being 2 teachers, 3 teachers 
> or 4 teachers.
> 
> however, since that isn't one of the multiple choice answers, then it has to 
> be "at least 4" since "only 2" is wrong
> 
> 
> >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: How do they get the answer?
> >Date: Tue, 21 Aug 2001 09:27:46 -0800
> >
> >two subjects in the "in" clause, times at least two teachers per subject
> >equals at least four records updated.
> >
> >sometimes it is easier to eliminate answers first.
> >like, you can throw out d) syntax will occur. and b) all teachers will get
> >an increase.
> >you are then left with a) two teachers and c). at least four teachers.
> >
> >Since the "where" clause is looking at the 'subject_id' column, rather than
> >the 'teacher_id' column, you can almost guess that it is c).
> >
> >hope this helps.
> >
> >Tom Mercadante
> >Oracle Certified Professional
> >
> >
> >-Original Message-
> >Sent: Tuesday, August 21, 2001 12:26 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I am taking the Self-Test software test for the SQL exam
> >and don't see how they get the answer to this problem.
> >They don't explain how it is arrived at.
> >
> >Any help you can give me will be appreciated.
> >
> >Thanks,
> >Ken Janusz, CPIM
> >
> >--
> >
> >Examine the structure of the TEACHER table:
> >
> >Name Null?   Type
> >ID   NOT NULLNUMBER(9)
> >SALARY   NUMBER
> >(7,2)
> >SUBJECT_ID   NOT NULLNUMBER(3)
> >SUBJECT_DESCRIPTION  VARCHAR2(2)
> >
> >There are 200 teachers and 15 subjects.  Each subject is
> >taught
> >by at least 2 teachers.
> >
> >Evaluate this PL/SQL block:
> >
> >DECLARE
> > v_pct_raise number := 1.10;
> >BEGIN
> > UPDATE  teacher
> > SET salary = salary * 1.10
> > WHERE   subject_id IN (102, 105);
> > COMMIT;
> >END;
> >
> >Which result will the PL/SQL block provide?
> >
> >(A) Only two teachers will receive a 10% salary increase.
> >(B) All of the teachers will receive a 10% salary
> >increase.
> >(C) At least four teachers will receive a 10% salary
> >increase.
> >(D) A syntax error will occur.
> >
> >Answer:
> >(C)
> >
> >
> >--
> >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: 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).
> 
> 
> _
> 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: Rachel Carmichael
>   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 

DB2 Question

[kjanusz]

Does DB2 store data as EBCDIC or ASCII?

Thanks,
Ken Janusz, CPIM
-- 
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).

How do they get the answer?

[kjanusz]

I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.

Any help you can give me will be appreciated.

Thanks,
Ken Janusz, CPIM

--

Examine the structure of the TEACHER table:

NameNull?   Type
ID  NOT NULLNUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID  NOT NULLNUMBER(3)
SUBJECT_DESCRIPTION VARCHAR2(2)

There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.

Evaluate this PL/SQL block:

DECLARE
v_pct_raise number := 1.10;
BEGIN
UPDATE  teacher
SET salary = salary * 1.10
WHERE   subject_id IN (102, 105);
COMMIT;
END;

Which result will the PL/SQL block provide?

(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.

Answer:
(C) 


-- 
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).

Re: Converting EBCDIC to ASCII

[kjanusz]

Thanks for the help.  Oracle will be located on a W/2000 
box.

Could you go into more detail on how one "exports" data 
from IMS on the mainframe to flat textfiles?

Thanks,
Ken  
> 
> > 
> > If you "export" the IMS data out to flat textfiles,
> > and then transfer them via ftp in "ASCII" mode, the
> > conversion will be done automagically for you.
> > 
> > Alternatively if on Unix the "dd" utility will
> > do the conversion for you.
> 
> 
> One problem that we encountered with using dd to convert EBCDIC to
> ASCII (in a completely different situation so it might not apply here)
> is that brackets came out as the characters having octal values 342
> and 343 in ASCII.
> 
> 
> Pat
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Pat Hildebrand
>   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).

Re: Converting EBCDIC to ASCII

[kjanusz]

Thanks for the help. How did you create the flat files?  
How did you get the data out of IMS and into the flat 
files?  TCP/IP or SQL Loader or what?

Thanks,
Ken
> 
> I did it by creating flat files containing only character data (no packed
> fields),
> and using sqlloader to load the data.
> 
> I think the only thing Oracle didn't know how to convert was the verticle bar
> ( | )
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mike J Kurth
>   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).

RE: Converting EBCDIC to ASCII

[kjanusz]

Thanks for the information. How does your mainframe guy 
get the data out of IMS?

Thanks,
Ken
> We do not pull data directly from IMS but load it in batch jobs.  Our
> mainframe guy either dumps the data report-style (ASCII) or copies records
> in native EBCDIC to files on the mainframe.  We ftp them to the Oracle side
> (binary mode to EBCDIC files) and use sql loader to move into Oracle.  On
> the files that come over in EBCDIC, I use sqlloader with the following in
> the control file.  There are a few bugs with loading EBCDIC (search
> metalink)  but we manage to get it loaded.
> 
> 
> 
> LOAD DATA
> CHARACTERSET WE8EBCDIC500
> INFILE 'e:\filename.dat' "fix 688" 
> ...
> 
> 
> 
> 
> 
> -Original Message-
> Sent: Friday, August 17, 2001 9:37 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I may be moving data from an IMS db which is stored in 
> EBCDIC.  Oracle stores data in ASCII format.  How do I 
> go about converting EBCDIC to ASCII to store the data in 
> Oracle (8.1.?)?
> 
> Thanks,
> Ken Janusz, CPIM
> -- 
> 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: Bond Mike A Contr OC-ALC/TILC
>   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).

Re: OT: DBA tasks

[kjanusz]

Angelina:

Do you know if your can setup your TIVO box so that it 
can automatically ignore commercials when recording?  
If, so how do you do that?

Thanks,
Ken Janusz, CPIM
> Ahem...  the female DBA's save the database, save the world, flatten the
> evil people with her well-tuned martial arts skills, swims in icy cold water
> without showing one goose pimple on her Barbie-proportioned body, impresses
> the Diet Coke guy, and then tells him "thanks but no thanks"
> 
> and skips through the commercials on her Tivo after such an eventful day.
> 
> Sorry, couldn't let this one go  There's a script in here waiting to
> come out but I'm playing with Perl and feel that Chris Bowes is better
> suited for this task :)
> 
> Lisa Koivu
> aka. Angelina Jolie.
> Ft. Lauderdale, FL, USA
> 
> 
> > -Original Message-
> > From:   Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, August 20, 2001 11:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: DBA tasks
> > 
> > And we do it in  30 minutes and still have time 
> > for commercials 
> > 
> >  
> > Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> > Doing linear scans over an associative array is like 
> >   trying to club someone to death with a loaded Uzi. 
> >  - Larry Wall (creator of Perl) 
> > 
> > 
> > > -Original Message- 
> > > From: Guy Hammond [ ] 
> > > Sent: Monday, August 20, 2001 11:22 AM 
> > > To: Multiple recipients of list ORACLE-L 
> > > Subject: RE: DBA tasks 
> > > 
> > > 
> > > We find the treasure, kill the bad guys, save the world and get the 
> > > girl. 
> > > 
> > > I think that about covers it :0) 
> > > 
> > > g 
> > > 
> > > 
> > > -Original Message- 
> > > Sent: Friday, August 17, 2001 7:56 PM 
> > > To: Multiple recipients of list ORACLE-L 
> > > 
> > > 
> > > 
> > > Hi... 
> > > 
> > > I'am searching for a oracle dba task guide. A doc that 
> > > especifi all the 
> > > task 
> > > of a oracle dba. 
> > > 
> > > javs 
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ:  
> > > -- 
> > > Author: Jairo Villalobos 
> > >   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:  
> > > -- 
> > > Author: Guy Hammond 
> > >   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).

ColdFusion

[kjanusz]

Would like to know if implementing ColdFusion has 
any "gotchas"?  Also, any problems with the day-to-day 
administration of ColdFusion?

Thanks,
Ken Janusz, CPIM
-- 
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).

RE: Converting EBCDIC to ASCII

[kjanusz]

Thanks for the information.  The IMS data will have to 
be cleansed before it is loaded into Oracle (8.1.? on 
W/2000).  So there will be some intermediate 
files/tables that will be used for this purpose.  

Will sqloader convert EBCDIC to ASCII? 

Thanks,
Ken Janusz, CPIM
> We do not pull data directly from IMS but load it in batch jobs.  Our
> mainframe guy either dumps the data report-style (ASCII) or copies records
> in native EBCDIC to files on the mainframe.  We ftp them to the Oracle side
> (binary mode to EBCDIC files) and use sql loader to move into Oracle.  On
> the files that come over in EBCDIC, I use sqlloader with the following in
> the control file.  There are a few bugs with loading EBCDIC (search
> metalink)  but we manage to get it loaded.
> 
> 
> 
> LOAD DATA
> CHARACTERSET WE8EBCDIC500
> INFILE 'e:\filename.dat' "fix 688" 
> ...
> 
> 
> 
> 
> 
> -Original Message-
> Sent: Friday, August 17, 2001 9:37 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I may be moving data from an IMS db which is stored in 
> EBCDIC.  Oracle stores data in ASCII format.  How do I 
> go about converting EBCDIC to ASCII to store the data in 
> Oracle (8.1.?)?
> 
> Thanks,
> Ken Janusz, CPIM
> -- 
> 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: Bond Mike A Contr OC-ALC/TILC
>   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).

Re: Converting EBCDIC to ASCII

[kjanusz]

Thanks for the info.  The Oracle DB will be on W/2000.

Ken Janusz, CPIM
> If you "export" the IMS data out to flat textfiles,
> and then transfer them via ftp in "ASCII" mode, the
> conversion will be done automagically for you.
> 
> Alternatively if on Unix the "dd" utility will
> do the conversion for you.
> 
> HTH & YMMV!
> 
> [EMAIL PROTECTED] wrote:
> > 
> > I may be moving data from an IMS db which is stored in
> > EBCDIC.  Oracle stores data in ASCII format.  How do I
> > go about converting EBCDIC to ASCII to store the data in
> > Oracle (8.1.?)?
> > 
> > Thanks,
> > Ken Janusz, CPIM
> > --
> > 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).
> 
> -- 
> Charlie Mengler  Maintenance Warehouse  
> [EMAIL PROTECTED] 10641 Scripps Summit Ct.
> 858-831-2229   .NET? Not yet!San Diego, CA 92131
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Charlie Mengler
>   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).

Converting EBCDIC to ASCII

[kjanusz]

I may be moving data from an IMS db which is stored in 
EBCDIC.  Oracle stores data in ASCII format.  How do I 
go about converting EBCDIC to ASCII to store the data in 
Oracle (8.1.?)?

Thanks,
Ken Janusz, CPIM
-- 
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).

Migrating IMS to Oracle

[kjanusz]

I may be starting a project in the near future to 
migrate an IMS database to 8.1.? on Windows 2000.  I 
would like to know if Oracle provides a tool to do 
this?  Data profiling, mapping, etc.?  I could not find 
anything for IMS on OTN or the Oracle site.  I know 
there are some non-Oracle tools to do this.

Any suggestions would be helpful.

Thanks,
Ken Janusz, CPIM
-- 
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).

Re: Personal Top 3 Oracle titles

[kjanusz]

Before I buy a book I always check Amazon.com's reader 
reviews.  They can be very helpful.

Ken Janusz, CPIM
> Guy Harrison's High Performance SQL Tuning Book
> Steven Feuernstein's PL/SQL books (O'Reilly)
> 
> Both of these books taught me a lot of what I know.  I read Harrison's book
> cover to cover.  
> 
> Don't forget the Oracle Documentation... !
> 
> I haven't purchased a DBA book that I thought was incredibly worthwhile
> (yet).  I'll be buying Jonathan Lewis' book after the discussion on the list
> though.  
> 
> 
> > -Original Message-
> > From:   Steve Armijo [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, August 14, 2001 1:07 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: RAID or NOT to RAID?  What's the diff???
> > 
> > On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote:
> > > and very nice they are too.
> > > 
> > > Great book by the way.
> > 
> > Hmmm, so what would folks consider their essential Oracle books?  maybe
> > your
> > personal top 2 or 3?
> > 
> > -s
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Steve Armijo
> >   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).

Oracle8i eBoot Camp

[kjanusz]

Does anyone have any experience with the Oracle8i eBoot 
Camp put on by OraKnowledge?

Thanks,
Ken Janusz, CPIM


-- 
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).

Oracle Designer Question

[kjanusz]

Has anyone used Oracle Designer to do Business Process 
Modeling?  If so, any problems with the product or 
gotchas?

Thanks,
Ken Janusz, CPIM
-- 
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).

RE: Oracle Beta

[kjanusz]

I checked OTN and they have a download for 9i on NT but 
its the Lite version.

Ken Janusz, CPIM
> to be quite honest I can't be sure what it is.  When I hit the link in the
> email it opens up, but before I hit it I have to be logged on as a user with
> privelages to get to it.  I am pretty sure that if you just go to OTN there
> is a link for a sun download?
> KK
> 
> -Original Message-
> Dandekar
> Sent: Thursday, August 02, 2001 1:11 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> What is it? I mean the URL to 9i Beta for Windows.
> No Sun of Mine (no test sun machine available right now..)
> 
> -Rahul
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, August 02, 2001 12:16 PM
> 
> 
> > Yes I am replying to my own email, nevermind, I found it:)
> > KK
> >
> > -Original Message-
> > Kostyszyn
> > Sent: Thursday, August 02, 2001 11:11 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> > Does anyone know the URL for the Oracle 9i Beta program.  I need to
> > download the NT version of 9i.
> > Thanks in advance:)
> >
> > Sincerely,
> > Kevin Kostyszyn
> > DBA
> > Dulcian, Inc
> > www.dulcian.com
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kevin Kostyszyn
> >   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: Kevin Kostyszyn
> >   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: Rahul Dandekar
>   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: Kevin Kostyszyn
>   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).

Re: Medtronic

[kjanusz]

On Medtronic's career web site they are looking to fill 
the following positions:

Sr. DBA Project Mgr
Sr. DBA (2 positions)
Prin. DBA

I would like to find out who the hiring manager is, 
their mailing address and direct phone #.

I already sent my resume to HR.

Your help getting me this information will be greatly 
appreciated.

Thanks,

Ken Janusz, CPIM
> 
> My husband works at Medtronic in Minnesota.
> What are you interested in?
> 
> Cherie Machler
> Gelco Information Network
> 
> 
>  
> 
> [EMAIL PROTECTED]
> 
> et   To: Multiple recipients of list 
> ORACLE-L <[EMAIL PROTECTED]>  
> Sent by: cc: 
> 
> root@fatcity.Subject: Medtronic" 
> 
> com  
> 
>  
> 
>  
> 
> 07/27/01 
> 
> 09:57 AM 
> 
> Please   
> 
> respond to   
> 
> ORACLE-L 
> 
>  
> 
>  
> 
> 
> 
> 
> 
> Is there anyone using this list from Medtronic in
> Minnesota?
> 
> Thanks,
> Ken Janusz, CPIM
> --
> 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: 
>   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).

Medtronic"

[kjanusz]

Is there anyone using this list from Medtronic in  
Minnesota?

Thanks,
Ken Janusz, CPIM
-- 
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).

Re: * Oracle DBA Needed in Phoenix..

[kjanusz]

With our current economic conditions it's a buyer's 
market.  
> 
> Peter,
> 
> It probably means that they're willing to relocate someone
> but don't want to pay a ton of money to relocate someone
> who owns a house.  There can be more than $10,000 worth
> of closing costs, moving costs, guarantee to buy your house
> if it doesn't sell, etc.
> 
> Renters are simpler and cheaper to relocate.
> 
> Chere
> 
> 
>  
> 
> Peter
> 
>  ORACLE-L <[EMAIL PROTECTED]>  
> com> cc: 
> 
> Sent by: Subject: Re: * Oracle DBA Needed in 
> Phoenix..
> root@fatcity.
> 
> com  
> 
>  
> 
>  
> 
> 07/05/01 
> 
> 05:17 PM 
> 
> Please   
> 
> respond to   
> 
> ORACLE-L 
> 
>  
> 
>  
> 
> 
> 
> 
> 
> 
> 
> On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying:
> 
> 
> . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote:
> . . . .|O> We would like to submit someone who is a renter and who is
> interested
> . . . .|O> in Phoenix but has not applied to Phoenix companies and is not
> working with
> . . . .|O> other recruiters for Phoenix companies.
> . . . .|
> . . . .|Now why in the world would any of this matter?
>They are trying to get more people into Phoenix, and they
> have invested in apartment buildings.
> 
> But seriously that is kinda weird.
> 
> . . . .|
> www.nul.cjb.net
> www.FreeBSD.org
> 
> 
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Peter
>   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: 
  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: OCP Discount S36

[kjanusz]

Here is what the web site says:

> Sign Up For a Test Now
  Register for Oracle certification testing
  (mention promotional code "S36" to
  receive your OTN 20% discount)

--

There is no mention of an expiration date.

Ken
> I don't think it does - it is just the Technet membership code..
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Thursday, June 28, 2001 10:21
> To: Multiple recipients of list ORACLE-L
> 
> 
> OTN says that you can get an OCT 20% discount on the 
> testw with code S36.  However, it doesn't say when this 
> code expires?
> 
> Thanks,
> Ken Janusz, CPIM
> -- 
> 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: Mark Leith
>   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).

A Question on the Basics of PL/SQL

[kjanusz]

I am a bit confused as to when to use the following.  I 
cannot seem to find any definitive rules.

- function
- cursor
- procedure
- package

If someone can point me to a white paper, or whatever, 
that defines the rules for their usage I would be most 
thankful.

Thanks,
Ken Janusz, CPIM
-- 
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).

OCP Discount S36

[kjanusz]

OTN says that you can get an OCT 20% discount on the 
testw with code S36.  However, it doesn't say when this 
code expires?

Thanks,
Ken Janusz, CPIM
-- 
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).

Re: Virus?

[kjanusz]

Kevin:

Yes, I got 2 of them and immediately deleted them.  They 
looked fishy to me.

Ken Janusz, CPIM
> Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with
> attachments.  It appears to just be peaces of emails and then a "see
> attached" and an attachement?  Yeah, I'll get right on opening that up.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   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).

Re: Common Oracle RDBMS Misconceptions

[kjanusz]

Where can I get the "exploding the myths" paper?

Thanks,
Ken Janusz, CPIM
> Jeremiah,
> 
> Marlene and I did an "exploding the myths" paper very similar to what you 
> are doing..
> 
> "always set pctincrease on your temporary tablespace to 1"
> 
> and my OOW submission is very very similar to yours.  Not quite, but really 
> close.
> 
> It will be interesting to see if they choose one, both or neither of our 
> papers :)
> 
> Rachel
> 
> >From: Jeremiah Wilton <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Common Oracle RDBMS Misconceptions
> >Date: Tue, 26 Jun 2001 09:05:27 -0800
> >
> >All right folks, I'm collecting misconceptions, of the type held by newbies 
> >and
> >oldtimers alike.  My OOW proposal this year is for a presentation and paper 
> >on a
> >whole laundry list of these things, similar to what I wrote for hot backup. 
> >  I
> >want to share what I have so far and solicit input for your favorites (pet
> >peeves).  I most certainly will credit individuals and this list for any 
> >ideas I
> >glean.
> >
> >So far my favorite misconceptions are:
> >
> >* Hot backup stops writing to datafiles
> >* All network communication is done through the listener
> >* Always 'switch logfile' after (before, inbetween) hot backups
> >* Media recovery is required if you crash during backup mode
> >* Cold backup once a week ("just in case," "as a 'baseline'")
> >* Export is a good way to back up your database
> >* Shutdown abort is bad, crash recovery time is as long as 'shutdown 
> >immediate'
> >* Listener.log/alert.log clearing confusion
> >* ORA-1555 can be solved by setting transaction (use specific rollback seg)
> >* Big batch jobs should use one big RBS
> >* ORA-600 means you have corruption / just call support for ORA-600
> >* Lots of extents are bad
> >* Databases can't be renamed
> >* Select count (1) is better than count (*).
> >* Listeners have to be started before the instance
> >* NOLOGGING turns off logging for all operations
> >* Oracle Corp. won't support NFS datafiles
> >* checkpoint not complete - misguided solutions
> >* Must reinstantiate standby after failover by recopying
> >* redolog size change requires outage
> >
> >What's *your* pet misconception?
> >
> >--
> >Jeremiah Wilton
> >http://www.speakeasy.net/~jwilton
> >
> >On Tue, 26 Jun 2001, novicedba wrote:
> >
> > > I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
> > > I was shocked to read Hot backup mode explained
> > > If this is true then I may be a victim of a disease called
> > > 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim 
> >carrey-MASK style)
> > > Please help me. If some one has few more articles like this enlighten me
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jeremiah Wilton
> >   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).
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   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).

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

[kjanusz]

I don't know too much about their IS dept.  I have my 
resume in with them for a couple of Oracle related 
positions, but haven't gotten any feedback yet.

Ken 
> Sorry Ken.  I thought I finally figured out what employers want.  What do I
> know.  I work for a company who has different colored chairs depending on
> what 'level' your job is.  Like I care.  I said give me the color chair the
> janitor has.  You'll be bringing me the leather recliner in the future, I
> guarantee it. 
> 
> Ken, what do you think about Best Buy?
> 
> > -Original Message-
> > From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, June 25, 2001 2:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..
> > 
> > Lisa:
> > 
> > You need to update this.
> > 
> > Must not be over 30 years old with a minimum of 15 years 
> > of post graduate work as an Oracle DBA with a minimum of 
> > 5 years of experience with 9i and 11i. etc.
> > 
> > Ken Janusz, CPIM
> > > Requirements: 
> > > Must be able to lift heavy database files. 
> > > Must be at least 30 years old, having graduated from college and
> > immediately
> > > become a DBA and put in your 7 years. 
> > > 
> > > This position is with a Great company offering:
> > > Base salary only.  110K is only to get your attention. 
> > > The opportunity to become the most abused member of a team.
> > > The opportunity to live in Kansas City (is that good or bad?)
> > > 
> > > I can't stand headhunters.  They serve a real purpose but a majority of
> > them
> > > are jerks.
> > > 
> > > 
> > > > -Original Message-
> > > > From:   OraStaff [SMTP:[EMAIL PROTECTED]]
> > > > Sent:   Monday, June 25, 2001 11:36 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject:* Sr. Oracle DBA Needed in Kansas City, Kansas area..
> > > > 
> > > > If you enjoy interesting work, then join this industry leader in the
> > > > Kansas
> > > > City, Kansas area
> > > > that needs a Sr. level Oracle DBA to provide database support .
> > > > 
> > > > This is a full time staff position so no sub-contractors or third
> > parties
> > > > please.
> > > > 
> > > > Please do not call or send a resume if you are not in the U.S. and/or
> > need
> > > > 
> > > > sponsorship.
> > > > 
> > > > Requirements: 
> > > > * College Degree
> > > > * Oracle DBA experience,  7+ years 
> > > > * Experience working with heavy and large database files
> > > > * Excellent Communications Skills
> > > > * Must be a team player
> > > > * U.S. citizenship or green card holder
> > > > 
> > > > This position is with a Great company offering:
> > > >* Stability 
> > > >* The opportunity to become a key member of the team.
> > > >* Base salary 70-110K + bonus
> > > > 
> > > > NO sub contracting positions available.
> > > > PLEASE do not send your resume if you are not in the United States.
> > > > 
> > > > For  immediate consideration, please send your resume as a Word
> > attachment
> > > > to:
> > > > Bill Law, 
> > > > Oracle Placement Specialist
> > > > Orastaff, Inc.
> > > > Email: [EMAIL PROTECTED]
> > > > Phone: 1-800-549-8502. 
> > > > Please Use Job Code: One/DBA/KC/KS/Walkup
> > > > 
> > > > Note: This is only one of the many opportunities that we have
> > available
> > > > across the U.S. 
> > > > for candidates with Oracle skills. So if this one is not a match for
> > you,
> > > > we
> > > > invite you 
> > > > to send us your resume- as we quite possibly have the opportunity that
> > you
> > > > are seeking.
> > > > 
> > > > We pay referral fees.  
> > > > So please contact me if you know of anyone who would be
> > > > qualified/interested
> > > > in the
> > > > posiition described above- if it is not a match for your skills.
> > > > Thanks,
> > > > Bill Law
> > > > 
> > > > 
> > > > -- 
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > -- 
> > > > Author: OraStaff
> > > >   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 

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

[kjanusz]

I don't mind if they are lying for me, but not lying for 
the company that I may go to work for.

Also, none of them get paid until they play someone.

Ken Janusz, CPIM
> And Lisa, most of them lie thru their teeth in order to get a position
> filled !
> 
> -Original Message-
> Sent: Monday, June 25, 2001 11:47 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Requirements: 
> Must be able to lift heavy database files. 
> Must be at least 30 years old, having graduated from college and immediately
> become a DBA and put in your 7 years. 
> 
> This position is with a Great company offering: 
> Base salary only.  110K is only to get your attention. 
> The opportunity to become the most abused member of a team. 
> The opportunity to live in Kansas City (is that good or bad?) 
> 
> I can't stand headhunters.  They serve a real purpose but a majority of them
> are jerks. 
> 
> 
>   -Original Message- 
> Sent:   Monday, June 25, 2001 11:36 AM 
> To: Multiple recipients of list ORACLE-L 
> 
>   If you enjoy interesting work, then join this industry leader in the
> Kansas 
> City, Kansas area 
> that needs a Sr. level Oracle DBA to provide database support . 
> 
>   This is a full time staff position so no sub-contractors or third
> parties 
> please. 
> 
>   Please do not call or send a resume if you are not in the U.S.
> and/or need 
> sponsorship. 
> 
>   Requirements: 
> * College Degree 
> * Oracle DBA experience,  7+ years 
> * Experience working with heavy and large database files 
> * Excellent Communications Skills 
> * Must be a team player 
> * U.S. citizenship or green card holder 
> 
>   This position is with a Great company offering: 
>* Stability 
>* The opportunity to become a key member of the team. 
>* Base salary 70-110K + bonus 
> 
>   NO sub contracting positions available. 
> PLEASE do not send your resume if you are not in the United States. 
> 
>   For  immediate consideration, please send your resume as a Word
> attachment to: 
> Bill Law, 
> Oracle Placement Specialist 
> Orastaff, Inc. 
> Email: [EMAIL PROTECTED] 
> Phone: 1-800-549-8502. 
> Please Use Job Code: One/DBA/KC/KS/Walkup 
> 
>   Note: This is only one of the many opportunities that we have
> available 
> across the U.S. 
> for candidates with Oracle skills. So if this one is not a match for you, we
> 
> invite you 
> to send us your resume- as we quite possibly have the opportunity that you 
> are seeking. 
> 
>   We pay referral fees.  
> So please contact me if you know of anyone who would be qualified/interested
> 
> in the 
> posiition described above- if it is not a match for your skills. 
> Thanks, 
> Bill Law 
> 
> 
>   -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   
> -- 
> Author: OraStaff 
>   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).

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

[kjanusz]

Lisa:

You need to update this.

Must not be over 30 years old with a minimum of 15 years 
of post graduate work as an Oracle DBA with a minimum of 
5 years of experience with 9i and 11i. etc.

Ken Janusz, CPIM
> Requirements: 
> Must be able to lift heavy database files. 
> Must be at least 30 years old, having graduated from college and immediately
> become a DBA and put in your 7 years. 
> 
> This position is with a Great company offering:
> Base salary only.  110K is only to get your attention. 
> The opportunity to become the most abused member of a team.
> The opportunity to live in Kansas City (is that good or bad?)
> 
> I can't stand headhunters.  They serve a real purpose but a majority of them
> are jerks.
> 
> 
> > -Original Message-
> > From:   OraStaff [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, June 25, 2001 11:36 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:* Sr. Oracle DBA Needed in Kansas City, Kansas area..
> > 
> > If you enjoy interesting work, then join this industry leader in the
> > Kansas
> > City, Kansas area
> > that needs a Sr. level Oracle DBA to provide database support .
> > 
> > This is a full time staff position so no sub-contractors or third parties
> > please.
> > 
> > Please do not call or send a resume if you are not in the U.S. and/or need
> > 
> > sponsorship.
> > 
> > Requirements: 
> > * College Degree
> > * Oracle DBA experience,  7+ years 
> > * Experience working with heavy and large database files
> > * Excellent Communications Skills
> > * Must be a team player
> > * U.S. citizenship or green card holder
> > 
> > This position is with a Great company offering:
> >* Stability 
> >* The opportunity to become a key member of the team.
> >* Base salary 70-110K + bonus
> > 
> > NO sub contracting positions available.
> > PLEASE do not send your resume if you are not in the United States.
> > 
> > For  immediate consideration, please send your resume as a Word attachment
> > to:
> > Bill Law, 
> > Oracle Placement Specialist
> > Orastaff, Inc.
> > Email: [EMAIL PROTECTED]
> > Phone: 1-800-549-8502. 
> > Please Use Job Code: One/DBA/KC/KS/Walkup
> > 
> > Note: This is only one of the many opportunities that we have available
> > across the U.S. 
> > for candidates with Oracle skills. So if this one is not a match for you,
> > we
> > invite you 
> > to send us your resume- as we quite possibly have the opportunity that you
> > are seeking.
> > 
> > We pay referral fees.  
> > So please contact me if you know of anyone who would be
> > qualified/interested
> > in the
> > posiition described above- if it is not a match for your skills.
> > Thanks,
> > Bill Law
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: OraStaff
> >   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).

OCP Testing Software

[kjanusz]

I have used SelfTest Software in the past to prepare for 
the OCP tests.  Is there another similar company that is 
as good or better?

Thanks,
Ken Janusz, CPIM
-- 
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).

Re: * I'm Looking for an Oracle Financials DBA for Miami,

[kjanusz]

The Minneapolis / St. Paul area is not very active for 
Oracle people now.  We have about 175 Oracle shops in 
the area.

Ken Janusz, CPIM
> Florida has always been a weak market compared to rest of the USA.  I remember 
> in NYC, you could go get another job at a lunchtime interview.  DC area has a 
> good job market.  Pick up the NY Times or Washington Post.  Not sure on the rest 
> of the country.  BTW, the financials job in Miami is at DelMonte and they have 
> been looking for over a year.
> 
> >>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
> "DBA" jobs listings on ComputerJobs.com for the Florida area have gone from 1572 
> to 846 over the past 6 months. The job ads you see are repeated each week and 
> are posted by more than one recruiter for the same job. Contact with the 
> recruiter results in the " job is filled" or some other lame excuse. It appears 
> that they are building a resume database incase the market opens up again. In 
> the past weeks we have been contacted 2 or 3 times a week by recruiters 
> inquiring "if we have any opening that they can fill?"
>  I think the market is tight right now and "downsizing" will continue for a > while 
>until the economy picks up. Weekly the papers report another company in 
> the Atlanta, GA area going through the "size" adjustment.
> ROR mª¿ªm
> 
> >>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
> Gregory Conron schrieb:
> > 
> > On June 16, 2001 04:35 am, Jared Still wrote:
> > >Many of
> > > us consider this a service, especially the way that jobs are
> > > at the moment.
> > 
> > Amazing the difference a year can make, eh?
> > 
> 
> Hi
> 
> Just curious: How bad is the job situation in the US right now ? 
> I'm wondering since we consider moving there (my wife is american).
> 
>  
> | Regards,   |
> | Stefan Jahnke  |
> | BOV AG |
> | @:D2 Vodafone, Abt.: FIBM  |
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Stefan Jahnke
>   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: Ron Rogers
>   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: Gene Sais
>   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).

Need Help

[kjanusz]

I need some help.  I was an Oracle DBA with ADC Telecomm 
in Minnesota and was laid off along with 7,000 other ADC 
employees.  The job market here in the TC’s has been 
very slow.  

Any assistance finding another Oracle related position 
would be greatly appreciated. Please contact me directly 
at [EMAIL PROTECTED]

Relocation from the Mpls / St. Paul, MN is not an option.

Thanks much,

Ken Janusz, CPIM  
-- 
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).

OCP Discount?

[kjanusz]

I was looking over the OCP stuff on Oracle's web site 
and them mentioned a 20% discount.  However, I can't 
find were to apply for it.  Any ideas?

Thanks,
Ken Janusz, CPIM
-- 
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).

RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

[kjanusz]

Yes. But it's only $1,499 a pop!

Ken Janusz, CPIM
> Yup.
> 
> 
> 
> -Original Message-
> Sent: 13 June 2001 14:16
> To: Multiple recipients of list ORACLE-L
> 
> 
>  Did anyone else on the list get this stupid spam besides me?
> 
> thanks, joe
> 
> 
> -Original Message-
> To: [EMAIL PROTECTED]
> Sent: 6/12/01 5:48 PM
> 
> OraKnowledge eBoot Camp for the Oracle8i DBA Track
> 
> OraKnowledge has created a blended e-learning program that GUARANTEES
> Oracle DBAs will become certified.  The 5-week program combines the best
> of self-paced and instructor-led e-learning utilizing:
> 
> * Syllabus for Success
> * Certification Exam Guides
> * Pre-assessment tests
> * Live, virtual classroom instruction from an OCP
> * 24 x 7 OCP Mentoring
> * eFlash Cards
> * Hundreds of Practice Questions
> * Guarantee
> 
> Seats are available for our July 16th (EST) and July 18th (PST) start
> dates!!  
> 
> Visit http://www.oraknowledge.com for more information.
> 
> 
> To UNSUBSCRIBE from our list, reply to this email and replace the
> subject line with UNSUBSCRIBE.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joe S. Testa
>   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: 
  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: Job search on this list

[kjanusz]

Yosi:

I'm in the market also, got laid off from ADC Telecomm 
in the Mpls / St. Paul, MN area.  The job market here is 
slow at best.  So, I need some help.

Thanks,
Ken Janusz, CPIM
[EMAIL PROTECTED]
> Thanks to those who've responded so far. I forgot to
> mention I'm looking in the New York Metro area. Small
> market, no competition.
> 
> Thanks.
> 
> [EMAIL PROTECTED] wrote:
> 
> > All,
> >
> > I hate interrupting all the scrumptious, gastronomic activity going on
> > today, but...
> >
> > How much of a no-no is it to use this list to declare myself officially
> > almost-unemployed and looking for work? The way I figure it
> >  is that if one does this regularly and uses this board as a free
> > advertising forum, that would be bad, but to let everyone know
> >  that the writing is on the wall, in bold, and I'll consider all offers
> > for food would be ok.
> >
> > Since that's how I figure it, here goes:
> >
> >For rent or sale: one 15-year Oracle dba / engineer
> >/ architect, with certification. Market-rate to
> >possibly pricey, communicates very well, and can
> >(usually) make the database sing. For details,
> >contact Yosi Greenfield at [EMAIL PROTECTED] (for a
> >LIMITED time!), or at [EMAIL PROTECTED]
> >
> > Any offers of employment will be considered - possibly gasped at with a
> > look of horror, but considered. Any offers of food will be queued until the
> > offers of employment run out.
> >
> > Ok y'all, really now, if anybody's got a need or a lead, lemme know.
> >
> > MUCH thanks,
> >
> > Yosi
> >
> > 
> > Yosi Greenfield
> > [EMAIL PROTECTED]
> >
> > --
> > 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).
> 
> --
> Thanks,
> 
> Yosi
> 
> 
> -
> Yosi Greenfield
> Database Architect
> Comhill Systems, Inc.
> [EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Yosi Greenfield
>   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).

Re: 9i download

[kjanusz]

Is that ReGet Junior or Deluxe?  Or, does it make a 
difference?  Also, has anyone tried Download Accelerator 
Plus?  It seems to be a similar product.

Thanks,
Ken Janusz, CPIM
> 
> I'll second that.  It's the only way to get a clean download from technet.
> 
> Jared
> 
> 
> On Monday 04 June 2001 10:00, Post, Ethan wrote:
> > Note sure if your using a download manager Chris, I used ReGet (Tucows.com)
> > the other day to get 8.1.7.3 and it worked really great. - E
> >
> > -Original Message-
> > Sent: Monday, June 04, 2001 9:22 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I could never successfully download the file. I ended up getting the CD.
> >
> > >>> [EMAIL PROTECTED] 06/04/01 11:15AM >>>
> >
> > I keep trying to download 9i and the files keep being invalid gzip files.
> > Anyone else have this problem or have successfully downloaded this monster?
> > I have downloaded each file 3-4 times now in the last 2 days.
> >
> >
> > "Walking on water and developing software from a specification are easy if
> > both are frozen."
> >
> > Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
> > Oracle DBA
> > Phone: (978) 322-5744
> > Fax:(707) 885-2275
> >
> > Fuelspot
> > 73 Princeton Street
> > North, Chelmsford 01863
> -- 
> 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: 
  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: job offer from SAUDI ARABIA

[kjanusz]

I would suggest that you contact the taxing authorities 
in you native country to determine if you owe any income 
taxes on what you make and also on any expenses that 
Saudi Arabia will give you.

My 2 cents, 

Ken Janusz, CPIM
> Hi all ,
> I have taken an offer from a company in Europe to work in Saudi Arabia for 2 
> years.
> But I must learn the living conditions there.
> Ýf there is an Arabian here , can you answer these..
> 
> 1) How are the living conditions?Expensive?
> 2) Will my wife have to cover her hair? Is it mandatory there?
> 3) How are the social activities like cinema?
>   Thanks.
>  
> 
-- 
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).