RE: Korn Shell Q

[Bellows, Bambi]

Ethan --

As I understand it, your skip isn't working if there are multiple parameters
passed in, so that when you get your parameters and do your skip, you are
skipping one "word" and then the next parameter fails.  If that is the case,
what you may want to do is parse out the multi-parameter string with awk -F"
{'print $2'}.  Then count the words separately and skip those.

HTH.  BTW, I'm tied up with AppsDBA stuff and am not monitoring the List as
I should.  Feel free to email me directly if I can provide addition
assistance.

Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: LIKE and % operator

[Bellows, Bambi]

Looks like you're running into a case-sensitivity issue.  Try 

select * from sonusrpt where upper(subject) like upper('%general%');

HTH.
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L

I am running oracle8i on solaris8.  I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL> select * from sonusrpt where subject like '%general%';

no rows selected.


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: Bellows, Bambi
  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: FW: Expiration of your subscription to the ORACLE-L list

[Bellows, Bambi]

Wasn't SUNYSB the server when Sanjay ran
the list?  

 

Bambi.

 

-Original Message-
From: Rodd Holman
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 01, 2002 1:58
PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: FW: Expiration of
your subscription to the ORACLE-L list

 

That's obviously a different ORACLE-L.  This list
is on fatcity.com and admin commands (subscribe, unsubcribe, etc.) are run
through [EMAIL PROTECTED]  

Rodd 

On Fri, 2002-03-01 at 12:48, Hamid Alavi wrote: 

List,I want to know if any of you received a message like this forre-subscribe??? -Original Message-[mailto:[EMAIL PROTECTED]]Sent: Friday, March 01, 2002 3:00 AMTo: Hamid Alavi  Fri, 1 Mar 2002 06:00:01 Your subscription to the ORACLE-L list has expired and you have failed toconfirm  it in  the 7  day  delay that  you  had been  granted. You  havetherefore been automatically removed from  the list. You can re-subscribeto  the  list, if  you  want  to, by  sending  the  following command  to[EMAIL PROTECTED]:    SUBscribe ORACLE-LThe information contained in this message and any attachments is intendedonly for the use of the individual or entity to which it is addressed, andmay contain information that is PRIVILEGED, CONFIDENTIAL and exempt fromdisclosure under applicable law. If you have received this message in error,you are prohibited from copying, distributing, or using the information.Please contact the sender immediately by return e-mail and delete theoriginal message from your system.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hamid Alavi  INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California    -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).

RE: HP-UX Oracle Install

[Bellows, Bambi]

>Does this prevent deletions of the files or rebooting or unmounting the
> file system ?

No.  What it does do is stop people from being able to specifically delete
the file without wildcards.  Some shops are good about not deleting with
wildcards.  And then there's the rest of the world.

HTH,
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: RE: PocketDBA

[Bellows, Bambi]

Dick --

I would hope so.  I'm sure you'll like what you see.  But if you're going to
put the product through its paces, let us know what your thoughts are.  

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 3:49 PM
To: Bellows; Bambi; [EMAIL PROTECTED]

Bambi,

Well if Ari lurks, perhaps he'll catch on that someone else may be
interested in his product.  Yes, I do apply different standards to products
based on who I'm talking to and what they own, but also on what they've
done. 
Someone who has done a lot of Oracle admin gets a few extra points even if
he is
the CEO.

But darn, not another chief engineer/CEO running around!!  That can be
troublesome since there comes a time to shoot the engineer and get to
shipping. 
We have that situation around here & believe me you can always tell when he
re-spins the chips!!  Oh Well!!

Ari,  If your in earshot my number is (978)749-3553.

Dick Goulet

Reply Separator________
Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
Date:   2/28/2002 2:45 PM


Dick --

You're likely to get feedback from Ari Kaplan.  Be aware that he owns the
company, and will most certainly come through as very positive.  The only
reason I mention is that if Ari were to tell me about this magnificent
product, I would apply a lot of weight to it based upon who he is; however,
if the president of a software company were to tell me how terrific a
product is, I might apply different standards.  And who owns what is not
commonly known.  Looking at the demo he gave me, it looked good, but I
haven't used it personally.

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

Anyone on the list ever use this software?  Any feedback?

Dick Goulet
-- 
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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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

RE: Unix shell Question

[Bellows, Bambi]

Title: Unix shell Question









Date and string functions are not terribly
easy in Unix, and generally involve parsing cal.  So, if you want to do sysdate-1, what
you would do is this:

 

DAY=`date +%d`

MONTH=`date +%m`

YEAR=`date +%C%y`

echo $DAY $MONTH $YEAR 

if [ $DAY = 1 ] ;

then

    if
[ $MONTH = 1 ] ;

    then

   
CAL_MONTH=12

   
CAL_YEAR=`expr $YEAR - 1`

    else

   
CAL_MONTH=`expr $MONTH - 1`

   
CAL_YEAR=$YEAR

    fi

    CAL_DAY=`cal $CAL_MONTH $CAL_YEAR|tail -2|head -1|awk '{print $NF}'`

else

    CAL_DAY=`expr
$DAY - 1`

    CAL_MONTH=$MONTH

    CAL_YEAR=$YEAR

fi

echo "Yesterday was $CAL_MONTH $CAL_DAY $CAL_YEAR"

 

or, you could do this:

 

sqlplus << EOF
scott/tiger

spool date

select sysdate-1 from dual;

exit

EOF 

grep -v SQL date.lst|tail -2|head -1

 

 

Whichever.

 

HTH,

Bambi.

 

-Original Message-
From: Yuval Arnon
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 28, 2002
3:38 PM
To: Multiple recipients of list
ORACLE-L
Subject: Unix shell Question

 

Hi, 
Need help in Unix shell.

Is there a way to compute the
previous date (similar to sysdate - 1 in SQL) using the date expression??


So if my date is 3/1/2002 I will get 2/28/20002.


 

TIA 

Yuval. 

RE: oracle 8.1.7 patch 2 or 3?

[Bellows, Bambi]

What vendor, what product?

-Original Message-
Sent: Thursday, February 28, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L

Hi,

I am managing a software that uses a set of 8 oracle databases.  I am 
preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then 
apply a patch to the oracle software installation after the upgrade.  The 
software that uses these databases are only certified on patch 2 level at 
the time of release.  Since now the patchset 3 for 817 is available, I 
would like to get advice in whether to apply patch 3 instead of patch 2. 
Same amount of work, more benefits.  The only thing is that the application 
vendor does not officially support the patch3.

platform: Sun Solaris 2.8
Oracle EE server 8.1.6.3.0

Any input is appreciated.

Xiaohong Yang (Sharon)
Center for Bioinfomatics
UNC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xiaohong Yang (Sharon)
  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: Bellows, Bambi
  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: RE: Manager decrees "his" data warehouse design. Help!

[Bellows, Bambi]

Relational. Adjective. Of, or relating to, relatives. Generally pertaining
to mandatory dinners or inane conversations regarding politics, religion,
sex, money or military service. Of necessity, the tables are denormalized,
that is, all semblance to normalcy is rejected, especially when discussing
Uncle Vernor's time in Normandy with that goat.

HTH,
Bambi.

-Original Message-
Sent: Wednesday, February 27, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L

What is the meaning of "relational" in "relational database" again?

Good grief.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: Bellows, Bambi
  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: RE: Manager decrees "his" data warehouse design. Help!

[Bellows, Bambi]

Also not uncommon when tracking medical data.

Bambi.

-Original Message-
Sent: Wednesday, February 27, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L

Some of the tables in J.D. Edwards OneWorld have over 200 columns, VARCHAR
is not used, only NUMBER and CHAR.  Makes for some wide tables.  This
product was originally some type of flat file database.  

Ethan

-Original Message-
Sent: Wednesday, February 27, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


I think the column limit is now closer to 1000, but like you, I can't 
imagine 
willingly designing a table with a column count exceeding 2 digits.

More than 15 or 20 and I start to question the design.

Jared


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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: Bellows, Bambi
  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: Manager decrees "his" data warehouse design. Help!

[Bellows, Bambi]

ow, I've done a CTAS from a materialized view that we created to 
support one departments known requirements.


Don
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Bellows, Bambi
  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: Manager decrees "his" data warehouse design. Help!

[Bellows, Bambi]

I once had a manager who was a paranoid schizophrenic.  Very exciting, let
me tell you.  But, one thing he told me in a rather roundabout paranoid way
is that the way you deal with crazy bosses who were out to get you is to
make friends with other people at your boss' level in the organization,
hopefully who report to the same person your boss does, and let them know in
a laughing kind of way what your boss wants you to do.  Never be
confrontational or speak ill of your boss, because, of course, that will
wind up biting you in the ass, too.  But, that way, when your boss starts
badmouthing you and blaming you for everything that goes wrong that was his
fault, you'll be insulated from having anything bad happen to you as your
friends will close ranks around you and stop your boss from making your life
a living hell.

And then he threw his coffee cup across the room, turned bright red and
started shrieking about how the VP of R&D had always hated him.  God, I
loved that job.  Many, *MANY* wonderful stories came out of that place.

Anyway, I never thought to follow this advice, let alone share it, but, it
sounds like, in this case, you have a crazy boss, and if you stick around,
you're going to need a little safety.

Of course, posting your resume isn't a bad approach either.

HTH,
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: 8i Replication: administrator privs

[Bellows, Bambi]

Somehow this seems like a bad idea.  I've always restricted
administration to REPADMIN, but maybe I lack outside-of-the-box
thinking



I'm kinda an outside-the-box-kind-of-gal.  But, yeah, that looks like a
recipe for failure to me too.

Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: Anybody against using views?

[Bellows, Bambi]

If you're using views properly, they're wonderful and allow a phenomenal
amount of flexibility to the designer, but like all powerful beings, they
must use their power for good (complex query manipulation) rather than evil
(resource hogging).

HTH,
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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 Licensing - Concurrent users

[Bellows, Bambi]

ficial ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- 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: Bellows, Bambi
  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: Rollback Segments

[Bellows, Bambi]

I had a Hercules card too.  I needed it to play some RPG game.  Funny how
many geeks had amber.  I was so sick of the green on the VT and Vulcan
boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue.
And then, of course the VT2xx series came out with its amber and everything
was terrific.  When I finally got off of VAXes, I was up to something like a
VT460 only to go into Unix and set my TERM=vt100.  How Neolithic.

Pass the arthritis cream.
Bambi.

-Original Message-
Sent: Tuesday, February 19, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L

Actually, the Hercules graphics is able to generate graphics.  I had to
settle for Hercules since I could not afford a color monitor(using a CGA
card) back then.  So I looked for games, etc. that had a Hercules graphics
mode.  And, Hercules used twice the amount of pixels then CGA did, so I was
able to find emulation software that allowed me to play CGA color games on
my Hercules card.  It replaced the limited CGA color pallete with patterns
on the amber monitor.

Sigh.  The good old days...

-Original Message-
Sent: Monday, February 18, 2002 6:24 PM
To: Multiple recipients of list ORACLE-L


I do. User Friendly Interface. Hush, don't tell anybody, but I started with
Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole
machine has had a Hercules screen card (text only, no graphics) and 512KB
(no, it's not a mistake, it really is the letter "K") of memory. I still 
have those 3 big, grey boxes with 5 5.25" floppies which used to contain 
the whole installation. Unfortunately, I cannot install it because I no
longer have DOS 3.3 which was required for Oracle 4. 
Oh well, I seem to be getting old. 

-Original Message-
Sent: Monday, February 18, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L


Holy cow Mladen, what a memory!  

Does anybody else remember (or admit to) using UFI?

Jim

**

...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Conboy, Jim
  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: Gogala, Mladen
  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: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

[Bellows, Bambi]

  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: Bellows, Bambi
  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: Rollback Segments

[Bellows, Bambi]

Bjorn, you old coot, you've got me beat.  I do remember the UFI prompt
though... User Friendly Interface... and the "real geeks" would program
their own SQL*Plus environment using HLI (now OCI) with the OROL option
which would allow the rollback of a single statement rather than a whole
transaction.  Now, in my day, we had fire but we had to make our own coal
and we kept warm on the hides of old terminals that used to roam the plains.
What were things like in your day?

Bambi.


-Original Message-
Sent: Tuesday, February 19, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L

There must be somebody beside myself remembering version 3, which did not 
have read consistency - the great new feature of version 4.  In 3, doing

UFI> insert into emp select * from emp;

would cause anything from having 28 rows in emp till having and endless loop

in the kernel only finishing when your database file ran full...

Yep - we are some old bitter men around here...

/Bjørn.

On Tuesday 19 February 2002 06:43, you wrote:
> I remember the BI.ORA  (Before-Image) file, IOR and ODS in Oracle 5.
>
> Hemant K Chitale
> Principal DBA
> Chartered Semiconductor Manufacturing Ltd
>
>
> Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
> Sent by: [EMAIL PROTECTED]
>
> Please respond to ORACLE-L
>
>  To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
> Group) Subject: RE: Rollback Segments
>
>
>
>
>
>
>
>
> UFI no, but the rest... that's where I started in Oracle -- version 5
>
> --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote:
> > Holy cow Mladen, what a memory!
> >
> > Does anybody else remember (or admit to) using UFI?
> >
> > Jim
> >
> > **
> >
> > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Conboy, Jim
> >   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).
>
> __
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.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: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
  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: Bellows, Bambi
  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: Weird ODBC Issue

[Bellows, Bambi]

On one instance, APPS owns the tables and SCOTT has select and has a synonym
pointing at the table.  
On the other instance, SCOTT owns the table and there's no primary key
defined.
Just to be irritating, the latter instance shows the table, the former does
not.

Bambi.
-Original Message-
Sent: Monday, February 18, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L

The user needs to have select permissions on the table. I'm assuming they
are using the file,get external data, link tables and choosing ODBC data
sources method to get to the data. Does the user APPS/APPS own the tables?
Are there public synonyms on the tables? What ODBC driver are you using? I
feel the Merant drivers are the best. From my experience any user trying to
access the data this way was able to see all users.tablenames in the system
but did not have authority to access them. Access needs to define unique
keys to identify each record so it can update it. When attaching a table and
there is no PK access will ask you to pick a number of columns that will
make the record unique. Hope this helps.

> -Original Message-
> From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 12:35 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Weird ODBC Issue
> 
> I'm not exactly sure why, but I have a user who wants to see Oracle tables
> in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
> problem and look at tables from user_tables (not all_tables, which I find
> weird, but, what the hay).  But, if the user tries to go into APPS/APPS,
> he
> can only see one table, and that one is owned by ADS.
> 
> Anyone have similar problems?  Any clue as to a resolution?  Let me
> know...
> Yer pal,
> Bambi.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bellows, Bambi
>   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: Bellows, Bambi
  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: Weird ODBC Issue

[Bellows, Bambi]

No clue.  User installed.

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


What ODBC Driver are you using?  I've seen this with certain builds of
Microsoft's driver, really quirky on W98.


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


 

        "Bellows,

    Bambi"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
 Subject: Weird ODBC Issue

Sent by:

[EMAIL PROTECTED]

om

 

 

02/15/2002

11:34 AM

Please respond

to ORACLE-L

 

 





I'm not exactly sure why, but I have a user who wants to see Oracle tables
in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
problem and look at tables from user_tables (not all_tables, which I find
weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
can only see one table, and that one is owned by ADS.

Anyone have similar problems?  Any clue as to a resolution?  Let me know...
Yer pal,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bellows, Bambi
  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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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

RE: UNIX SCRIPT

[Bellows, Bambi]

Here's basically what you need to do:

1)  Write a script which determines which files to backup (hit the DBA and
V$ tables)
2)  Shutdown the database
3)  Once you have those files, use them as a driver in a for|while loop (for
each file, 
A)  Check if it's raw or UFS
if [ raw ] then use dd to backup
else use whatever you want (dd|cpio|tar)
to backup to disk|tape
write in the logfile what time you started this file copy
B)  if success, write to log
else try again and write to log
4)  Startup the database

This can, and should, all be in one script.  You can schedule this script to
kick off at midnight.

You can have another script, which you kick off to start at 5 which
1)  Checks to see whether the first script is running
2)  If it is, kill it and all its subprocesses
3)  Write to the first one's log file that it was killed at 5AM
4)  Start up the database

As for what the commands are to do all this, they are both easy and
time/space consuming to spell out, so I'll leave it to you.  It seems to me
that you are asking for a backup script.  There is a book from Oracle Press
on Oracle backups where you can type it in line by line from the book.

Have fun!
Bambi.
-Original Message-
Sent: Friday, February 15, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


HI LIST,

I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS
5.7.
I want to schedule this script to shutdown the database at mid night and
make a backup then start it up at 5:00 AM.
Any URL or link or any document it will be very helpful.




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

Weird ODBC Issue

[Bellows, Bambi]

I'm not exactly sure why, but I have a user who wants to see Oracle tables
in Access.  Whatever.  So, the user can go into our pal SCOTT/TIGER no
problem and look at tables from user_tables (not all_tables, which I find
weird, but, what the hay).  But, if the user tries to go into APPS/APPS, he
can only see one table, and that one is owned by ADS.

Anyone have similar problems?  Any clue as to a resolution?  Let me know...
Yer pal,
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

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

RE: Sql question

[Bellows, Bambi]

Why not try MINUS

Select x, y, z
>From tab
Where condition=1
Minus
Select x, y, z
>From tab
Where condition=2;

HTH,
Bambi.

-Original Message-
Sent: Tuesday, February 12, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L

Remco,

This is exactly what he wants - all records where the first one exists and
the second one does not exist.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, February 12, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


Thomas,

"NOT EXISTS" and "<>"  equals "must be at least one"

Right ?

That's not what Zsolt wants ... :-)

-Oorspronkelijk bericht-
Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 februari 2002 14:28
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: Sql question


Zsolt,

Try:

select a.something
,c.searchvalue

   from a,
b,
c
  where a.a= b.a
and b.b1= c.b1
and b.b2= c.b2
and c.searchvalue= 'first one' and
and not exists(select 1 from c c1
 where c1.b1 = c.b1
 and   c1.b2 = c.b2
 and   c1.searchvalue<> 'second one')
the above presumes that the columns b1 and b2 are part of the
identifying
columns for the c table.

hope this helps.


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, February 11, 2002 4:40 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have the following sql:

select a.something
,c.searchvalue

   from a,
b,
c
  where a.a= b.a

and b.b1= c.b1
and b.b2= c.b2

and c.searchvalue= 'first one' and
c.searchvalue<> 'second one'

The problem is that if a company has a record with  c.searchvalue=
'first 
one' then the
query above list it although it has another record with c.searchvalue= 
'second one'


To be more precise : I need to get the companies that have searchvalue =

'first one' but I don't want
to see companies that has 'second one'. (the main problem is with
companies 
that have both values)


Thank you





Zsolt Csillag,
Hungary

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

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

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

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

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

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

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

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

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

RE: ORA-01000: maximum open cursors exceeded

[Bellows, Bambi]

Yep, open_cursors has always been a freebie.  I can't help but think that an
extraordinarily high open_cursors has to cost some semaphores, but I've
managed to have very high open_cursors and very moderate semaphore settings
and not run into any problems.

HTH,
Bambi.

-Original Message-
Sent: Friday, February 08, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L

Dave,
When I ran into this error using AP Oracle Applications, I was told this
could be set as high as I wished with no performance hit up front (the
cursors are not allocated, only allowed).  In fact, the support analyst
couldn't come up with a good reason why it shouldn't be set to the maximum
for the platform (on Solaris at the time it was 1000).  I suspect there is a
reason, but getting the transactions through AP far outweighed the potential
performance impact ;) (I didn't see any, but was really chasing other,
larger performance issues at the time).  
Margaret
> -Original Message-
> From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 8:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-01000: maximum open cursors exceeded
> 
> 
> We had this error show up the other day. I am wondering if 
> there is a performance limit on how big you should set your 
> OPEN_CURSORS parameter in the SID.init file?  Mine currently 
> is set at 300.  Are there any guidelines on this setting?  
> Just wondering.
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   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: Murray, Margaret
  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: Bellows, Bambi
  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: FTP Exports

[Bellows, Bambi]

These things happen.  The partial file remains.  Best way to do it is to do
an ls -l on the transferred file on the host node then do it in ftp (to an
output file), compare the sizes, and if they match you're golden, and if
they don't, retry it.  

HTH,
Bambi.


-Original Message-
Sent: Friday, February 08, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L


I am FTPing exports in binary mode as a part of my backup/recovery plan.
What happens when the network connection is lost between FTP client and
server while a file is being transferred? Will an incomplete file appear on
the FTP server or would the FTP server sense the disconnect and remove the
partially transferred file? 

Thanks
Erik 



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

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

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

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

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

[Bellows, Bambi]

I'm a little confused.  It sounds like what you're trying to do is:

#!/bin/ksh
echo "Look at me!  I'm in a Unix script!"
sleep 5
sqlplus << EOF
system/incredibly_secret_password
select 'Look at me... here in SQL*Plus!  Life is grand!' 
from dual;
!echo "Where am I?  I'm so confused!  There's an orange elephant here!"
exit
EOF
echo "Wasn't that fun?"
exit

HTH,
Bambi.

-Original Message-
Sent: Friday, February 08, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L

I have a Unix batch script that calls a short (5 line) SQL script.  Is there
any way to include the SQL statements in the Unix script
instead of calling the SQL?
 
Ron Smith 
DBA 
Kerr-McGee Corp 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: Bellows, Bambi
  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: TFM

[Bellows, Bambi]

Keep thinking it, April, and feel free to send me an email when you feel
like you're going to explode.

-Original Message-
Sent: Friday, February 08, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L

THANK you!

I kinda had a hunch that life would change... When I worked for US Steel,
their Mississippi plant installed Financials and I had to send id IMS
data...  I wasn't wild about it then, and I wasn't directly connected.  I
just keep thinking... it's a learning experience... it's a learning
experience... 

April

-Original Message-
Sent: Thursday, February 07, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


April --

Get onto Metalink -> Top Tech Docs.  There's more there than you'll be able
to read in a lifetime.  One thing to know is that once you install
Applications, your life as a DBA *will* change.  

Good luck!
Bambi.   

-Original Message-
Sent: Thursday, February 07, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L

We are getting ready to sign a contract with Oracle for Financials.  I have
been looking for the manuals so I can read up on what their suggestions are
for installation, tuning... for the 3000+ tables and associated other back
end stuff... anyone know where they can be found.  I can find some on Oracle
Apps Net, but not really the kind of stuff I am looking for... are their
other?

April Wells
Oracle DBA
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-A6]N92!O=&AE
M2!B>2!R971Uhttp://www.orafaq.com
-- 
Author: April Wells
  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: Bellows, Bambi
  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: April Wells
  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: Bellows, Bambi
  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: TFM

[Bellows, Bambi]

April --

Get onto Metalink -> Top Tech Docs.  There's more there than you'll be able
to read in a lifetime.  One thing to know is that once you install
Applications, your life as a DBA *will* change.  

Good luck!
Bambi.   

-Original Message-
Sent: Thursday, February 07, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L

We are getting ready to sign a contract with Oracle for Financials.  I have
been looking for the manuals so I can read up on what their suggestions are
for installation, tuning... for the 3000+ tables and associated other back
end stuff... anyone know where they can be found.  I can find some on Oracle
Apps Net, but not really the kind of stuff I am looking for... are their
other?

April Wells
Oracle DBA
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  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: Bellows, Bambi
  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: Unorthodox 8i install/upgrade

[Bellows, Bambi]

Ditto here.  Me too!  Me too!  Me too!

Bambi.

-Original Message-
Sent: Thursday, February 07, 2002 1:05 PM
To: Multiple recipients of list ORACLE-L

I did the same thing too.  One of the advantage is when all of my servers
are at a data center physically located else where.  I don't need to phone
up a DC operator and have the CD put into the tray.

Richard

-Original Message-
Sent: Thursday, February 07, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


I have installed 8.1.7 on a Tru64 5.1 system.  I simply copied the CD's into
separate directories on
our NFS mounts, then logged into the system where I wanted to do the
install, found the
installer program, and ran it.  I don't remember there being any problems.

I did the same thing when I went to patch 8.1.7, I untarrred the patch onto
my NFS mount, 
then I could apply the patch to any of my systems from one central location.

Darren

-Original Message-
Sent: February 6, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


Environment:
  Tru64 V5.1 on Alpha 4100/8100
  ORA 8.0.6

I have upgraded our sandbox system to 8.1.7.2 last month, and will be
upgrading several other machines shortly.  The problem is the stage &
ORACLE_HOME mount points have insufficient disk space and our systems folks
have told me that it will be very difficult to add any more space to these
mount points.  There are other mount points that currently have enough
space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a
directory other than under /oracle/stage, or used a symbolic link to
download the CD's contents to another directory? Or broken out the
ORACLE_HOME subdirectories onto more than one mount point?  Any suggestions
would be greatly appreciated.

Thanks,
Mike Hand
Polaroid Corp
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: Browett, Darren
  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: Ji, Richard
  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: Bellows, Bambi
  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: ADI Warning

[Bellows, Bambi]

Dennis --

Go ahead, rub it in.  

=)

(thanks)
Bambi.

-Original Message-
Sent: Wednesday, February 06, 2002 3:15 PM
To: Multiple recipients of list ORACLE-L

Bambi - Obviously you've gone in so deep you forgot how dumb some of us are.
To stem a tide of questions "what the heck is ADI", here it is.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


ORACLE APPLICATIONS DESKTOP INTEGRATOR 11i 
Oracle(r) ADI is a spreadsheet-based extension to Oracle Applications that
offers full cycle accounting and asset management within the comfort and
familiarity of a spreadsheet. ADI combines a spreadsheet's ease of use with
the power of Oracle Applications to provide true desktop integration during
every phase of the accounting cycle. You can create budgets, record
transactions, add assets, reconcile inventory, define and publish reports
from any application to the web, a spreadsheet, or standard text output, and
you can even perform account drilldown and analysis-all without leaving the
desktop. 
 

-Original Message-
Sent: Wednesday, February 06, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


Friends --

Lately I've been relegated to the deepest recesses of the dark murky depths
of Oracle's product line.  I see you blithely exchanging DBA mail and look
on longingly, pining for the fjords, as it were.  But I digress.

If you every have to install ADI on a PC, make sure it doesn't have any
Oracle products installed on it.  Make sure there are no Oracle directories
either in C: or in C:\Program Files.  If you do, you will not be able to
install ADI, and must deinstall all existing Oracle products before
installing ADI, which, graciously, comes with SQL*Plus and SQL*Net.
Everything else needs to be reinstalled.  Oh, and that old TNSNAMES.ora file
you have hanging around, it don't mean anything to ADI.

I just can't fathom why Oracle would do this to itself.  I hope its foot
starts feeling better soon.

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

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

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

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

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

ADI Warning

[Bellows, Bambi]

Friends --

Lately I've been relegated to the deepest recesses of the dark murky depths
of Oracle's product line.  I see you blithely exchanging DBA mail and look
on longingly, pining for the fjords, as it were.  But I digress.

If you every have to install ADI on a PC, make sure it doesn't have any
Oracle products installed on it.  Make sure there are no Oracle directories
either in C: or in C:\Program Files.  If you do, you will not be able to
install ADI, and must deinstall all existing Oracle products before
installing ADI, which, graciously, comes with SQL*Plus and SQL*Net.
Everything else needs to be reinstalled.  Oh, and that old TNSNAMES.ora file
you have hanging around, it don't mean anything to ADI.

I just can't fathom why Oracle would do this to itself.  I hope its foot
starts feeling better soon.

Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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).

Looking for FM T R

[Bellows, Bambi]

Title: RE: HOW TO KNOW INDEX NOT IN USE?









Friends -

Once upon  a time, a very long time ago, I
had a large black notebook.  I found
it in my cube when I moved into it in 1985.  I think it was from v4 days as it was
old and dog-eared and we were currently on v5.0.14 or thereabouts.  Anyway, this notebook was a tutorial
that Oracle put out on all its wonderful features in SQL*Plus, based on
SCOTT/TIGER.  There were queries and
joins and correlated subqueries and uncorrelated subqueries. 
There was GROUP BYs  and CONNECTs.  There
were UNIONs and INTERSECTs
and MINUSs. 
There were DECODEs and NVLs
and lots of different DATE functions. 
There were tricks to do with MOD, and ABS and SIGN, and the 101 ways to
spend your vacation in the DUAL table. 
Overall, it was a grand frolic of SQL, and, geek that I am, I really
enjoyed it.

Of course, I left that notebook in the cube when I left the
company having gone through the book to teach myself SQL after long years of
QUEL.  The years have gone by, and
now I'm in a new company with a lovely boss who's an old geek too,
but on the IBM side.  This is his
first exposure to Oracle and I wanted to get him a grand frolic through the
non-ANSI standard extensions of Oracle, and would have *thought* that a book similar to my old
black notebook but even bigger and better would still be in existence
somewhere.

But try as I may, I can't find anything like it.  In fact, even getting a vanilla 5 page "this
is scott/tiger" set of introductory exercises
is not as easy as one might think.  I'm
going to snag one off of google.  But, in the meantime, does anyone know
of an online version of "this-is-all-the-cool-sh*t-you-can-do-in-Oracle-whether-or-not-its-ANSI-standard-(ANSI-is-for-wimps-anyway)"
floating around?  

So as not to pester the List, if you could email me directly,
that would sure be swell.  And, as always, your thoughts are
appreciated.

 

Best wishes!

Bambi.

RE: NOHUP SQLPLUS

[Bellows, Bambi]

Dick --

You're kidding.  If you do

nohup  & 

it should stay up indefinitely.  Nohup stands for "no hang up" which would
have been, in the old days if your terminal timed out and the connection was
severed over the phone line.  Using nohup would guarantee your job ran to
completion.  The trick is to run it in background.  That's what the
ampersand does for you.

I've run really long and complicated stuff via nohup and never had a
problem.  If you have, then I suppose we should say which OSs it worked on
and which it didn't.  I've run nohup without problem on AIX, HP-UX, SunOS,
Solaris, 88Open and Irix.  

HTH,
Bambi.

-Original Message-
Sent: Monday, February 04, 2002 1:31 PM
To: Multiple recipients of list ORACLE-L

Erik,

In my experience a nohup will die with your terminal session.  Best bet
would be to use 'at'.

Dick Goulet

Reply Separator
Author: Erik Williams <[EMAIL PROTECTED]>
Date:   2/4/2002 11:12 AM

I am going to be executing a long running job this weekend from home. I am
going to VPN into the corp network and telnet to the server. I am affraid of
loosing my telnet terminal session and the job dying mid way through. The
plan is to use 'nohup sqlplus system/* @long_running.sql'. Has anyone
used this or run into issues using it? Every time I assume something will
'just work', IT DOESNT!

Thanks
Erik 

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

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

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

[Bellows, Bambi]

Erik --

Nohup is fine.  There are environment issues if you want to cron it, but
nohup is fine and dandy.  Have fun!

Bambi.

-Original Message-
Sent: Monday, February 04, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L

I am going to be executing a long running job this weekend from home. I am
going to VPN into the corp network and telnet to the server. I am affraid of
loosing my telnet terminal session and the job dying mid way through. The
plan is to use 'nohup sqlplus system/* @long_running.sql'. Has anyone
used this or run into issues using it? Every time I assume something will
'just work', IT DOESNT!

Thanks
Erik 

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

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

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

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

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

RE: is it f*ing f*day yet? / ORACLE-L Digest -- Volume 2002, Num

[Bellows, Bambi]

Yer jist not lookin at it from tha rite perspective.  Take a look at rock
lyrics...

" 'Cause I'm the only one who'll walk across the fire for you "

Now translate it literally into French...

"  'rseque Je'm le seulement on qui'll march une croix un feu pour tu "

Modify it so it rhymes (classic element of rock lyrics)

And *POOF* hours of entertainment for yourself and your Francophile friends!

Luf,
Bambi.

-Original Message-
Sent: Friday, February 01, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L

rant:

"bcoz" 

"u" ??

"shud" 

"ur" ??


maybe I'm just being an *sshole, but does anyone else find 
this kind of "cutsie" mutiliation of the english language 
nauseating, insipid, banal, inane, egregious, atrocious, 
deplorable, heinous, monstrous, outrageous, preposterous, 
autocratic, dictatorial, despotic, tyrannical, absolutist, 
violating of all good/beauty/truth in the universe, just 
basically completely f*ing stupid, etc
?


ORACLE-L Digest -- Volume 2002, Number 032
> > JoJo, i'm also not a HiFi DBA like those few, and my purpose of being in
> > the list is to gain more knowledge. What i feel is that nobody has the
> > right to be arrogant, just bcoz the question is below their dignity to
> > answer. It wastes their time but if they only want complex questions
> > they shud form their own mailing lists.
> > 
> > having said that, what i feel is that you shud do a bit of RTFM
> > rather than getting a cooked answer becuase that helps in ur
> > development too. who knows trying to find an answer to one query u
> > may hit upon new things in the manuals. 
> 


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

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

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

[Bellows, Bambi]

TUNE??  

-Original Message-
Sent: Thursday, January 31, 2002 6:30 AM
To: Multiple recipients of list ORACLE-L

Bambi,
Thanks for the heads up. How was the response time on the apps if it
relied on an outside location for some of it's work? Most be a nightmare
to tune that sucker.
ROR mô¿ôm

>>> [EMAIL PROTECTED] 01/30/02 05:10PM >>>
So our internal consultants from a-certain-company-we-all-know-and-love
call
me because one of their pages in Vision is not coming up.  Of course,
Metalink was down, so I couldn't look into it.  I posted a question
here to
see if anyone ever had a similar problem.  No response, so I'm assuming
"no"
(or that I'm being redirected to people's trashbin due to all my
discussions
of life in the good old days).  Anyway, Metalink comes up, and, would
you
believe it?, go tell it on the mountain!, their app mysteriously comes
up,
at the same time.  Coincidence?  Hmm.  So, while these %@$& are
sniffing
around inside *Received: from CONNECT-MTA by galottermy* beautiful,
immaculate database for problems, I call
said-same-company-we-all-know-and-love on the phone.  (I love this
"we're
all on the same team" bullsh*t.)  Seems that the Vision instance has
loads
of links to internal Oracle sites, and when Oracle went down, well

 
Anyway, BE AWARE, if you're running Vision, about 20% of your app, by
default, is served outside your own environment, meaning that
approximately
20% of the problems you will have will be outside your control.  Oh,
and
that teamwork thing works real well when you're helping "other people",
or
when things are rosy... they don't seem to work so good when they're
having
problems and looking for a way to deflect blame.  Surprise, surprise,
surprise.

Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Bellows, Bambi
  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: Bellows, Bambi
  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: OPS$

[Bellows, Bambi]

Well, yes, the can set their name to SYSTEM, SYS, SCOTT, whatever, and so
long as your authentication demands an OPS$ or basically any other non null
string of characters, who cares?  OPS$SYSTEM is not going to wind up being a
DBA... now, if OPS$STILL is a DBA, and someone sets their PC to STILL, then
you've got a problem.  

The long and short of it is that the OPS security is only as good as the box
it is serving.  If you're on any computer with C level security or higher,
there is nothing wrong with using OPS$ as you are using operating system
level security.  So, if, for example, you are using VMS, MVS, CDC, Cray, or
anything us old folks might have used 10 years ago, OPS$ is terrific.  If
your operating system is making Bill Gates richer, you have no security to
speak of.  

The question you want to ask yourself is how good is your front-end
security?

-Original Message-
Sent: Wednesday, January 30, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L

Can you explain that?  You have me scared now.

-Original Message-
Sent: Wednesday, January 30, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L


They can also set their username to 'SYSTEM'.

Jared





Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/30/02 11:25 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: OPS$


anyone can name their pc "oracle" and then connect in if you set
"remote_os_authent"


--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> Does anyone have any information on security problems using the OPS$
> account? 
> 
> Ron
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: Bellows, Bambi
  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 messa

Teamwork teamwork rah rah rah!

[Bellows, Bambi]

So our internal consultants from a-certain-company-we-all-know-and-love call
me because one of their pages in Vision is not coming up.  Of course,
Metalink was down, so I couldn't look into it.  I posted a question here to
see if anyone ever had a similar problem.  No response, so I'm assuming "no"
(or that I'm being redirected to people's trashbin due to all my discussions
of life in the good old days).  Anyway, Metalink comes up, and, would you
believe it?, go tell it on the mountain!, their app mysteriously comes up,
at the same time.  Coincidence?  Hmm.  So, while these %@$& are sniffing
around inside *my* beautiful, immaculate database for problems, I call
said-same-company-we-all-know-and-love on the phone.  (I love this "we're
all on the same team" bullsh*t.)  Seems that the Vision instance has loads
of links to internal Oracle sites, and when Oracle went down, well 
 
Anyway, BE AWARE, if you're running Vision, about 20% of your app, by
default, is served outside your own environment, meaning that approximately
20% of the problems you will have will be outside your control.  Oh, and
that teamwork thing works real well when you're helping "other people", or
when things are rosy... they don't seem to work so good when they're having
problems and looking for a way to deflect blame.  Surprise, surprise,
surprise.

Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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).

Cannot display page

[Bellows, Bambi]

Hi folks. 
I have an apps person who is trying to display iProcurement's
homepage and cannot open the page.  Some
other pages open, some other pages don't. 
I can't see the difference between thems
that does and thems that don't.  I'd check metalink,
but I can't open the page.  Does
this sound familiar to anyone?

 

Thanks!

Bambi.

RE: Answer to SCOTT/TIGER

[Bellows, Bambi]

Anybody ever notice in the Index of v6's DBA manual had an entry for "Bert
and Ernie" and a page number, although there was no reference for Bert or
Ernie on the page?

Of course, what could compare with Digital's HELP DATATRIEVE WOMBAT ? Or VMS
v4's C Language manual with all those gay references... printf("I saw four
men with moustaches on Christopher Street!\n");  Ah, those were the days...
back when people still had a sense of humor...

Bambi.  (Still living in the past where the rent is cheaper)

-Original Message-
Sent: Wednesday, January 30, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L

Here is the answer:
 SCOTT, is the last name of  Bruce Scott, who was the early Developer
working with Bob Miner (Larry's Technical Partner in 1980), 
 TIGER, was the name of Bruce's cat. 

Source: "Oracle8i for Dummies" Foreword by Ned Dana, who worked with Bruce
and Bob in rewriting the Oracle Version 3.0 in C, back then.


After all, this book has some neat things :) 

- Kirti 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: Bellows, Bambi
  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: Microsoft plans to bundle iFS copycat into it operating syste

[Bellows, Bambi]

WARNING!  POSSIBLE REPOST!  WARNING!  POSSIBLE REPOST!  WARNING!

Folks --

This bounced back to me... so you may have gotten it twice.  If you did,
please delete this posting.

YOU HAVE BEEN WARNED!  YOU HAVE BEEN WARNED!  YOU HAVE BEEN WARNED!  


Maks --

They are different.  Edlin was a line editor that showed the screen.  In
that, it was in the same family as many of the older editors from the era of
the switchover from linewriters (e.g., DECWriters) to terminals (e.g.,
tvi912c, vt52, beehive, etc).  Various operating systems had written
bastardized editors which attempted to make use of the advantages screens
provide (paging up and down) while simultaneously giving the advantages of
the old line editors.  Many [dead] operating systems used modes (e.g.,
Vulcan), others transitioned slowly to screen-based editors (e.g., vi, TPU).

Now, DOS, being originally QDOS (Quick-and-dirty Operating System) was a
huge rip-off of early VMS (v4) and BSD Unix.  Edlin was a screen based line
editor where you could *see* things in lines other than the one you were
working on, but couldn't really do anything with them.  In this, it most
closely resembles ed of the currently extant Unix editors.  sed, is and
always has been, a stream editor.  It takes as input a number of characters,
processes them, and then produces a number of characters as output.  Yes,
sed commands can be used within vi, as ed commands can, but sed as a stand
alone tool has nothing whatsoever to do with edlin.  As for timeframes, I
believe sed predates edlin by a hair, although it is newer technology.

Of course, back in my day, we had 1s and 0s, and we ate mice if we could
catch them.  That's why mice have strings attached to them.  They look like
cables, but actually they're just wires holding the mice in place in case
there's ever a techfamine like in the old days.  A lot of mice came over
from the pogroms in the old country.  And printer cables too.  But that's a
story for another day.

Oh, yes, back in the old days, shift-6 was a cents key.  It was easier
putting in your $0.02.  

HTH,
Bambi.

-Original Message-
Sent: Tuesday, January 29, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L


Well, since sed was in use while BG was still in high school...

Jared

On Tuesday 29 January 2002 13:27, Michael Kline wrote:
> I thought edlin was sort of a copy of "sed"... Which came first?
>
> Maks.
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin,
> > Patrice J Sent: Tuesday, January 29, 2002 2:53 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Microsoft plans to bundle iFS copycat into it operating
> > syste
> >
> >
> > I think they wrote edlin, but that was years ago.
> >
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
-- 
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: Bellows, Bambi
  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: adpatch question

[Bellows, Bambi]

Title: RE: adpatch question









Matt (and any others who are interested) -

 

My adpatch went
fine after tinkering under the hood except for one place where Oracle created a
table, populated it and blew away its max extents.  Amusing, but lame.  I can't speak for Oracle on this
one, but it looks to me that if you wind up in the position I was (that is to
say screwed) that is the way to fix it.

 

Another thing to bear in mind is that the
hidden option (8) in adctrl should NOT be selected
unless the workers are actively working. 
If ps -ef
worker does not show any workers, do NOT quit an active process.  You are better off, at that point, to
rerun adpatch without killing anything and letting adpatch attempt to clean up after itself.

 

HTH,

Bambi (head under the
hood gal).

 

-Original Message-
From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 29, 2002
3:28 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: adpatch question

 

If he's not interested, I am.  Please post a
summary 
upon completion. 

Matt 

 
Matt Adams - GE Appliances -
[EMAIL PROTECTED] 
 
"That is the top of the
calibration target, 
that is NOT in fact a
monolith" 
  - NASA TV Commentator -
7/5/1997 

> -Original Message- 
> From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, January 29,
2002 2:53 PM 
> To: Multiple recipients of
list ORACLE-L 
> Subject: RE: adpatch question

> 
> 
> John -- 
> 
> Thanks for the email
back.  Apps suck, and going under the 
> hood is not for 
> the weak of stomach.  Of
course, I'm not... and, at this 
> point, fighting a

> fire is more fun than watching
a heap of smoldering ashes.  
> So, I did it.  I

> went under the hood, and found
that the fnd_install_processes 
> table has one 
> entry for each worker plus one
for worker 0, which, I assume, 
> is the driver. 
> The status for 0 was W, 1-3
was R and 4 was J.  I changed 4 
> to R and re-ran 
> and, so far, at least,
everything is fine.  650 jobs have 
> run, so, I think

> that if anything dangerous
would have happened it would have 
> happened by 
> now.  It's just
irritating.  I'm off to explore how to run a .jlt file 
> manually... maybe I could find
an FM somewhere to R. 
> 
> I'll let you know how this
finishes if you're interested... 
> Bambi. 
> 
> -Original Message-

> Sent: Tuesday, January 29,
2002 1:15 PM 
> To: Multiple recipients of
list ORACLE-L 
> 
> Bambi, 
> 
> I wouldn't touch *anything*
under the hood as far as Apps 
> goes, esp. 11i. 
> Raise a TAR and let Oracle
Support come back to you on this. 
> I assume that 
> you are testing the upgrade
and not actually doing it. These 
> sort of things 
> should have been ironed out
prior to the upgrade with lots of 
> iterations on 
> lots of clones. A 11i upgrade
is NOT for the faint of heart. 
> 
> Sorry - but that's what I
would recommend! 
> 
> John Kanagaraj 
> Oracle Applications DBA

> DBSoft Inc 
> (W): 408-970-7002

> 
> Fear is the darkroom where
Evil develops your negatives. 
> Wanna break free of fear?
Click on 'http://www.needhim.org'

> 
> ** The opinions and statements
above are entirely my own and 
> not those of my 
> employer or clients **

> 
> 
> > -Original
Message- 
> > From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] 
> > Sent: Tuesday, January
29, 2002 10:21 AM 
> > To: Multiple recipients
of list ORACLE-L 
> > Subject: adpatch question

> > 
> > 
> > 
> > Hi Folks! 
> > 
> > I'm in the middle of an
11.5.5 upgrade.  Now, if you've done 
> > that type of

> > thing before, you know
those suckers just run forever, and if 
> > you leave it

> > running overnight, you
generally come in the next day to find 
> > that things

> > failed overnight. 
Well, that's where I was.  I left this 
> > sucker to run

> > overnight, and, when I
came in, sure enough, worker 4 had 
> > crapped out with a

> > java error.  I
checked metalink, and it said skip it, and 
> > when you're done

> > with 1808429 (the 11.5.5
upgrade patch), just run 
> > asfakreg.jlt manually.

> > Fine.  No big
deal.  I went into adctrl and everything was in 
> > a wait state

> > except for ol number 4
which crapped out.  I chose hidden 
> > option 8 (skip

> > this thing) and the
status changed to Skip & restart.  Great. 
> >  Except it

> > didn't.  Evidently,
having no response for X amount of time, 
> > all my workers

> > stopped.  Again, no
big deal, just re-run adpatch and let it 
> > start where it

> > crapped out. 

RE: adpatch question

[Bellows, Bambi]

John --

Thanks for the email back.  Apps suck, and going under the hood is not for
the weak of stomach.  Of course, I'm not... and, at this point, fighting a
fire is more fun than watching a heap of smoldering ashes.  So, I did it.  I
went under the hood, and found that the fnd_install_processes table has one
entry for each worker plus one for worker 0, which, I assume, is the driver.
The status for 0 was W, 1-3 was R and 4 was J.  I changed 4 to R and re-ran
and, so far, at least, everything is fine.  650 jobs have run, so, I think
that if anything dangerous would have happened it would have happened by
now.  It's just irritating.  I'm off to explore how to run a .jlt file
manually... maybe I could find an FM somewhere to R.

I'll let you know how this finishes if you're interested...
Bambi.

-Original Message-
Sent: Tuesday, January 29, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L

Bambi,

I wouldn't touch *anything* under the hood as far as Apps goes, esp. 11i.
Raise a TAR and let Oracle Support come back to you on this. I assume that
you are testing the upgrade and not actually doing it. These sort of things
should have been ironed out prior to the upgrade with lots of iterations on
lots of clones. A 11i upgrade is NOT for the faint of heart. 

Sorry - but that's what I would recommend!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Fear is the darkroom where Evil develops your negatives. 
Wanna break free of fear? Click on 'http://www.needhim.org'

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 29, 2002 10:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: adpatch question
> 
> 
> 
> Hi Folks!
> 
> I'm in the middle of an 11.5.5 upgrade.  Now, if you've done 
> that type of
> thing before, you know those suckers just run forever, and if 
> you leave it
> running overnight, you generally come in the next day to find 
> that things
> failed overnight.  Well, that's where I was.  I left this 
> sucker to run
> overnight, and, when I came in, sure enough, worker 4 had 
> crapped out with a
> java error.  I checked metalink, and it said skip it, and 
> when you're done
> with 1808429 (the 11.5.5 upgrade patch), just run 
> asfakreg.jlt manually.
> Fine.  No big deal.  I went into adctrl and everything was in 
> a wait state
> except for ol number 4 which crapped out.  I chose hidden 
> option 8 (skip
> this thing) and the status changed to Skip & restart.  Great. 
>  Except it
> didn't.  Evidently, having no response for X amount of time, 
> all my workers
> stopped.  Again, no big deal, just re-run adpatch and let it 
> start where it
> crapped out.  Well, now we run into a big deal, because it 
> can't change the
> status from Skip & restart to anything that will allow 
> adpatch to start
> again (like, maybe, failed where it was before I "fixed" it).  
> 
> I'm thinking of going under the sheets, finding the $%^&* 
> table and updating
> the status myself.  Anyone have any reason why that's not 
> such a great idea?
> Anyone have any other sneaky ways to change the status?  
> Anyone have a list
> of the hidden options that Oracle doesn't tell you about 
> (like ol number 8
> there?)?
> 
> aTdHvAaNnKcSe!
> Bambi.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bellows, Bambi
>   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: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

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

adpatch question

[Bellows, Bambi]

Hi Folks!

I'm in the middle of an 11.5.5 upgrade.  Now, if you've done that type of
thing before, you know those suckers just run forever, and if you leave it
running overnight, you generally come in the next day to find that things
failed overnight.  Well, that's where I was.  I left this sucker to run
overnight, and, when I came in, sure enough, worker 4 had crapped out with a
java error.  I checked metalink, and it said skip it, and when you're done
with 1808429 (the 11.5.5 upgrade patch), just run asfakreg.jlt manually.
Fine.  No big deal.  I went into adctrl and everything was in a wait state
except for ol number 4 which crapped out.  I chose hidden option 8 (skip
this thing) and the status changed to Skip & restart.  Great.  Except it
didn't.  Evidently, having no response for X amount of time, all my workers
stopped.  Again, no big deal, just re-run adpatch and let it start where it
crapped out.  Well, now we run into a big deal, because it can't change the
status from Skip & restart to anything that will allow adpatch to start
again (like, maybe, failed where it was before I "fixed" it).  

I'm thinking of going under the sheets, finding the $%^&* table and updating
the status myself.  Anyone have any reason why that's not such a great idea?
Anyone have any other sneaky ways to change the status?  Anyone have a list
of the hidden options that Oracle doesn't tell you about (like ol number 8
there?)?

aTdHvAaNnKcSe!
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: sqlplus question

[Bellows, Bambi]

Sure.  Depending on your operating system, you can submit it through a
scheduler (e.g., cron, submit, etc.).  If you don't have a snazzy-dazzy
scheduler, you can use as part of the where condition something like
to_char(sysdate,'DAY') in ('MONDAY','WEDNESDAY','FRIDAY'); or whatever.  Or
you can class it up with whenevers.

HTH,
Bambi.

-Original Message-
Sent: Monday, January 28, 2002 4:21 PM
To: Multiple recipients of list ORACLE-L

Hello,
I need to run some script using Oracle Sqlplus.  The script is only suppose
to run certain days of week.
Does anyone have a suggestion how to do that.

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

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

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

[Bellows, Bambi]

RTFM.  ;)

-Original Message-
Sent: Monday, January 28, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L

HELP

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


Walt started it. 


-Original Message-

Ahem...

Is this thing on? 

OK.

For those of you that are new, have short memories or are easily confused,
this post was not serious.  It was a joke.  One look at the senders 
address
will confirm that.

How do I turn this thing off?

Jared
( the list owner,  SA, OCP and Part Time Perl Evangelist )


















-- 
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: Weaver, Walt
  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: Bellows, Bambi
  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: Time Question

[Bellows, Bambi]

Yep, so long as there was a timestamp on the records.

-Original Message-
Sent: Thursday, January 24, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L

I am not sure how to ask this or if it is even possible.  I have a stored
procedure that runs every five minutes and writes the data to a table.  I
want to query every thirty minutes and group the rows from the last half
our.

would I used date difference?


Thank you in advance
lance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lance Prais
  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: Bellows, Bambi
  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: Backup Strategy

[Bellows, Bambi]

ET: [EMAIL PROTECTED]

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

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

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

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

[Bellows, Bambi]

_ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog... her
guppy, MANAGER, having olfactory powers beyond those of normal guppies,
would always get upset by the smell coming out of _ON_INSTALL's bin, and
would mouth "Change _ON_INSTALL's bin litter!"  But, you know, reading guppy
lips is a long and complicated affair, and Scott's mother-in-law's contact
lenses would fog up about half way through.  

Sheesh.  I thought this was in all the books.

HTH,
Bambi.

-Original Message-
Sent:   Wednesday, January 23, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SCOTT/TIGER

So who was SYS, and why on earth did s/he name his/her pet
"CHANGE_ON_INSTALL"???

:-)

>>> [EMAIL PROTECTED] 24/1/2002 12:00:27 >>>
This message has been scanned by MAILSweeper.


The name I was given is Scott Gossett.  My team leader and one 
of our team members took the advanced seminars last year, and 
their instructor was Scott, and he admitted his notoriety.

-Original Message-
Sent: Wednesday, January 23, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L


there are several instructors named Scott how do you know which one
it is or even if it's one of the instructors?


--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote:
> Ok...it's true.  Take the Oracle Technical seminars and you too may
> get to meet Scott, Live and In Person.  Unfortunately, Tiger is
> waiting
> for Scott at the Rainbow Bridge, but Scott is still there (at least
> he was last year...you know how Oracle's been lately).
> 
> -Original Message-
> Sent: Wednesday, January 23, 2002 10:26 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I was once told with certainty from an Oracle instructor that Scott
> was
> an early developer, and Tiger was his cat.  But without actually
> meeting
> Scott I take this with a grain of salt.  I expect there are many
> urban
> legends surrounding this.  
> 
> Jim
> 
> -Original Message-
> Sent: Wednesday, January 23, 2002 11:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Anyone out there know the history of this?
> -- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED] 

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

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




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arn Klammer
  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: Babich , Sergey
  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: h

RE: SCOTT/TIGER - the rumor mill

[Bellows, Bambi]

I heard that CALVIN/HOBBS was taken.  No seriously, the girlfriend's cat
story is at least 18 years old.  Never heard of a pet iguana named CAPSLOCK
though.

Bambi.

-Original Message-
Sent: Wednesday, January 23, 2002 1:11 PM
To: Multiple recipients of list ORACLE-L

I heard from unnamed sources that it was a developer named Tiger and Scott
was his monkey.

Unknown

-Original Message-
Sent: Wednesday, January 23, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L


I was once told with certainty from an Oracle instructor that Scott was
an early developer, and Tiger was his cat.  But without actually meeting
Scott I take this with a grain of salt.  I expect there are many urban
legends surrounding this.  

Jim

-Original Message-
Sent: Wednesday, January 23, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L


Anyone out there know the history of this?
-- 
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: Conboy, Jim
  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: Farnsworth, Dave
  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: Bellows, Bambi
  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: Connecting INGRES using database link

[Bellows, Bambi]

Golly, that looks an awful lot like VMS.  I think what it's trying to tell
you is that the node you specified is not reachable, or that the SID you've
specified is not on the node listed.  There's some kind of connection
problem there.  Try doing a select from the Ingres side over the connection.
If it works, I don't know what to tell you.  If it fails, drop and recreate
the connection string.

The important thing is that this error is NOT an Oracle error... it is a
wrapper around what it's getting from the Ingres side... and it looks for
all the world like it's not purely an Ingres error either.  That "E_" is a
VMS level error (W would be "warning", F would be "fatal").  Unfortunately,
I've been largely off of VMS since 93, so I'm not going to be able to help a
lot there either.

Wish you would have asked this question about 10 years ago...  ;)
Bambi.

-Original Message-
Sent: Tuesday, January 22, 2002 9:05 PM
To: Multiple recipients of list ORACLE-L

thank you Bambi.

I already tried to create database link using HSODBC, but failed. It
returned this messages :

==
SQL> select * from cond@hsodbc;
select * from cond@hsodbc
 *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES
driver][INGRES]E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
Internal service status E_GC0132 -- User provided a vnode as part of the
database name (vnode::dbname), but connection information for that vnode
i (SQL State: S1000; SQL Code: -38100)
ORA-02063: preceding 6 lines from HSODBC

==
Is someone familiar with this kind of error...

TIA,

Holly

-Original Message-
Sent: Wednesday, January 23, 2002 4:20 AM
To: Multiple recipients of list ORACLE-L


Holly --

It has been a long time since I have done Oracle and Ingres at the same
time
(about 12 years (Oracle v6/Ingres v5)).  Back then, while there was
"kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able
to
access each other directly.  Generally, data transfers were to and from
flat
files, and queries between objects in the two databases utilized a third
party tool (Passport).

HTH,
Bambi.

-Original Message-
Sent: Monday, January 21, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L

Dear all,
Can I create database link using generic connectivity (ODBC)? Was there
someony already try this?
I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on
VAX/VMS.

TIA,

Holly
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ahmadsyah Alghozi Nugroho
  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: Bellows, Bambi
  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: Ahmadsyah Alghozi Nugroho
  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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Networ

RE: DBA Vs Apps DBA

[Bellows, Bambi]

On the consulting side, I've seen both.  The way I've seen it is if they ask
for an "Apps DBA" the rate is lower than for a DBA, but if they ask for "a
DBA with [Financials|Manufacturing]" the rate is higher.

HTH,
Bambi.

-Original Message-
Sent: Monday, January 21, 2002 3:06 PM
To: Multiple recipients of list ORACLE-L

-Original Message-
Sent: Monday, January 21, 2002 2:41 PM
To: Multiple recipients of list ORACLE-L



The DBA has more responsibility, usually more experience (this usually
translates into higher pay as well) than Apps DBA. 

Well, yes and no.  I have seen many orginizations pay the Apps DBA more,
because of the "Specailized" knowledge they have.  


Jon Baker   
Database Architect 
<[EMAIL PROTECTED]> 
www.netsec.net  

 

Terry 

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

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

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

[Bellows, Bambi]

Yep.  Rested.  That's me.  A.

Thanks!

-Original Message-
Sent: Friday, January 18, 2002 4:11 PM
To: Multiple recipients of list ORACLE-L

Bambi,

Boy you ARE rested!!  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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).

Resource management

[Bellows, Bambi]

Hi Guys!

 

Hope everyone had a good holiday.  I'm back from 3 weeks off and
feeling rested.  Maybe a bit too
rested.

 

I got a question on whether Oracle has a concept of resource
management... that is, if user X consumes too much CPU time, or the query
runs too long, whether there is some way to enter limits into Oracle which will
kill the query and, based on rules, resubmit it for a different time.  I thought the answer was yes because it
sounded so dang familiar... now I'm not sure if it was Oracle or Ingres or Sybase or SQL Server, or whether it was something
that could be set from Financials.  

 

Your help, as always, is appreciated!

Bambi.

RE: KSH Scripting Questions

[Bellows, Bambi]

Yeah, I did that a fair amount, too.  It depends on whether you're going to
do all your monitoring from your script, or whether you're going to go and
fire off a zillion monitors and let them fly on their own.  If you're doing
it all in the same script, then it becomes easy... for machine in `x y z` do
all these things synchronously.  If you fire them off until X monitors are
running or fire them all off at once to run asynchronously, you need another
method to determine what fails and what doesn't.  I found that the best way
of doing it is to have a  that gets touched when the
rcp/rsh happens and removed when the rcp/rsh terminates, then have another
process that sits in a 30 second wait loop to see if any of these processes
have been running over Y minutes.  Of course, if you want to customize the
crap out of it (I always did) you could have the time allowable to be per
type or by machine (or both)... for example, if you just want to see if the
listener is up, that is going to take much less time to test than if you're
running a backup.  Anyway, I suspect that you're going to find that nohup is
your friend, but that you're not going to want to keep a log of it, because
if you're doing what I think you're doing, it's going to get very big very
fast.

OH.  One thing.  If you going to have a master process and a waiter in a
loop and you're going to run this on multiple machines, you may want to set
up a process on a different machine to monitor your master on your main
machine, and, if it goes down, copy over all the log files and start the
monitoring from the remote machine.  Then keep checking to see if you're
main machine comes back, and, if so, copy over the logs, quit processing and
let your master machine have the reins again.

HTH,
Bambi.   

-Original Message-
Sent: Monday, December 10, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L

The monitors are independent.  They are used to verify that rcp/rsh programs
work correctly.  We have been having troubles where rcp and rsh programs
fail on one end and never return with a good or bad return code.   We wanted
the monitor to tell us if the program did not come back in a reasonable
times.  It does this by checking the existance of a  file that is created at
the begining of the process and deleting the file at the end of the process.

-Original Message-
Sent: Monday, December 10, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L


Kevin --

Is your program supposed to find all the monitors it starts and kill them
cleanly, or are the monitors supposed to run independently once kicked off?

IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running
the job is $$.  You can grep the processes for any subprocesses you've
kicked off and then kill them as you please.

IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use
is nohup.  And you probably want it to run in the background so that your
processing can continue.  Your command is "nohup  &"

HTH,
Bambi.
-Original Message-
Sent: Monday, December 10, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L

I have a kshell script that I am trying to perform an oracle operation.

Everything works fine in the script excpet cleanup.

One section of the script spools off a monitor job that watches the script
for any failures by use of flag files and file checking.  This all works
well UNTIL the main program ends before the monitor programs.

What happens is , that when the main program ends, the monitor closes down
because it was spawned by the main program.  Because of this, no all the
flag files are getting deleted.

I need to know the proper trap to set and its syntax to catch an ending
program so that I can get it to delete the flag files.


Anyone have any ideas ??

Thanks

Kevin

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

Fat City Network Services-- (858) 538-5051  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: Bellows, Bambi
  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 spell

RE: KSH Scripting Questions

[Bellows, Bambi]

Kevin --

Is your program supposed to find all the monitors it starts and kill them
cleanly, or are the monitors supposed to run independently once kicked off?

IF YOU WANT TO KILL THE PROCESSES CLEANLY, your process when you are running
the job is $$.  You can grep the processes for any subprocesses you've
kicked off and then kill them as you please.

IF THE MONITOR SHOULD RUN AFTER THE DRIVER ENDS, the command you want to use
is nohup.  And you probably want it to run in the background so that your
processing can continue.  Your command is "nohup  &"

HTH,
Bambi.
-Original Message-
Sent: Monday, December 10, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L

I have a kshell script that I am trying to perform an oracle operation.

Everything works fine in the script excpet cleanup.

One section of the script spools off a monitor job that watches the script
for any failures by use of flag files and file checking.  This all works
well UNTIL the main program ends before the monitor programs.

What happens is , that when the main program ends, the monitor closes down
because it was spawned by the main program.  Because of this, no all the
flag files are getting deleted.

I need to know the proper trap to set and its syntax to catch an ending
program so that I can get it to delete the flag files.


Anyone have any ideas ??

Thanks

Kevin

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

Fat City Network Services-- (858) 538-5051  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: Bellows, Bambi
  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: Resume issues - (Not posting my resume)

[Bellows, Bambi]

---
Sent: Friday, November 30, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


My resume that gets passed around EDS accounts is 5 pages.  That is a little
long for applying for jobs outside of EDS.  I was wondering how other folks
who work for the same type of companies shorting this (companies like CGI,
XWave, etc) where you get billed out to various contracts.  If my
responsibilities on those contracts were always the same I guess it would be
easier but sometimes I get billed out to provide one on one training,
sometimes I am there for development, sometimes DBA stuff.  You get the
idea.  Do you just list all the key things you have done for the company as
a whole and leave out the individual contract stuff?  I guess contractors
would have the same issue.



___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: ok..this is funny.. how do you pronounce "tuple"

[Bellows, Bambi]

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: Bellows, Bambi
  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: pass a value from a shell script to a store procedure

[Bellows, Bambi]

I'm sorry, I misunderstood.  Were you trying to get Oracle to tell Unix what
yesterday was?

#!/bin/ksh
sqlplus << EOF
system/incredibly_secret_password_but_this_is_probably_overkill_why_not_use_
scott_tiger
select 'YESTERDAY="||sysdate-1||'"' from dual

set pages 0
set sqlprompt ""
spool date_def
/
spool off
exit
EOF
. ./date_def
echo "Yesterday was $YESTERDAY" 

-Original Message-
Sent: Friday, November 09, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L

Thank you so much for response to my email.


I know we can do: Date= `date` but not `date -1`.


-Original Message-
Sent: Friday, November 09, 2001 11:14 AM
To: Multiple recipients of list ORACLE-L


So long as you embed your call to Oracle within your program, the program
can pass variables to Oracle all day long.

#!/bin/ksh
DATE=`date - 1`
DBA=`Anne Yu`
sqlplus << EOF
system/incredibly_secret_password
select $DATE,$DBA from dual;
exit
EOF
echo "Done!"

-Original Message-
Sent: Friday, November 09, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


Hey List, 

I need to pass  a value  `date - 1`  to a store procedure from a shell
script.   
Really appreciate if anyone can help.

Thanks,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  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: Bellows, Bambi
  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: Anne Yu
  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: Bellows, Bambi
  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: pass a value from a shell script to a store procedure

[Bellows, Bambi]

So long as you embed your call to Oracle within your program, the program
can pass variables to Oracle all day long.

#!/bin/ksh
DATE=`date - 1`
DBA=`Anne Yu`
sqlplus << EOF
system/incredibly_secret_password
select $DATE,$DBA from dual;
exit
EOF
echo "Done!"

-Original Message-
Sent: Friday, November 09, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L


Hey List, 

I need to pass  a value  `date - 1`  to a store procedure from a shell
script.   
Really appreciate if anyone can help.

Thanks,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  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: Bellows, Bambi
  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).

Grumble, grumble

[Bellows, Bambi]

Anyone ever see *this* ?  They sure don't apply patches the way they used
to.  Why, when *I* was a child, we applied patches with spit and mud and
hay, and they didn't complain about no '=' character neither, by gum...

Bambi.

oradev> /u05/dfinappl/ad/11.5.0/bin/adpatch c1880630.drv

 Copyright (c) 1998 Oracle Corporation
Redwood Shores, California, USA

 Oracle Applications AutoPatch

 Version 11.5.0

NOTE: You may not use this utility for custom development
  unless you have written permission from Oracle Corporation.

Invalid argument (no '=' character): c1880630.drv

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: gnarly delete statement?

[Bellows, Bambi]

How about this:

delete from stupid_table s
where  timestamp != (select min(timestamp)
 from stupid_table
 where b = s. b
 and   c = s.c
 and   d = s.d
 and   a = 2)
and a=2;



> 
> Given a business rule that says a combination of three columns must
> be
> unique if and only if a fourth column equals a certain value, and if
> the table in question contains rows that violate this requirement,
> I'm
> trying to write a single SQL statement that will remove the
> duplicates.
>  Of each set of duplicate rows, I'll delete the one with the latest
> insert timestamp.  
> 
> Let's call the columns
> 
> a  b  c  d  timestamp
> 
> The combination of b, c, and d must be unique if a = 2.  
> 
> I can get the duplicate row values along with the latest timestamp
> via
> 
> select max(tstamp), a, b, c from
> my_table group by a, b, c having count(*) > 1
> 
> But I can't figure out how to use that in a delete statement.
> 
> Suggestions greatly appreciated!
> 
> 
> Paul Baumgartel
> 
> 
> __
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 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).


__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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

[Bellows, Bambi]

Folks --

I got it.  Seems that what happened was that one of the scripts that needed
to be run by the applications user shuts the listener down and attempts (but
fails) to restart it.  Now, the problem was that the lsnr process was out
there, but that there were no associated services with it, so if you're not
looking closely enough, you wouldn't find the problem.  #$%^&*

Thanks to all who offered help...
Bambi.

-Original Message-
Sent: Thursday, November 01, 2001 10:36 AM
To: 'Bellows, Bambi'

What do you see when you type that in ?  The last part of that url should
take you to the Apps login screen.

-Original Message-
Sent: Thursday, November 01, 2001 10:02 AM
To: Jerry Hess


No, that works.  I'm trying it with http://servername:9008/

-Original Message-
Sent: Thursday, November 01, 2001 9:42 AM
To: '[EMAIL PROTECTED]'

What type of error message is the Web Server giving you ? I assume you are
trying to access it with something like
"http://servername:8000/dev60cgi/f60cgi";. Do you see the initial Oracle
splash screen ?

-Original Message-
Sent: Thursday, November 01, 2001 9:10 AM
To: Multiple recipients of list ORACLE-L


Well, yes and no.  

1)  Database up
2)  Listener up
3)  Log in as Apps person (hence source in appsora.env)
4)  Other processes listed

-Original Message-
Sent: Thursday, November 01, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L

Are you starting everything up in the proper order ?

- Database first (8.1.?)
- 8.1.? listener
- running your applications environment file (APPSORA.env)
- the other processes you listed

Just a guess.

-Original Message-
Sent: Wednesday, October 31, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


Friends --

Our pesky users are having problems logging on from the Web front end of
Oracle Financials.  This was working just fine 10/25 when the last pesky
user successfully logged in.  Since then, the box (Tru64 v5.1) has been
bounced, and we have started the following scripts successfully...

1) addbctl.sh (database startup)
2) addlnctl.sh (listener startup... you'd think Oracle would use its own
conventions, wouldn't you?)
3) adalnctl.sh (applications listener)
4) adcmctl.sh (concurrent manager startup)
5) adrepctl.sh (reports server)
6) adfrmctl.sh (forms server)
7) adtcfctl.start (tcf sockets)
8) adapcctl.sh (Apache web process)
9) adfmsctl.sh (forms metric server)
10) adfmcctl.sh (forms metric client)

I figure if the database is up, the listeners are up and concurrent manager
is up, everything should be fine.  What am I missing?

TIA!
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: Jerry Hess
  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: Bellows, Bambi
  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: Bellows, Bambi
  INET: [EMAIL PROTECTED]

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

To REMOVE 

RE: 11.5.4 Easy Question (?)

[Bellows, Bambi]

Well, yes and no.  

1)  Database up
2)  Listener up
3)  Log in as Apps person (hence source in appsora.env)
4)  Other processes listed

-Original Message-
Sent: Thursday, November 01, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L

Are you starting everything up in the proper order ?

- Database first (8.1.?)
- 8.1.? listener
- running your applications environment file (APPSORA.env)
- the other processes you listed

Just a guess.

-Original Message-
Sent: Wednesday, October 31, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L


Friends --

Our pesky users are having problems logging on from the Web front end of
Oracle Financials.  This was working just fine 10/25 when the last pesky
user successfully logged in.  Since then, the box (Tru64 v5.1) has been
bounced, and we have started the following scripts successfully...

1) addbctl.sh (database startup)
2) addlnctl.sh (listener startup... you'd think Oracle would use its own
conventions, wouldn't you?)
3) adalnctl.sh (applications listener)
4) adcmctl.sh (concurrent manager startup)
5) adrepctl.sh (reports server)
6) adfrmctl.sh (forms server)
7) adtcfctl.start (tcf sockets)
8) adapcctl.sh (Apache web process)
9) adfmsctl.sh (forms metric server)
10) adfmcctl.sh (forms metric client)

I figure if the database is up, the listeners are up and concurrent manager
is up, everything should be fine.  What am I missing?

TIA!
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: Jerry Hess
  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: Bellows, Bambi
  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: 11.5.4 Easy Question (?)

[Bellows, Bambi]

The users swear there's been no password changes.  Now, I have another piece
of information.  Seems that the port numbers in tnsnames.ora have changed.
>From 9008 to 1521.  Changing it back and bouncing the listener works, but
the tnsping fails.  Also, checking /etc/services, there is no 9008.  This
all looks pretty good until checking the date of the last modification was
7/28/01 and this just started failing 10/25.  Does this make things any
better? 

Let me know!
Bambi.

-Original Message-
Sent: Wednesday, October 31, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L

Bambi,

Have passwords been changed on the Apps side, but not in the config files?
Apps is notorious for hard coding passwords in a variety of files Can
you check the wdbsvr.app under $APACHE_TOP/modplsql/cfg?

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com 

** The opinions and statements above are entirely my own and not
those of my employer or clients **



> -Original Message-----
> From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 31, 2001 3:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 11.5.4 Easy Question (?)
> 
> 
> The error is that the database login failed.  There is 
> nothing in the bdump
> alert log of any interest and no entries whatsoever in the 
> tns alert log or
> in $APPLLOG.  No clue where to look for Apache stuff...
> 
> Bambi.
> 
> -Original Message-
> Sent: Wednesday, October 31, 2001 4:41 PM
> To: Multiple recipients of list ORACLE-L
> 
> What exactly happens? What is the problem? Anything in the log files
> for Oracle, listener, OS, Apache?
> 
> -Original Message-
> Sent: Wednesday, October 31, 2001 4:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Friends --
> 
> Our pesky users are having problems logging on from the Web 
> front end of
> Oracle Financials.  This was working just fine 10/25 when the 
> last pesky
> user successfully logged in.  Since then, the box (Tru64 
> v5.1) has been
> bounced, and we have started the following scripts successfully...
> 
> 1) addbctl.sh (database startup)
> 2) addlnctl.sh (listener startup... you'd think Oracle would 
> use its own
> conventions, wouldn't you?)
> 3) adalnctl.sh (applications listener)
> 4) adcmctl.sh (concurrent manager startup)
> 5) adrepctl.sh (reports server)
> 6) adfrmctl.sh (forms server)
> 7) adtcfctl.start (tcf sockets)
> 8) adapcctl.sh (Apache web process)
> 9) adfmsctl.sh (forms metric server)
> 10) adfmcctl.sh (forms metric client)
> 
> I figure if the database is up, the listeners are up and 
> concurrent manager
> is up, everything should be fine.  What am I missing?
> 
> TIA!
> Bambi.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bellows, Bambi
>   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: Gogala, Mladen
>   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: Bellows, Bambi
>   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 cont

RE: 11.5.4 Easy Question (?)

[Bellows, Bambi]

The error is that the database login failed.  There is nothing in the bdump
alert log of any interest and no entries whatsoever in the tns alert log or
in $APPLLOG.  No clue where to look for Apache stuff...

Bambi.

-Original Message-
Sent: Wednesday, October 31, 2001 4:41 PM
To: Multiple recipients of list ORACLE-L

What exactly happens? What is the problem? Anything in the log files
for Oracle, listener, OS, Apache?

-Original Message-
Sent: Wednesday, October 31, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L


Friends --

Our pesky users are having problems logging on from the Web front end of
Oracle Financials.  This was working just fine 10/25 when the last pesky
user successfully logged in.  Since then, the box (Tru64 v5.1) has been
bounced, and we have started the following scripts successfully...

1) addbctl.sh (database startup)
2) addlnctl.sh (listener startup... you'd think Oracle would use its own
conventions, wouldn't you?)
3) adalnctl.sh (applications listener)
4) adcmctl.sh (concurrent manager startup)
5) adrepctl.sh (reports server)
6) adfrmctl.sh (forms server)
7) adtcfctl.start (tcf sockets)
8) adapcctl.sh (Apache web process)
9) adfmsctl.sh (forms metric server)
10) adfmcctl.sh (forms metric client)

I figure if the database is up, the listeners are up and concurrent manager
is up, everything should be fine.  What am I missing?

TIA!
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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: Gogala, Mladen
  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: Bellows, Bambi
  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).

11.5.4 Easy Question (?)

[Bellows, Bambi]

Friends --

Our pesky users are having problems logging on from the Web front end of
Oracle Financials.  This was working just fine 10/25 when the last pesky
user successfully logged in.  Since then, the box (Tru64 v5.1) has been
bounced, and we have started the following scripts successfully...

1) addbctl.sh (database startup)
2) addlnctl.sh (listener startup... you'd think Oracle would use its own
conventions, wouldn't you?)
3) adalnctl.sh (applications listener)
4) adcmctl.sh (concurrent manager startup)
5) adrepctl.sh (reports server)
6) adfrmctl.sh (forms server)
7) adtcfctl.start (tcf sockets)
8) adapcctl.sh (Apache web process)
9) adfmsctl.sh (forms metric server)
10) adfmcctl.sh (forms metric client)

I figure if the database is up, the listeners are up and concurrent manager
is up, everything should be fine.  What am I missing?

TIA!
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bellows, Bambi
  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).

11.5.5 on Tru64

[Bellows, Bambi]

Title: Cursor Variable question









Hi Everybody!

Is anyone running 11.5.5 on Tru64?  Is it clean?  What's this about a single Apache
server?  How do I even check to see
how many Apache servers I have?

TIA!

Bambi. 

RE: Last day of the month unix

[Bellows, Bambi]

Well, you can do date functions in Unix.  The date function is date.  It's
not normal, because Unix Commands are supposed to be cryptic.

But, you could do the following.  You'll want to test it because no to Unii
are the same...

cal|tail -2|head -1|awk '{print $NF}' (last day of current month)
cal 2 2001|tail -2|head -1|awk '{print $NF}' (last day of February 2001)

HTH,
Bambi.

-Original Message-
Sent: Monday, October 29, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L



-- Sinard Xing <[EMAIL PROTECTED]>

> Hi,
>
> Is there any function that can display out "last day of the month" for
> example
>   lastday(Oct,2001) return me 31
> Or a variable that store this value.
>
> Is Date an object in unix ?

Check the Date::Manip package. The simplest way is to check
for

UnixDate( 'tommorrow', '%d') == 1 ? 'last day of month', 'not last day';

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

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

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

[Bellows, Bambi]

Title: FW: Oracle Training from InterTrain SPAM









Yep. 
There's a list of suckers in the To list,
and I am A-number-1 sucker du jour.

 

Bambi.

 

-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 26, 2001
3:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: FW: Oracle Training from
InterTrain SPAM

 

Anyone else get this
spam?  

-Original Message- 
From:   Cindy Connors
[SMTP:[EMAIL PROTECTED]] 
Sent:   Friday, October 26, 2001 6:47 PM

To: Bambi Bellows; Brian
Norrell; Charlie Mengler; Cherie Machler; Chris Guidry; Danny Hughes; Dave
Farnsworth; Don Bricker; Greg Moore; Jack Applewhite; Jacques Kilchoer; James
Howerton; Jared Still; Jim Conboy; Joe Testa; Kathy Duret; Kenneth Janusz;
Kimberly Smith; Kirti Deshpande; Lisa Koivu; Martin Brown; Mohan Ross; Ramon
Estevez; Rick Stephenson; Ron Yount; Ruth Gramolini; Scott Canaan; Shari
Dishop; Steve Adams; Steven Lembark; Thomas Mercadante; Val Gamerman

Subject:   
Oracle
Training from InterTrain 

The InterTrain Group is
an International IT Training Company specializing in Oracle Training
Services. Having established our reputation in the UK with over 6 years of
commitment to quality, InterTrain has expanded its highly regarded services
into the US, Europe and Australia.

Our training strategy is
to provide independent business focused
training for the following: 

 

·
Oracle Financials
- Customized Financials training using your data and developed around your
business process. 

·
Oracle Technical Products - Training
on the entire Oracle Suite including
Oracle8i, Designer 6i, Discoverer, DBA, Oracle 9iAS, Oracle Portal.


·
Legacy Products
- Continued training support for Oracle legacy products 





If you would like to know
more about our training please visit our web site (be sure and click on the US
flag) or call me at our Secaucus, NJ location.

Cindy Connors

National Sales Manager
The InterTrain Group
Office: 201-223-4990
Mobile: 201-965-5982
Email: [EMAIL PROTECTED]

RE: Concealing SQL Loader password from ps -ef

[Bellows, Bambi]

The << operator creates a set of commands to be executed until a particular
label as part of the calling command and only the calling command is
displayed on ps -ef.  This should work the same for sqlloader as it does for
sqlplus or ftp or su or whatever else.  Just put the username/password on
the inside of the << operator and you should be golden.

HTH,
Bambi.
===

sqlplus << EOF
system/incredibly_secret_password
select * from dual;
exit
EOF



-Original Message-
Sent: Thursday, October 25, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L

When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

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

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

[Bellows, Bambi]

When you need to do single quotes in Oracle, the best way to do it is that
the number of quotes required is twice the number of quotes you want plus
two (2x+2).

So, 

SQL> select '''' from dual;

'
-
'

SQL> select '''''' from dual;

''
--
''

SQL> select '''''''''' from dual;

''''

''''

HTH,
Bambi.

-Original Message-
Sent: Monday, October 22, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L


Gotta love Mondays,

We've been through this before, and I usually don't have a problem, but
today my brain must think it's the weekend.


Hey, I've got a bunch of names like O'Brien and  O'Reilley where I need to
replace the ' symbol.  I've tried every type of combination of single
quotes and slashes(escape sequence) I can think of, but I must have missed
one, because I can't get it to replace.

Any Ideas?  Here's the progenitor of the whole mess.

1* select replace(lastname,' ' ') from adst where lastname like 'O%'
SQL> /
ERROR:
ORA-01756: quoted string not properly terminated
SQL>

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
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: Bellows, Bambi
  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: Little Brother Larry not really ON topic

[Bellows, Bambi]

Sorry... I was raised by
attorneys.  Lots of them.  Thankfully, through some weird twist of
genetics, I was blessed with a well defined geek gene.

 

-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 19, 2001
3:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Little Brother Larry
not really ON topic

 



Y'know, Bambi is such a gentle name,
but you're scaring me with this in-depth knowledge. :-)





 





JIm

>>> [EMAIL PROTECTED] 10/19/01 03:59PM >>>



Yes, well, I
think that they thought that was a pretty snazzy way not to pay 
on life insurance.  In practice, though, if you've had your policy more
than 
two years, most companies will pay anyway.  It's hard to get a definitive 
yes or no out of them at the time you buy your policy, so it's rather the 
luck of the draw, um, as it were... 

-Original Message- 
Sent: Friday, October 19, 2001 2:42 PM 
To: Multiple recipients of list ORACLE-L 

And you they won't pay your life insuranc to your
beneficiaries because you 
died in the commission of a crime..Catch 22 eh? 
Ruth 
- Original Message - 
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
Sent: Friday, October 19, 2001 3:07 PM 

 

> Suicide is illegal, but, oddly commission of
that crime lands you in a 
> mental institution because you are mentally unfit to stand trial, and, 
> except in the case of extraordinary extenuating circumstances, is proof of

> at least temporary insanity.  This is the mechanism that is used to 
> institutionalize people who attempt, but fail, to commit suicide. 
This is 
> also used by some insurance companies who will not pay claims for 
sufferings 
> incurred in the commission of a crime. 
> 
> Extraordinary extenuating circumstances include (but are not limited to): 
> Extreme political protest (e.g., the autoimolation of those monks); 
> extraordinary pain and suffering (it's still illegal, but won't land you 
in 
> a mental institution); suicide attempts immediately prior to capital 
> punishment (they really don't like that because they can't execute you 
until 
> you're mentally competent to appreciate the punishment you are about to 
> endure and prisoners, instead, are placed on suicide watch) 
> 
> HTH, 
> Bambi. 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 1:15 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> Are you sure its not illegal to 'attempt' suicide?  Granted 
> that still does not make a whole lot of sense but it gives 
> them a way to get back at you for the medical bills and what 
> not of a failed attempt I believe.  So if you do want to do 
> it take the extra time and plan well (not that I think anyone 
> should do it). 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 10:55 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> No, man, they through your corpse into a cell until you learn better. 
Duh! 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 4:25 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> Sent: Friday, October 19, 2001 00:50 
> 
> 
> > My favorite law is that it is illegal to commit suicide. 
> > 
> > Love that! 
> 
> 
> and what happens if u successfully commit one? 
> 
> will they sue u? 
> 
> 
> Marin 
> 
> 
>  
> "...what you brought from your past, is of no use in your present.
When 
> you must choose a new path, do not bring old experiences with you. 
> Those who strike out afresh, but who attempt to retain a little of the 
> old life, end up torn apart by their own memories. " 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 
> Author: Marin Dimitrov 
>   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: Bellows, Bambi 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
(858) 5

RE: Little Brother Larry sorta ON topic

[Bellows, Bambi]

Yes, well, I think that they thought that was a pretty snazzy way not to pay
on life insurance.  In practice, though, if you've had your policy more than
two years, most companies will pay anyway.  It's hard to get a definitive
yes or no out of them at the time you buy your policy, so it's rather the
luck of the draw, um, as it were...

-Original Message-
Sent: Friday, October 19, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L

And you they won't pay your life insuranc to your beneficiaries because you
died in the commission of a crime..Catch 22 eh?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 3:07 PM


> Suicide is illegal, but, oddly commission of that crime lands you in a
> mental institution because you are mentally unfit to stand trial, and,
> except in the case of extraordinary extenuating circumstances, is proof of
> at least temporary insanity.  This is the mechanism that is used to
> institutionalize people who attempt, but fail, to commit suicide.  This is
> also used by some insurance companies who will not pay claims for
sufferings
> incurred in the commission of a crime.
>
> Extraordinary extenuating circumstances include (but are not limited to):
> Extreme political protest (e.g., the autoimolation of those monks);
> extraordinary pain and suffering (it's still illegal, but won't land you
in
> a mental institution); suicide attempts immediately prior to capital
> punishment (they really don't like that because they can't execute you
until
> you're mentally competent to appreciate the punishment you are about to
> endure and prisoners, instead, are placed on suicide watch)
>
> HTH,
> Bambi.
>
> -Original Message-
> Sent: Friday, October 19, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> Are you sure its not illegal to 'attempt' suicide?  Granted
> that still does not make a whole lot of sense but it gives
> them a way to get back at you for the medical bills and what
> not of a failed attempt I believe.  So if you do want to do
> it take the extra time and plan well (not that I think anyone
> should do it).
>
> -Original Message-
> Sent: Friday, October 19, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> No, man, they through your corpse into a cell until you learn better.
Duh!
>
> -Original Message-
> Sent: Friday, October 19, 2001 4:25 AM
> To: Multiple recipients of list ORACLE-L
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, October 19, 2001 00:50
>
>
> > My favorite law is that it is illegal to commit suicide.
> >
> > Love that!
>
>
> and what happens if u successfully commit one?
>
> will they sue u?
>
>
> Marin
>
>
> 
> "...what you brought from your past, is of no use in your present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a little of the
> old life, end up torn apart by their own memories. "
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marin Dimitrov
>   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: Bellows, Bambi
>   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: Kimberly Smith
>   INET: [EMAIL PROTECTED]
&

RE: Little Brother Larry sorta ON topic

[Bellows, Bambi]

Suicide is illegal, but, oddly commission of that crime lands you in a
mental institution because you are mentally unfit to stand trial, and,
except in the case of extraordinary extenuating circumstances, is proof of
at least temporary insanity.  This is the mechanism that is used to
institutionalize people who attempt, but fail, to commit suicide.  This is
also used by some insurance companies who will not pay claims for sufferings
incurred in the commission of a crime.

Extraordinary extenuating circumstances include (but are not limited to):
Extreme political protest (e.g., the autoimolation of those monks);
extraordinary pain and suffering (it's still illegal, but won't land you in
a mental institution); suicide attempts immediately prior to capital
punishment (they really don't like that because they can't execute you until
you're mentally competent to appreciate the punishment you are about to
endure and prisoners, instead, are placed on suicide watch)

HTH,
Bambi.

-Original Message-
Sent: Friday, October 19, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L

Are you sure its not illegal to 'attempt' suicide?  Granted
that still does not make a whole lot of sense but it gives
them a way to get back at you for the medical bills and what
not of a failed attempt I believe.  So if you do want to do
it take the extra time and plan well (not that I think anyone
should do it).

-Original Message-
Sent: Friday, October 19, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  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: Bellows, Bambi
  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: Kimberly Smith
  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: Bellows, Bambi
  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: Little Brother Larry sorta ON topic

[Bellows, Bambi]

No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  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: Bellows, Bambi
  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: Little Brother Larry sorta ON topic

[Bellows, Bambi]

al Message-
Sent: Wednesday, October 17, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L

Yeah, but what if you were the DBA for that database?  ;-)

The article did say that some "prominent civil libertarians" were not
completely averse to the idea. The ID card would only be mandatory for
non-citizens and voluntary for citizens. I confess that as a recovering
libertarian I'm conflicted. We already have to prove our identity for
social
security cards and  driver's licenses (to a lessor degree and varying by
state). A national plan would just be taking a situation that already
exists
and making it bigger and more effecient. ;-| Of course what's voluntary
today can more easily become mandatory tomorrow.

Hmmm... I wonder what the support fees would be for such a "beast?"  ;-)


Steve Orr
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Bellows, Bambi
  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: Christopher Spence
  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: Henry Poras
  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: Bellows, Bambi
  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: Little Brother Larry sorta ON topic

[Bellows, Bambi]

r
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Bellows, Bambi
  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).