Re: sqlplus hanging on exit

[jkstill]

Louis,

Yep, old bug. :)

I seem to recall that removing the files is enough;
best check on MetaLink though.

Do you have access?  I can find it for you tomorrow
if you don't. ( gotta get to bed now, the eyelids
won't stay up :)

Jared




On Wed, 21 Mar 2001, Louis Avrami wrote:

> Jared,
>
> Thanks for the reply.
>
> I'm embarrassed to say that the cause of the problem was Oracle Trace.  The
> solution was to set EPC_DISABLE=TRUE in the environment and listener.ora, and
> stop and restart the database.
>
> I remember doing this a couple of years ago, when Oracle Trace was first
> enabled by default.
>
> Apparently one of my predecessors didn't set EPC_DISABLED anywhere, but simply
> removed the .dat log files under $ORACLE_HOME/otrace/admin.  Does this mean
> that the trace overhead is still part of the Oracle processes, but just can't
> find the log files to write out to?
>
> Lou Avrami
>
>
> [EMAIL PROTECTED] wrote:
>
> > You may want to check v$session_wait while the session
> > is exiting and see if it's waiting on a resource in the
> > the database.
> >
> > If that doesn't reveal anything, you may want to try
> > truss on the server process and see what is going on there.
> > ( assuming you aren't using MTS )
> >
> > Jared
> >
> > On Fri, 16 Mar 2001, Louis Avrami wrote:
> >
> > > Hello all,
> > >
> > > I recently had to migrate a legacy database to a Sun 420 running Solaris
> > > 2.8, latest recommended patches.  I installed RDBMS 7.3.4.5, created a
> > > database and imported the data successfully.
> > >
> > > I have actually had to do this on several different servers (we're
> > > finally scheduled to upgrade to RDBMS 8.1.7 next month).  All have gone
> > > well with the exception of one server.
> > >
> > > The symptoms of the problem seem to occur when trying to exit a
> > > connection to this particular database.  The exiting process seems to
> > > hang for an unusually long period of time.  For example, from the
> > > command line, if I use sqlplus to connect to the database, the
> > > connection starts up almost instananeously.  SQL statements execute
> > > quickly, with no apparent problems.  However, when I try to exit, the
> > > sqlplus session seems to just hang:
> > ...
>

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

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

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

Re: ITL and possible deadlocks

[Shevtsov, Eduard]

Michael,

thanks for your response.
I meant the following situation. Transaction#1 updates a row#1 in block#1 of a table. 
In order to do
it allocates a ITL slot.
Transaction#2 updates a row#100 in block#100 of the same table and also allocates 
transaction slot.
If there is no free space to allocate additional ITL slots in these blocks then other 
transactions
can't modify these blocks until transaction#1 and transaction#2 do commit or rollback. 
Then
transaction#1 tryes to update row#101 in the block#100 and transaction2 tryes to
update row#2 in the block#1. Both transaction have to wait because there are no empty 
ITL slots. You
can see that there are no share rows and each transaction updates its own rows.
How Oracle resolve such case?

Ed


> Ed,
>
> Not sure that I understood it right, but I'll take a try.
> So there are 2 transactions and each one is trying to update the row which was 
>already updated by
the other transaction?
> IMHO, if you are trying to place an exclusive lock on the locked row ( it remains 
>locked until
commit ), you either wait or receive
> an error if "no wait" was specified.
> Behaviour of the 2nd transaction is trying to place an exclusive lock on the 1st 
>transaction' row
is just the same.
> If both transactions wait, it's a deadlock situation and should be resolved by 
>Oracle itself.
>
> HTH,
> Michael Netrusov,
> www.atelo.com
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 20, 2001 10:40
>
>
> > Hello List,
> >
> > it's rather a theoretical question. Let say two sessions
> > update a table. Each transaction allocated a transaction
> > slot in a block (I consider the two different blocks).
> > Each block has only one slot and there is no free space
> > in these blocks to allocate additional transaction slots.
> > Then each transaction tryes to update a row in the block
> > which has already been updated by the other transaction.
> > How Oracle to do with such situation in case when there is
> > no access to a common resource (I mean a common row) ?
> >
> >
> > Thanks in advance
> >
> > Ed
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shevtsov, Eduard
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be 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: Michael Netrusov
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Shevtsov, Eduard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 hanging on exit

[Louis Avrami]

Jared,

Thanks for the reply.

I'm embarrassed to say that the cause of the problem was Oracle Trace.  The
solution was to set EPC_DISABLE=TRUE in the environment and listener.ora, and
stop and restart the database.

I remember doing this a couple of years ago, when Oracle Trace was first
enabled by default.

Apparently one of my predecessors didn't set EPC_DISABLED anywhere, but simply
removed the .dat log files under $ORACLE_HOME/otrace/admin.  Does this mean
that the trace overhead is still part of the Oracle processes, but just can't
find the log files to write out to?

Lou Avrami


[EMAIL PROTECTED] wrote:

> You may want to check v$session_wait while the session
> is exiting and see if it's waiting on a resource in the
> the database.
>
> If that doesn't reveal anything, you may want to try
> truss on the server process and see what is going on there.
> ( assuming you aren't using MTS )
>
> Jared
>
> On Fri, 16 Mar 2001, Louis Avrami wrote:
>
> > Hello all,
> >
> > I recently had to migrate a legacy database to a Sun 420 running Solaris
> > 2.8, latest recommended patches.  I installed RDBMS 7.3.4.5, created a
> > database and imported the data successfully.
> >
> > I have actually had to do this on several different servers (we're
> > finally scheduled to upgrade to RDBMS 8.1.7 next month).  All have gone
> > well with the exception of one server.
> >
> > The symptoms of the problem seem to occur when trying to exit a
> > connection to this particular database.  The exiting process seems to
> > hang for an unusually long period of time.  For example, from the
> > command line, if I use sqlplus to connect to the database, the
> > connection starts up almost instananeously.  SQL statements execute
> > quickly, with no apparent problems.  However, when I try to exit, the
> > sqlplus session seems to just hang:
> ...

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

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

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

sorry

[Rongcheng Zhang (ETC)]

sorry for test.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rongcheng Zhang (ETC)
  INET: [EMAIL PROTECTED]

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

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

jj

[Rongcheng Zhang (ETC)]

jkfdhkjhdfjkkjdf
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rongcheng Zhang (ETC)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 using Network Applicance Storage boxes with Oracle?

[C.S.Venkata Subramanian]

 I have heard about this Storage box. It can be plugged with any OS and diff OS can 
use this box as their Storage, by allocating diff LUN's to them. When all the 
datafiles,redologs,archives are in same place do u expect to get better 
performance. Think it over. Go for RAID1 and RAID0 combination. U will get 
better performance from ORacle. U can tune ORACLE db to its maximum extent by placing 
diff datafiles in diff controllers/HDD's.
--

On Tue, 20 Mar 2001 14:30:47  
 Helmut Daiminger wrote:
>Hi there!
>
>Is anybody out there running Oracle on NetApp Storage Networking box?
>
>I was told by some NetApp guys that using their boxes we don't have to worry
>about distributing datafiles, RBS etc. across the disks because the NetApp
>OS takes care of all that.
>
>Any comments?
>
>Thanks,
>Helmut
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Helmut Daiminger
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SUN vs. HP

[C.S.Venkata Subramanian]

 I have been working with Oracle under HP, I find HP server with high fault toulerence 
and reliable. If we tune the OS and DB then we can get maximum performance. One word 
of caution is that, if u use Mc Servicegaurd then u shud go for OPS. Which works for 
only on RAW partitions. Administration will not be a easy job. Instead go for AutoRAID 
box which HP has got. It converts itself bet RAID5 and RAID1/0.

My recomendation will be for RAID10, where u have disk mirroring,stripping and 
protection for Data and better performance.

I have not worked with SUN. But i have heard that the native code,compilation and 
testing of oracle is in the SUN OS.

But HP is also a good OS.

H/w is slightly costlier in HP.


--

On Tue, 20 Mar 2001 10:31:59  
 Alex Apostolopoulos wrote:
>Hi,
>
>we are currently in the process of evaluating a high availiability cluster 
>for our production database. The final two solutions are:
>
>SunCluster 2x420R 2Gig 2x450Mhz 
>Storage 100Gig
>
>Hewlett Packard MC ServiceGuard
>2xL-Class 2x440Mhz 2Gig 
>Storage VA 7100 100Gig
>
>Based on our criterias (scalability, performance, TCO, price, reliability, 
>support, in house experience  ...) it looks like a dead race...
>
>Any suggestions or thoughts would be help full 
>
>cheers alex
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Alex Apostolopoulos
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- A humorous reply to the Canada rulz

[Regina Harter]

At 10:07 AM 3/20/01 -0800, you wrote:
U, Is this kinda like Mr. Sulu
(that was Mr Chekov)

on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the
time), but
I thought Baseball and Basketball were distinctly inventions of the
USA.
You are correct, though, as far as basketball goes, they might be
referring to the fact that the gentleman who invented basketball (in New
Hampshire) was born in Canada (and apparently beat feet to the US as soon
as he could ;) )

You might be able to tell I'm a rabid fan of
neither.  Penicillin and the
telephone??  Other delusions of grandeur?  
As for penicillin:
The action of natural penicillin was first observed
in 1928 by British bacteriologist
Sir Alexander
Fleming, but another ten years passed
before penicillin was concentrated and studied by British biochemist
Ernst
Chain, British pathologist
Sir Howard
Florey, and other scientists.


And the telehpone:
On March 10, 1876, in Boston, Massachusetts, Alexander Graham Bell
invented the telephone. Thomas Watson fashioned the device itself; a
crude thing made of a wooden stand, a funnel, a cup of acid, and some
copper wire. But these simple parts and the equally simple first
telephone call -- "Mr. Watson, come here, I want you!" -- belie
a complicated past. Bell filed his application just hours before his
competitor, Elisha Gray, filed notice to soon patent a telephone himself.
What's more, though neither man had actually built a working telephone,
Bell made his telephone operate three weeks later using ideas outlined in
Gray's Notice of Invention, methods Bell did not propose in his own
patent.

Elisha Gray was from Ohio, Alexander Graham Bell was from Scotland,
though he did live in Canada 2 years before moving to Boston.

How about the only country that
can't decide if they're English or French?  How about the US's
biggest
colony via cultural conquest(ohh, that's a low blow).  How about
never
saw a bikini except in National Geographic?  I could go on, but I'm
not sure
my humor translates all that well, and the firewall has Babelfish
blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might 
be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any
harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch &
Coffee Crisp 
> 
> * The size of our
footballs fields and one less Down 
> 
> * Baseball is Canadian

> 
> * Lacrosse is Canadian

> 
> * Hockey is Canadian

> 
> * Basketball is Canadian

> 
> * Apple pie is Canadian

> 
> * Mr. Dress-up kicks Mr.
Rogers ass 
> 
> * Tim Hortons kicks
Dunkin' Donuts ass 
> 
> * In the war of 1812,
started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we
burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who
was insane
> and hammered all the time.  We got bored because they ran away,
so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest
French population that never surrendered to
> Germany. 
> 
> * We have the largest
English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a
bar fight that lasted a little over an hour. 
> 
> * The only person who
was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up
just in
> time to get caught. 
> 
> * We knew plaid was cool
far before Seattle caught on. 
> 
> * The Hudsons Bay
Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled
team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to
do with all the parts of a buffalo. 
> 
> * We don't marry our
kin-folk. 
> 
> * We invented ski-doos,
jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that
save
> countless lives each year 
> 
> * We ALL have frozen our
tongues to something metal and lived to tell
> about it. 
> 
> * BUT MOST IMPORTANT!

> 
> * the handles on our
beer cases are big enough to fit your hands
> with mitts on. 
> 
>  ooh Canada!! 
> 
>  Oh yeah... and our elections only take one day. 
> 
>  
-- 
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 / 

Locking

[Richard Lau]

Recently, one of my users nor I could update a table.  As I dug around, I 
couldn't find any of the 'lock' tables such as dba_locks.  Eventually, I 
managed to start data gatherer and get OEM's lock manager to kill the hung 
session.  What do you guys do to find and terminate this deadlock or hung 
sessions?  Are the 'lock' system tables built with specific options during 
db build?

TIA.  ...R
[EMAIL PROTECTED]

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Anybody using Network Applicance Storage boxes with Oracle?

[Helmut Daiminger]

Hi there!

Is anybody out there running Oracle on NetApp Storage Networking box?

I was told by some NetApp guys that using their boxes we don't have to worry
about distributing datafiles, RBS etc. across the disks because the NetApp
OS takes care of all that.

Any comments?

Thanks,
Helmut


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

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

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

No Subject

[Ginger Mejia]

IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES
AVAILABLE?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SUN vs. HP

[jkstill]

You will get patches and new versions of software
sooner on Solaris than you will on HP.

Jared

On Tue, 20 Mar 2001, Alex Apostolopoulos wrote:

> Hi,
>
> we are currently in the process of evaluating a high availiability cluster
> for our production database. The final two solutions are:
>
> SunCluster 2x420R 2Gig 2x450Mhz
> Storage 100Gig
>
> Hewlett Packard MC ServiceGuard
> 2xL-Class 2x440Mhz 2Gig
> Storage VA 7100 100Gig
>
> Based on our criterias (scalability, performance, TCO, price, reliability,
> support, in house experience  ...) it looks like a dead race...
>
> Any suggestions or thoughts would be help full
>
> cheers alex
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alex Apostolopoulos
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

Re:SUN vs. HP

[dgoulet]

Alex,

We've used HP servers for the last 8-9 years.  Right now we have L & N class
machines with a few K's still working hard every day.  I find the K, L, and N
class machines VERY fault tolerant.  If a power supply fails the other can hold
the entire load & their hot swap able.  If a CPU fails the others take up the
load easily.  If memory fails it gets partitioned off.  Now memory & CPU's
aren't hot swap, but it takes almost no time to replace them.  The problem has
always been disk.  We're using EMC Symmetric with RAID1 (full mirroring) which
has worked out absolutely wonderful.  We've had two disk failures that no one
knew about as the mirror took over and the replacement drive only took 10
minutes to re-silver itself.  Very nice piece of hardware.  Therefore do you
need ServiceGuard?  No not really, but HP sure would like the extra cash!!  By
the way we run 5 assembly lines, a web site, and the business as a whole in this
way 24x7 52 weeks a year.  We've actually lost more production time to user
error than computer failure.

Dick Goulet

Reply Separator
Author: Alex Apostolopoulos <[EMAIL PROTECTED]>
Date:   3/20/2001 10:31 AM

Hi,

we are currently in the process of evaluating a high availiability cluster 
for our production database. The final two solutions are:

SunCluster 2x420R 2Gig 2x450Mhz 
Storage 100Gig

Hewlett Packard MC ServiceGuard
2xL-Class 2x440Mhz 2Gig 
Storage VA 7100 100Gig

Based on our criterias (scalability, performance, TCO, price, reliability, 
support, in house experience  ...) it looks like a dead race...

Any suggestions or thoughts would be help full 

cheers alex

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

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

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

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

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

RE: RE: 32bit vs 64bit (was: Just like Christmas)

[Kimberly Smith]

Actually, the problem started with the 10.20 32-bit.  They do stay up
for months at a time as well.  We only get 4 downtimes per year (when we are
lucky).
Its during reboots that we have issues.  And the other plants that 
had issues are also running 32-bit (not Fujitsu plants either).  
Personally, I think my Sys. Admin. team does an excellent job and 
wouldn't do anything to harm them.  Like I mentioned, HP owned up
to the problem.  Right now we are running 78 days since the last downtime
and the only thing rebooted are the ServiceGuard cluster still running
10.20 32-bit.  We think that one was a network issue though.  ServiceGuard
gets
a little iffy when the network is missing.


-Original Message-
Sent: Tuesday, March 20, 2001 1:28 PM
To: Kimberly Smith; Multiple recipients of list ORACLE-L


Kimberley,

The problem is that you loaded the 64 bit kernel in the K class.  It
does
not have the buss required for 64 bit, therefore the kernel does a fake it
64
emulation.  Rebuild the machine with the 32 bit version of HP 11.0 & you'll
be a
lot happier.  Ours stay up for months without problems & reboots are just
fine. 
Personally I'd go kill your SA and/or the Hp zlutz that configured them.

Dick Goulet

Good hardware cannot fix bad software/configurations.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   3/20/2001 11:05 AM

We are going 64-bit for HP but keeping Oracle at 32-bit.  We really
had no choice for the HP side.  We just need the memory that 32 bit
could not support.  We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking).  But we are
getting rid of all our K-class servers.  The model we are running have
been nothing but trouble.  We hate to turn one off because it seems
like every time we reboot hardware dies.  Other fabs have been having
the same issue.  So we are going N-class for the database cluster
and A-class for the remaining.  Since your K-class servers are new they
probably don't have the same hardware issues we have.  HP even owned up
to having issues.

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.




This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re:RE: RE: RE: RE: RE: OT: Rachel in Vietnam

[dgoulet]

Sure, why not.  The BRICK-BAT method.

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 5:08 PM

Wow. Talk about enforcing "foreign constraints".

-Original Message-
Sent: Tuesday, March 20, 2001 5:01 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Ross,

When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads
150 to
200(B-52D with wing racks) 750LB demolition bombs nothing stands.  Even
duhvelopers.  I've had Marines discribe the area where a BUFF strike landed
as
"It looked like God reached down, scooped out a three mile long by half a
mile
wide, by 100 foot deep piece of the earth and take it away".  I don't know
about
cool, but it sure was effective!!

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 4:28 PM

BUFF bomb. That sounds cool. Will it work on developers?

-Original Message-
Sent: Tuesday, March 20, 2001 4:18 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Ross,

Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run.  Nothing survived that. :-)

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 8:02 AM

Dick , 

Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 

Just a thought. 

Ross

-Original Message-
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


Rachel,

If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the
logo on
top.  It just crunches better.

Dick Goulet

Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM

but Moom, the icky bugs TOUCHED the chocolate!   :)



>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line contai

RE: Insert without telling column names

[jkstill]

Well of course it's a bad idea, I thought
that was obvious.  ;)

Jared

On Tue, 20 Mar 2001, Jacques Kilchoer wrote:

> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >
> > How can I create an insert statement without telling all the
> > names of the columns?
> > Give an example, please.
>
>
> As Jared mentioned, if you are inserting into all the columns in a table,
> you don't need to specify the column names. But this is a BAD IDEA, because
> if someone adds a column to the table all your insert statements written
> without column names will fail unless you add values for the new column to
> the insert statement. So while this might be OK when typing in SQL for
> "one-time" use, don't use this method in any programs/scripts that will be
> used more than once.
>
> --
> any ignorant comments made are the sole responsibility of J. R. Kilchoer and
> should not reflect adversely upon my employer.
>
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com
>
>
>

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

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

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

Re:RE: RE: RE: RE: OT: Rachel in Vietnam

[dgoulet]

Ross,

When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads 150 to
200(B-52D with wing racks) 750LB demolition bombs nothing stands.  Even
duhvelopers.  I've had Marines discribe the area where a BUFF strike landed as
"It looked like God reached down, scooped out a three mile long by half a mile
wide, by 100 foot deep piece of the earth and take it away".  I don't know about
cool, but it sure was effective!!

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 4:28 PM

BUFF bomb. That sounds cool. Will it work on developers?

-Original Message-
Sent: Tuesday, March 20, 2001 4:18 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


Ross,

Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run.  Nothing survived that. :-)

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 8:02 AM

Dick , 

Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 

Just a thought. 

Ross

-Original Message-
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


Rachel,

If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the
logo on
top.  It just crunches better.

Dick Goulet

Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM

but Moom, the icky bugs TOUCHED the chocolate!   :)



>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (8

RE: RE: RE: RE: RE: OT: Rachel in Vietnam

[Mohan, Ross]

Title: RE: RE: RE: RE: RE: OT: Rachel in Vietnam





Wow. Talk about enforcing "foreign constraints".


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 5:01 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: RE: RE: OT: Rachel in Vietnam



Ross,


    When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads 150 to
200(B-52D with wing racks) 750LB demolition bombs nothing stands.  Even
duhvelopers.  I've had Marines discribe the area where a BUFF strike landed as
"It looked like God reached down, scooped out a three mile long by half a mile
wide, by 100 foot deep piece of the earth and take it away".  I don't know about
cool, but it sure was effective!!


Dick Goulet


Reply Separator
Subject:    RE: RE: RE: RE: OT: Rachel in Vietnam
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 4:28 PM


BUFF bomb. That sounds cool. Will it work on developers?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 4:18 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: RE: OT: Rachel in Vietnam



Ross,


    Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run.  Nothing survived that. :-)


Dick Goulet


Reply Separator
Subject:    RE: RE: RE: OT: Rachel in Vietnam
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 8:02 AM


Dick , 


Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 


Just a thought. 


Ross


-Original Message-
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L



Rachel,


    If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the
logo on
top.  It just crunches better.


Dick Goulet


Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM


but Moom, the icky bugs TOUCHED the chocolate!   :)




>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>-

Re: Insert without telling column names

[David A. Barbour]

Hi all -

I stand (sit?) before you with egg on my face.  I KNOW you can insert
without naming column names if you're filling the entire row, I just
didn't consider that this might be what Roland was attempting to
accomplish.  As Regina and Jacques both pointed out, if your package,
procedure or script is to be reused, it's probably best not to assume
the table structure you think will be there actually is there.  

With humble apologies,

David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth


William Beilstein wrote:
> 
> You are misinformed. If you have a table of the form
> 
> col1varchar2(1)
> col2   number
> col3   date
> 
> You can insert into it with the insert statement
> INSERT INTO MYTABLE VALUES('X',23,SYSDATE);
> 
> As long as ALL the columns are included in the values clause in the order they were 
>created in the table, you don't have to define the column names.
> 
> >>> [EMAIL PROTECTED] 03/20/01 11:36AM >>>
> Roland,
> 
> You can't.  There are a number of ways to really cut down on the code
> required to do an insert, but if you think about it, how will Oracle
> know where the data is supposed to go if you don't give it the column
> name(at some point)?
> 
> If you're using 8i, there is a direct load insert, but as far as I'm
> aware, this will work only for a select * from another table.
> 
> Dynamic SQL works pretty well for this kind of stuff.  What are you
> trying to do?
> 
> Regards,
> 
> David A. Barbour
> Oracle DBA
> Formerly with the now defunct and bankrupt ConnectSouth
> 
> [EMAIL PROTECTED] wrote:
> >
> > Hallo,
> >
> > How can I create an insert statement without telling all the names of the columns?
> > Give an example, please.
> >
> > Roland Sköldblom
> >
> > --
> > 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: David A. Barbour
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: William Beilstein
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Free Oracle DBA tests on the web

[jkstill]

Sorry, I misspelled your name as 'Audrey' in
my previous reply.

Jared

On Tue, 20 Mar 2001, andrey wrote:

> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materials , articles , books , etc ...
> Please share your resources !
> Thanks a lot in advance .
> Andrey .
>

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

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

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

Re: Free Oracle DBA tests on the web

[jkstill]

Audrey,

Try researching and answering at least one post
a day on this forum.

That will get you further than training tests. :)

Jared

On Tue, 20 Mar 2001, andrey wrote:

> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materials , articles , books , etc ...
> Please share your resources !
> Thanks a lot in advance .
> Andrey .
>

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

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

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

Re: Columns in triggers

[Rachel Carmichael]

If there is, I haven't found one ... that's what I've done on other 
applications I've worked on.

Rachel


>From: "Witold Iwaniec" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Columns in triggers
>Date: Tue, 20 Mar 2001 13:30:41 -0800
>
>Hi all
>
>I would like to create an audit trial for particular tables within Oracle
>database and thought about using triggers.
>
>I would like to log changes to each column separately. Is it
>possible to find dynamically name of the columns that were
>updated?
>
>I guess on INSERT I can check value of each column and if it is not
>NULL write the log, and on UPDATE I can compare the NEW and
>OLD values and write the log if different but wonder if there is
>better/nicer solution.
>
>Thanks
>
>Witold
>==
>Witold Iwaniec
>Senior Software Developer
>NovaLIS Technologies
>[EMAIL PROTECTED]
>http://www.novalistech.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

Job Pitch: Anyone out there know the IBM OS390 (US resident)

[dgoulet]

To ALL, especially those looking for a new position, I got the attached in the
Mail.  I've heard from these folks in the past & they have been helpful so I
don't think it's a spam (boy I've been wrong on that point before too).  Anyway
if there is anyone out there who can help Sean, give him a call or e-mail.

"Hello Richard,
I need a contact who knows a dba with specialized skills.  I need a DBA who has
worked in an IBM OS390 platform.  If you can provide me with a person like this,
I can give you $1000 contigent upon 90 days after the person is hired.

I have a client who is in desparate need of this person, if you can help me out,
I will make it worth your while.

Sean

AM Search Consulting   http://www.amsearch.com
1801 Research Boulevard,  Suite 602
Rockville, MD  20850
Phone:  301-315-9030 ext. 19
Fax:301-315-9036
Email:  [EMAIL PROTECTED]"
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- A humorous reply to the Canada rulz

[Steve Orr]

Actually, I think the Aztecs (or some other Central American tribe) invented
basketball and the losers were slain literally. Now that's what I call a
salary cap. We need something like that in professional sports today.

Steve Orr


-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of?
>
> * Smarties
>
> * Crispy Crunch & Coffee Crisp
>
> * The size of our footballs fields and one less Down
>
> * Baseball is Canadian
>
> * Lacrosse is Canadian
>
> * Hockey is Canadian
>
> * Basketball is Canadian
>
> * Apple pie is Canadian
>
> * Mr. Dress-up kicks Mr. Rogers ass
>
> * Tim Hortons kicks Dunkin' Donuts ass
>
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure...
>
> * Canada has the largest French population that never surrendered to
> Germany.
>
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere.
>
> * Our civil war was a bar fight that lasted a little over an hour.
>
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught.
>
> * We knew plaid was cool far before Seattle caught on.
>
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company
>
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes.
>
> * We still know what to do with all the parts of a buffalo.
>
> * We don't marry our kin-folk.
>
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year
>
> * We ALL have frozen our tongues to something metal and lived to tell
> about it.
>
> *  BUT MOST IMPORTANT!
>
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on.
>
>  ooh Canada!!
>
>  Oh yeah... and our elections only take one day.
>
>
--
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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListG

How to compare date in WHEN clause of SQL*Loader?

[Muru]

Hi,

I need to find whether SYSDATE falls between beginning
date and ending date while loading data from a flat
file. I searched Oracle manuals and Metalink, could
not find a clue. Is this possible at all? If so how?

example:
=
LOAD DATA
INFILE 'price.dat'
INTO TABLE price
WHEN TRUNC(SYSDATE) BETWEEN price_beg_date AND
price_end_date
(
price_code POSITION(1:3) CHAR
amount POSITION(4:7) INTEGER
price_beg_date POSITION(8:16) DATE 'MMDD'
price_end_date POSITION(16:24) DATE 'MMDD'
)

price.dat
==
AAA1318200103182002
BBB231823182001

While loading the above, only the first record should
get inserted. We can use a temporary table to load all
records and filter to final table using SQL, but the
data is huge and so filtering while loading would be a
better option. 

Any help is highly appreciated.

Thanks
Muru

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muru
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ITL and possible deadlocks

[Michael Netrusov]

Ed,

Not sure that I understood it right, but I'll take a try.
So there are 2 transactions and each one is trying to update the row which was already 
updated by the other transaction?
IMHO, if you are trying to place an exclusive lock on the locked row ( it remains 
locked until commit ), you either wait or receive
an error if "no wait" was specified.
Behaviour of the 2nd transaction is trying to place an exclusive lock on the 1st 
transaction' row is just the same.
If both transactions wait, it's a deadlock situation and should be resolved by Oracle 
itself.

HTH,
Michael Netrusov,
www.atelo.com


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 10:40


> Hello List,
>
> it's rather a theoretical question. Let say two sessions
> update a table. Each transaction allocated a transaction
> slot in a block (I consider the two different blocks).
> Each block has only one slot and there is no free space
> in these blocks to allocate additional transaction slots.
> Then each transaction tryes to update a row in the block
> which has already been updated by the other transaction.
> How Oracle to do with such situation in case when there is
> no access to a common resource (I mean a common row) ?
>
>
> Thanks in advance
>
> Ed
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Michael Netrusov
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Find special characters in the database

[jkstill]

First off, do you have Perl and DBD::Oracle or
Java?

Those would be the preferred methods to do something
like this, in this order. PL/SQL sould be a distant
third place as it is not very fast for this kind of
wholesale string operation.

PL/SQL may be a good choice though, if your requirements
for changing special characters are not too extensive.
i.e. you only have a small set of characters that need
to be changed.

Jared


On Tue, 20 Mar 2001, Shakeel Qureshi wrote:

>
> Can someone give me a guideline as to how I
> should draw a script to find special characters
> in the database and replace them with blanks.
>
> TIA
>
> Shakeel Qureshi
> [EMAIL PROTECTED]
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shakeel Qureshi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

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

RE: RE: RE: RE: OT: Rachel in Vietnam

[Mohan, Ross]

Title: RE: RE: RE: RE: OT: Rachel in Vietnam





BUFF bomb. That sounds cool. Will it work on developers?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 4:18 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: RE: OT: Rachel in Vietnam



Ross,


    Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run.  Nothing survived that. :-)


Dick Goulet


Reply Separator
Subject:    RE: RE: RE: OT: Rachel in Vietnam
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 8:02 AM


Dick , 


Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 


Just a thought. 


Ross


-Original Message-
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L



Rachel,


    If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the
logo on
top.  It just crunches better.


Dick Goulet


Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM


but Moom, the icky bugs TOUCHED the chocolate!   :)




>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: 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 ma

Re:RE: 32bit vs 64bit (was: Just like Christmas)

[dgoulet]

Kimberley,

The problem is that you loaded the 64 bit kernel in the K class.  It does
not have the buss required for 64 bit, therefore the kernel does a fake it 64
emulation.  Rebuild the machine with the 32 bit version of HP 11.0 & you'll be a
lot happier.  Ours stay up for months without problems & reboots are just fine. 
Personally I'd go kill your SA and/or the Hp zlutz that configured them.

Dick Goulet

Good hardware cannot fix bad software/configurations.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   3/20/2001 11:05 AM

We are going 64-bit for HP but keeping Oracle at 32-bit.  We really
had no choice for the HP side.  We just need the memory that 32 bit
could not support.  We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking).  But we are
getting rid of all our K-class servers.  The model we are running have
been nothing but trouble.  We hate to turn one off because it seems
like every time we reboot hardware dies.  Other fabs have been having
the same issue.  So we are going N-class for the database cluster
and A-class for the remaining.  Since your K-class servers are new they
probably don't have the same hardware issues we have.  HP even owned up
to having issues.

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.




This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: RE: OT: Rachel in Vietnam

[dgoulet]

Ross,

Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run.  Nothing survived that. :-)

Dick Goulet

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   3/20/2001 8:02 AM

Dick , 

Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 

Just a thought. 

Ross

-Original Message-
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


Rachel,

If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the
logo on
top.  It just crunches better.

Dick Goulet

Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM

but Moom, the icky bugs TOUCHED the chocolate!   :)



>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Net

Special characters in database

[Shakeel Qureshi]

Hi list:

I am looking for some guidance as to how I should
find special characters used in the database and 
then replace them with blanks.

If someone has a drawn procedure, would appreciate
feed back.

TIA,

Shakeel Qureshi
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  INET: [EMAIL PROTECTED]

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

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

Re: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

[Kevin Kostyszyn]

Yeah, more money!
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:30 PM


> And like a lot of Canadian doctors he became an U.S. citizen
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 12:57 PM
> To: Multiple recipients of list ORACLE-L
>
>
> First off, I had no idea that a Canadian had invented baseball but
> a Canadian most definitely invented Basketball.  Go look it up.
> However, he was in the States when he invented it.
>
> Once we get rid of Quebec we will have no issues as to what language
> we are.  We are bilingual.  Except for Quebec we are accepting of that.
> Another Canadian trait.
>
> As for bikini's, it can actually get quite warm in Canada.  I have seen
> many a bikini.  Personally I don't wear one but I would not be cold if
> I did wear one in the summer.  Did you know that there are parts of Canada
> that are further south then the USA.  I actually went up quite a few
> degrees when I moved from Halifax, NS to Portland, OR.  Check it out.
>
> And as for us being culturally like the US, don't see it man.  We are
> not nearly as paranoid (generalizing here on in) as Americans.  We pay
> so much more taxes, and we do complain, but the people here bring it to
> a whole new level.  I hear that we are friendlier but I am not so sure
> of that one.  Maybe initially it seems like that because we are not
> so paranoid and trust right away.  Lets see, how many school shooting did
> we have last year.  I know of one but there might have been more.  Never
> been to a school with a metal detector but I do know of one high school
that
> is bigger then a lot of Universities that does have a cop on site.  We are
> much more accepting of technology.  Got that one out of the news many
times,
> plus it amazes me some of the things you guys just don't do in the States
> that we have been doing for years.  Our banks carry foreign currency and
are
> much easier to deal with.  Almost like they like customers.  That
> has been a big problem for me here in Portland.
>
> I could go on but I am sure I pissed many Americans off already.  Don't
> get me wrong, I like the States and am enjoying my time here but we are
not
> Americans!  Nor do we want to be.  I just want the money:-)
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 10:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
> U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
> Russians invented everything?  I might be wrong (happens all the time),
but
> I thought Baseball and Basketball were distinctly inventions of the USA.
> You might be able to tell I'm a rabid fan of neither.  Penicillin and the
> telephone??  Other delusions of grandeur?  How about the only country that
> can't decide if they're English or French?  How about the US's biggest
> colony via cultural conquest(ohh, that's a low blow).  How about never
> saw a bikini except in National Geographic?  I could go on, but I'm not
sure
> my humor translates all that well, and the firewall has Babelfish blocked.
>
> Dan "not about to give up my day job"
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 12:37 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Sorry about this, but someone sent me this and I thought it might be
> relevant to the Canada and US discussion that took place last week.
>
> With all the recipes going around, I thought it wouldn't do any harm.
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
>
> > -Original Message-
> >  So, what do Canadians have to be proud of?
> >
> > * Smarties
> >
> > * Crispy Crunch & Coffee Crisp
> >
> > * The size of our footballs fields and one less Down
> >
> > * Baseball is Canadian
> >
> > * Lacrosse is Canadian
> >
> > * Hockey is Canadian
> >
> > * Basketball is Canadian
> >
> > * Apple pie is Canadian
> >
> > * Mr. Dress-up kicks Mr. Rogers ass
> >
> > * Tim Hortons kicks Dunkin' Donuts ass
> >
> > * In the war of 1812, started by America, Canadians pushed the
> > Americans back...past their 'White House'.   Then we burned it...  and
> > most
> > of Washington, under the command of William Lyon McKenzie  who was
insane
> > and hammered all the time.  We got bored because they ran away, so we
came
> > home and partied ... Go  figure...
> >
> > * Canada has the largest French population that never surrendered to
> > Germany.
> >
> > * We have the largest English population that never ever surrendered
> > or withdrew during any war to anyone, anywhere.
> >
> > * Our civil war was a bar fight that lasted a little over an hour.
> >
> > * The only person who was arrested in our civil war was an American
> > mercenary, who slept in and missed the whole thing...but showed up just
in
> > time to get caught.
> >
> > * We knew plaid was cool far before Seattle caught on.
> >
> > * The Hudsons Bay Company once owned over 10%

Re: Slow database

[Oliver Artelt]

Hi,

it's difficult to help you because we don't know anything about your 
nightmare skript. Either you do a business/application tuning about these 
procedures or you can create a ressource plan and drive this with low 
processor resources.

oli
-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de



[EMAIL PROTECTED] wrote
> Hallo all you experts,
>
> I have an Oracle database, every night it is read many files into the
> database, but all the procedures take so long, it keeps taking  all the
> next  day almost. It shouldnt do that, because the system is very slow
> because of this. When I run other things during the day, many things  are
> slow, for instance when i delete 1000 rows it shouldnt take one hour, which
> it takes while the "big" process is running. Do you have any suggestion
> what I  should do to trace the whole problem? When i delete 1000 rows
> during "low"-time, then it just take a few seconds to delete the records.
> Hope anyone can help me with suggestions.
>
>
> Roland Sköldblom
>
>
>
>
> --
> 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).
>
> To: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: [EMAIL PROTECTED]

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

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

Re: OT -- Canada Rules! / Chocolate ...

[Kevin Kostyszyn]

Yeah, but do you guys have Texas Weiners??  I think not!!  Now those are
g.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 7:05 PM


> The Smarties we are talking about in Canada are much
> different.  Candy covered chocolate.  No sour taste at
> all.  Crispy Crunch is a chocolate bar (forget what the
> inside is, maybe peanut butter).
>
>
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 1:30 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kathe,
> I thought every red-blooded American knew what Smarties where.  And since
I
> have become the newest OCP (Other Confection Professional), I will
enlighten
> you.  Smarties are a "penny" candy, sour in taste about the size of an M&M
> vended in plastic wrap of 12-15 in a stack.  I think Crispy Crunch is
> similar to our Cracker Jacks, but I'll let some of our northern neighbors
> confirm that.
>
> More importantly what was this War of 1812 I keep hearing about ;)
>
> Mike
>
> --
> 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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- A humorous reply to the Canada rulz

[MacGregor, Ian A.]

It was  Mr. Checkov who thought the Russians invented everything.  Alexander G. Bell 
maintained at home at Baddeck, Nova Scotia, but he was a Scot, not a Canadian.  I'm 
not sure where the telephone was invented, I seem to remember someplace in New York.  
Dr. Nasmith of Massachusets is usually credited with the invention of basketball.  I 
cannot remember who is now credited with baseball; it is an American, but not Abner 
Doubleday.  I always assumed that Ian Fleming, the discover of penicillin was British. 
Smarties are like M&M's but not as good.  There are some great Canadian chocolate 
bars, but the canonical Canadian boxed chocolates, Moir's, are awful.  Apple pie is 
not Canadian, but Apple Pie and cheddar cheese may be.  Apples are originally from the 
Steppe region of Russia.  I thought velcro was invented by either a Frenchman or a 
Belgian who noticed how burrs stuck to his clothing after walking through a field.  
Didn't Marconi invent shortwave radio.  I thought he was Bri!
!
tish of
Italian descent who sent the first long distance radio signal from St John's 
Newfoundland  to London.  Marconi  electronics is/was  certainly a British firm.
  
   

I was born and raised California, but attended Dalhousie University; both my parents 
are from Cape Breton.

The greatest hockey game of the modern era was the first game of the original Canada 
Cup Series between the Russian Red Army team and the Montreal Canadiens.  Les Habs 
could skate stride for stride with the Russians, something no other Canadian NHL team 
could come close to doing.  The game a near-run thing was won by the Russians, because 
their goalie, Mr. Tretiak, outplayed Ken Dryden.  

Lunch is over back to work.

Ian MacGregor
Stanford Linear Accelerator Center 
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * We don't marry our kin-folk. 
> 
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year 
> 
> * We ALL have frozen our tongues to something metal and lived to tell
> about it. 
> 
> *  BUT 

JVM in Oracle 8.1.6/HP-UX

[Majumdar, Uttam]

Hi all,
   I am executing  initjvm.sql to load oracle java classes into oracle 8.1.6
database under HP-UX 32bit environment. Suddenly the process stops with the
following error:
ORA-04021: time out occurred while waiting to lock object 
 SYS.INITJVMAUX.

My SGA is around 400M and Java-pool-size is 100M.

Any idea to solve this problem will be highly appreciated. I am tired of
using metalink ..response is very slow.

Regards;
Uttam majumdar
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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


PG&E National Energy Group and any other
company referenced herein that uses the PG&E name or
logo are not the same company as Pacific Gas and
Electric Company, the regulated California utility.  Neither
PG&E National Energy Group nor these other
referenced companies are regulated by the California Public
Utilities Commission.  Customers of Pacific Gas and Electric Company
do not have to buy products from these companies in order
to continue to receive quality regulated services from the utility.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Majumdar, Uttam
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: avail space??

[Mohammad Rafiq]

Raghu,

To reorg Oracle Financials table is very tricky as some triggers created by 
apps whereas owner of tables may AR. If you drop any stuf ,you will lose 
those triggers. As table size is big truncate and reinsert option will 
create a lot of logs(if ver 7.3.4).

The best way to capture back space, rebuild indexes on such tables with 
unrecoverable option as index space is not released with deletion of 
table data besides it makes holes in indexes making it inefficient..

HTH,
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 19 Mar 2001 10:50:26 -0800

Hi Friends

I have some tables ranging 2-10G and almost same range of Indexes!! We
purged(Deleted some data from 98 and 99 data) So My task as dba need to
avail that purged space from Table and Index??? How can I do that with out
Export/Import of Tables??? What is mechanism to reuse the space from deleted
rows both in Indexes and Table?? Mine is oracle7.3 on AIX.

Thanks for Your Help
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 32bit vs 64bit (was: Just like Christmas)

[Christian Bilien]

In theory, 32 to 64 bits means a loss of performance due to a lesser number
of entries in the Translation Lookaside Buffer (I have seen several times
mentionning a loss of 5-10%, but I never ran into actual tests). This of
course can be compensated by the larger memory you can address.

Christian

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 7:15 PM


> Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
> HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin),
which
> means I can FINALLY get us to 8i!  YAY!
>
> So, why or why not should one go to 64bit?  Here's my perception:
>
> Pros
> ---
> Should be faster (moving 2x as many bits around)
>
> Cons
> ---
> Requires major downtime to go from 32 to 64.
> Patches don't seem to come as quickly as 32bit versions on HP.
>
> Unknowns (for me)
> -
> How much faster, if at all, and in what areas (mem, I/O, disk)?
> Possible client problems?  Our clients are all 8.0.5 for now.
> Any difference/disadvantage if 3rd party OCI programs are
> not recompiled?
>
> TIA,
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 20, 2001 11:06
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re:Just like Christmas
> >
> >
> > Kimberly,
> >
> > Enjoy the N class boxes, especially in 64 bit mode.  They
> > really cook
> > compared to a K.
>
>
> 
>
> This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>

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

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

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

RMAN Backup and Recovery

[Donald Bricker]

We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I 
have put into place are Once a week a Level 0 full backup, three times a week Level 1 
incremental and three times archive logs only.
Can anyone suggest some different recovery scenarios to test? Or if I missed any 
backups.

Thanks

Don Bricker
Information Systems Analyst
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290







We are in the midst of starting to use RMAN for our Backup and 
Recovery. The backups I have put into place are Once a week a Level 0 full 
backup, three times a week Level 1 incremental and three times archive logs 
only.
Can anyone suggest some different recovery scenarios to test? 
Or if I missed any backups.
 
Thanks
 
Don BrickerInformation Systems AnalystIllinois 
Environmental Protection Agency1021 North Grand Avenue EastMail Code 
#32Springfield, IL 62794-9276mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED](217)
 
558-2290

Re: your mail

[jkstill]

On Tue, 20 Mar 2001, Ginger Mejia wrote:

> IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES
> AVAILABLE?
>
> --


Yes, but please don't abuse the privilege.

Don't post a position more than once a week; if you
have several, please send them in a single message.

And thanks for asking first. :)

Jared ( list owner )


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

Columns in triggers

[Witold Iwaniec]

Hi all

I would like to create an audit trial for particular tables within Oracle 
database and thought about using triggers. 

I would like to log changes to each column separately. Is it 
possible to find dynamically name of the columns that were 
updated?

I guess on INSERT I can check value of each column and if it is not 
NULL write the log, and on UPDATE I can compare the NEW and 
OLD values and write the log if different but wonder if there is 
better/nicer solution.

Thanks

Witold
==
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED] 
http://www.novalistech.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

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

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

Re: OT -- Canada Rules! (fwd)

[Kevin Kostyszyn]

That's not why they are some of the best, they were already some of the best
if they were able to get there.  Fact is, that it used to be just Canadians
who were the bomb, now good old American boys are actually climbing the
ranks.  Now don't get me wrong, we ain't bread no Gretzky yet, but who
knows!
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:30 PM


> Do you know that all most of the top ranked American/European hockey
> players actually played in the CHL.  They start by getting drafted in
> the major junior leagues.  So ya, you could be just as good as an
> American, as long as you train in Canada.  In Canada if you are playing
> hockey for your University team that is pretty much the end of your
> career (unless you want to play senior).
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 10:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Yeah, but we could kick your XXX!!  Not to mention that American Hockey
> players are just as good if not better than Canadians!
> --
> 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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

RE: redo log timing

[Jeffery Stevenson]

  For a heavy transactional system, I'd (like) to try to keep it around
20-30 minutes per switch, but most of the databases I'm dealing with right
now are hybrids.  Basically, lots of reporting all day long with occassional
updates to data (unless they decide to re-calculate the figures during the
day then they get lots of updates--yeah, I know it's not a good thing, but
they had that part designed and implemented before I took over here).  Then
they do batch processing of new data from clients at night (but usually
these clients put off their data entry until the end of the week, and at
some places the end of the month).  Usually this will give me up to 2-3 days
between switches and then during heavy hit times I've tried to plan for it
being in the 15-30 minute range (right now it's about one every 1.5 hours
during high activity, but there will be a lot more clients by the end of the
year).  Like Rodd pointed out, it does make a difference how much time you
can afford to be without data (I have redundant files so I can reload daily
data if worse comes to worse and only have to worry about minor client
updates during the day...although I am working on a strategy to check for
low activity and then switch the logs on a regular basis to help minimize
any recovery burden).  As for upper and lower limits, I've seen databases
switching every 5-6 minutes and not have any problems, but I've seen some
where the redo logs were created too small and when the users hit the system
heavily, the database would cycle through the redo logs all the way to the
one being currently archived.  There are a few variables here, but I
generally follow the advice I got a long time back for this, "Just run
through all the different scenarios and go with the one that makes you feel
least nauseous when you think about it."

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX


-Original Message-
Sent: Tuesday, March 20, 2001 12:32 PM
To: Multiple recipients of list ORACLE-L


Ian,
This is one of those where you can get the old "it depends" answer.
What type of database is this?  What level of transaction activity do you 
have?  How big are your redo logs if you switch every 15 min, 20 min, 30
min? 
How critical is recovery to the current time to you?

If you don't want the overhead of lots of log switches and you can stand to 
have a possible loss of 30 minutes of data on a recovery then 2/hr would 
work. (Possiblity of data loss based on losing all logs and mirror logs in a

recovery scenario).

Others may have differing opinions on this, but I normally keep mine running

in the 15-20 minute range.  The overhead difference between 2 switches/hour 
and 3 or 4 per/hour is generally not noticeable.  It makes for smaller 
archives which makes the gzip of the log run faster and take up less cpu 
time.  (I run a cron job that compresses the archived logs to save disk 
space).

On Tuesday 20 March 2001 11:36, you wrote:
>
> Now for an Oracle question.  It is often touted that redo logs should
> switch every 15 minutes to 30 minutes.  Are these the lower and upper
> limits, should the average time to switch logs be within that range, or
> should the median be between that range?
>
> Ian MacGregor
> Stanford Linear Accelerator
> [EMAIL PROTECTED]
>
>

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Jeffery Stevenson
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log timing

[MacGregor, Ian A.]

The reason I proposed the question is the rule seems to  deal with databases which 
have a constant transaction rate.  Ours are highly variable.  I've gone with keeping 
the median within  15 and 30 minutes.  Our logs are 200MB and can switch as often as a 
once  per minute to as seldom as once every 3 hours.   I am familiar with all the 
benefits and drawbacks of small and large redo logs.  I also assume  that a 
catastrophic lost of the online acrtive redo log which is taking three hours to fill 
is no worse that losing one which takes less than a minute to fill.

I don't compress the archives,  I back them up and then delete them via cron; not 
necessarily the best approach.


Ian MacGregor
Stanford Linear Acclerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, March 20, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L


Ian,
This is one of those where you can get the old "it depends" answer.
What type of database is this?  What level of transaction activity do you 
have?  How big are your redo logs if you switch every 15 min, 20 min, 30 min? 
How critical is recovery to the current time to you?

If you don't want the overhead of lots of log switches and you can stand to 
have a possible loss of 30 minutes of data on a recovery then 2/hr would 
work. (Possiblity of data loss based on losing all logs and mirror logs in a 
recovery scenario).

Others may have differing opinions on this, but I normally keep mine running 
in the 15-20 minute range.  The overhead difference between 2 switches/hour 
and 3 or 4 per/hour is generally not noticeable.  It makes for smaller 
archives which makes the gzip of the log run faster and take up less cpu 
time.  (I run a cron job that compresses the archived logs to save disk 
space).

On Tuesday 20 March 2001 11:36, you wrote:
>
> Now for an Oracle question.  It is often touted that redo logs should
> switch every 15 minutes to 30 minutes.  Are these the lower and upper
> limits, should the average time to switch logs be within that range, or
> should the median be between that range?
>
> Ian MacGregor
> Stanford Linear Accelerator
> [EMAIL PROTECTED]
>
>

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- A humorous reply to the Canada rulz

[Dennis Taylor]

At 10:07 AM 3/20/01 -0800, you wrote:
>U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
>Russians invented everything?

I'm sure you're going to take a lot of hits on that one -- it was Mr Chekov.

>I thought Baseball and Basketball were distinctly inventions of the USA.

Can't comment on baseball (which is just an adaptation of cricket), but
basketball was definitely a canadian invention.

>How about the only country that
>can't decide if they're English or French?

We can decide. We just can't agree on the answer.

>How about the US's biggest
>colony via cultural conquest(ohh, that's a low blow).

Wouldn't that actually *require* culture? (ooohh, even lower :-)

>How about never
>saw a bikini except in National Geographic?

*ahem* come on out to the wet coast some time, visit Wreck beach. You'll
never see a bikini there, or any other form of cloth covering.





Dennis Taylor

If it sticks - force it!
If it breaks - it needed replacing anyway.

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

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

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

Re: OT: Rachel in Vietnam

[Thater, William]

Rachel Carmichael wrote:
> 
> I'm old but not THAT old :)  would not have been draftable even at the end
> of the war (even if I were male!)

i am, and i was, and i don't. [and it doesn't have to do with the bugs.]

--
Bill Thater  Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

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

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

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

RE: OT -- A humorous reply to the Canada rulz

[Boivin, Patrice J]

Home of baseball... home of baseball...

That doesn't mean anything -- it's like billboards that say "Our product was
voted the best!"

The best what?

Voted by whom?

Emotion with no context.  Advertising at its best!

Do you know how many "blueberry capital of the world" towns there are in
Canada?  There must be hundreds of them.

: )

BTW I don't know if all that stuff was true, although I know the telephone,
Marconi, and basketball are very likely to be true.

And I know there are no smarties in the U.S., a friend of mine went to PA
for a while and he practically begged us to mail him some.

Pat.

> -Original Message-
> From: Kevin Kostyszyn 
> Sent: Tuesday, March 20, 2001 3:12 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OT --  A humorous reply to the Canada rulz
> 
> Wow that was good!!  You know, I don't really like baseball, but I am
> pretty
> sure that when you drive into Hoboken it says on a sign "Home of Baseball
> and Frank Sinatra". hmm   Canada invented hockey, but they also
> invented
> curling didn't they.  Yeah, isn't that like the Canadian version of
> shuffle
> board?
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 1:07 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
> Russians invented everything?  I might be wrong (happens all the time),
> but
> I thought Baseball and Basketball were distinctly inventions of the USA.
> You might be able to tell I'm a rabid fan of neither.  Penicillin and the
> telephone??  Other delusions of grandeur?  How about the only country that
> can't decide if they're English or French?  How about the US's biggest
> colony via cultural conquest(ohh, that's a low blow).  How about never
> saw a bikini except in National Geographic?  I could go on, but I'm not
> sure
> my humor translates all that well, and the firewall has Babelfish blocked.
> 
> Dan "not about to give up my day job"
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 12:37 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sorry about this, but someone sent me this and I thought it might be
> relevant to the Canada and US discussion that took place last week.
> 
> With all the recipes going around, I thought it wouldn't do any harm.
> 
> Regards,
> 
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
> 
> 
> 
> > -Original Message-
> >  So, what do Canadians have to be proud of?
> >
> > *   Smarties
> >
> > *   Crispy Crunch & Coffee Crisp
> >
> > *   The size of our footballs fields and one less Down
> >
> > *   Baseball is Canadian
> >
> > *   Lacrosse is Canadian
> >
> > *   Hockey is Canadian
> >
> > *   Basketball is Canadian
> >
> > *   Apple pie is Canadian
> >
> > *   Mr. Dress-up kicks Mr. Rogers ass
> >
> > *   Tim Hortons kicks Dunkin' Donuts ass
> >
> > *   In the war of 1812, started by America, Canadians pushed the
> > Americans back...past their 'White House'.   Then we burned it...  and
> > most
> > of Washington, under the command of William Lyon McKenzie  who was
> insane
> > and hammered all the time.  We got bored because they ran away, so we
> came
> > home and partied ... Go  figure...
> >
> > *   Canada has the largest French population that never surrendered to
> > Germany.
> >
> > *   We have the largest English population that never ever surrendered
> > or withdrew during any war to anyone, anywhere.
> >
> > *   Our civil war was a bar fight that lasted a little over an hour.
> >
> > *   The only person who was arrested in our civil war was an American
> > mercenary, who slept in and missed the whole thing...but showed up just
> in
> > time to get caught.
> >
> > *   We knew plaid was cool far before Seattle caught on.
> >
> > *   The Hudsons Bay Company once owned over 10% of the earth's surface
> > and is still around as the worlds oldest company
> >
> > *   The average dog sled team can kill and devour a full grown human in
> > under 3 minutes.
> >
> > *   We still know what to do with all the parts of a buffalo.
> >
> > *   We don't marry our kin-folk.
> >
> > *   We invented ski-doos, jet-skis, velcro, zippers, insulin,
> > penicillin, zambonis, the telephone and short wave radios that save
> > countless lives each year
> >
> > *   We ALL have frozen our tongues to something metal and lived to tell
> > about it.
> >
> > *BUT MOST IMPORTANT!
> >
> > *the handles on our beer cases are big enough to fit your hands
> > with mitts on.
> >
> >  ooh Canada!!
> >
> >  Oh yeah... and our elections only take one day.
> >
> >
> --
> 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
> 

RE: OT -- Canada Rules! / Chocolate ...

[Kimberly Smith]

The Smarties we are talking about in Canada are much
different.  Candy covered chocolate.  No sour taste at
all.  Crispy Crunch is a chocolate bar (forget what the
inside is, maybe peanut butter).  



-Original Message-
Sent: Tuesday, March 20, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L


Kathe,
I thought every red-blooded American knew what Smarties where.  And since I
have become the newest OCP (Other Confection Professional), I will enlighten
you.  Smarties are a "penny" candy, sour in taste about the size of an M&M
vended in plastic wrap of 12-15 in a stack.  I think Crispy Crunch is
similar to our Cracker Jacks, but I'll let some of our northern neighbors
confirm that.

More importantly what was this War of 1812 I keep hearing about ;)

Mike

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

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

[Shaw, John B]

And like a lot of Canadian doctors he became an U.S. citizen

-Original Message-
Sent: Tuesday, March 20, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L


First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball.  Go look it up.  
However, he was in the States when he invented it.  

Once we get rid of Quebec we will have no issues as to what language
we are.  We are bilingual.  Except for Quebec we are accepting of that.
Another Canadian trait.  

As for bikini's, it can actually get quite warm in Canada.  I have seen
many a bikini.  Personally I don't wear one but I would not be cold if
I did wear one in the summer.  Did you know that there are parts of Canada
that are further south then the USA.  I actually went up quite a few 
degrees when I moved from Halifax, NS to Portland, OR.  Check it out.

And as for us being culturally like the US, don't see it man.  We are
not nearly as paranoid (generalizing here on in) as Americans.  We pay
so much more taxes, and we do complain, but the people here bring it to
a whole new level.  I hear that we are friendlier but I am not so sure
of that one.  Maybe initially it seems like that because we are not 
so paranoid and trust right away.  Lets see, how many school shooting did
we have last year.  I know of one but there might have been more.  Never
been to a school with a metal detector but I do know of one high school that
is bigger then a lot of Universities that does have a cop on site.  We are
much more accepting of technology.  Got that one out of the news many times,
plus it amazes me some of the things you guys just don't do in the States
that we have been doing for years.  Our banks carry foreign currency and are
much easier to deal with.  Almost like they like customers.  That
has been a big problem for me here in Portland. 

I could go on but I am sure I pissed many Americans off already.  Don't
get me wrong, I like the States and am enjoying my time here but we are not
Americans!  Nor do we want to be.  I just want the money:-)

-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * W

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

[Kevin Kostyszyn]

Answered your own question, we have more money!!!  It's fun to go to Canada
and feel like a "wealthy" american.  Jeez, I wished I lived in Buffalo, I
would go to Canada and hang out and spend less money!  hahaah jk, not trying
to pick a fight







USA RULES

-Original Message-
Smith
Sent: Tuesday, March 20, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L


First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball.  Go look it up.
However, he was in the States when he invented it.

Once we get rid of Quebec we will have no issues as to what language
we are.  We are bilingual.  Except for Quebec we are accepting of that.
Another Canadian trait.

As for bikini's, it can actually get quite warm in Canada.  I have seen
many a bikini.  Personally I don't wear one but I would not be cold if
I did wear one in the summer.  Did you know that there are parts of Canada
that are further south then the USA.  I actually went up quite a few
degrees when I moved from Halifax, NS to Portland, OR.  Check it out.

And as for us being culturally like the US, don't see it man.  We are
not nearly as paranoid (generalizing here on in) as Americans.  We pay
so much more taxes, and we do complain, but the people here bring it to
a whole new level.  I hear that we are friendlier but I am not so sure
of that one.  Maybe initially it seems like that because we are not
so paranoid and trust right away.  Lets see, how many school shooting did
we have last year.  I know of one but there might have been more.  Never
been to a school with a metal detector but I do know of one high school that
is bigger then a lot of Universities that does have a cop on site.  We are
much more accepting of technology.  Got that one out of the news many times,
plus it amazes me some of the things you guys just don't do in the States
that we have been doing for years.  Our banks carry foreign currency and are
much easier to deal with.  Almost like they like customers.  That
has been a big problem for me here in Portland.

I could go on but I am sure I pissed many Americans off already.  Don't
get me wrong, I like the States and am enjoying my time here but we are not
Americans!  Nor do we want to be.  I just want the money:-)

-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of?
>
> * Smarties
>
> * Crispy Crunch & Coffee Crisp
>
> * The size of our footballs fields and one less Down
>
> * Baseball is Canadian
>
> * Lacrosse is Canadian
>
> * Hockey is Canadian
>
> * Basketball is Canadian
>
> * Apple pie is Canadian
>
> * Mr. Dress-up kicks Mr. Rogers ass
>
> * Tim Hortons kicks Dunkin' Donuts ass
>
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure...
>
> * Canada has the largest French population that never surrendered to
> Germany.
>
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere.
>
> * Our civil war was a bar fight that lasted a little over an hour.
>
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught.
>
> * We knew plaid was cool far before Seattle caught on.
>
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company
>
> * The avera

RE: OFF TOPIC: RE: Lemon Juice in Ants Pooh-Poohed

[Kevin Kostyszyn]

OH GOD THAT'S IT!!!   I can't even look at the thing on my monitor...man I
have problems!

-Original Message-
Travis
Sent: Tuesday, March 20, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L


I think what you are referring to is the camel [back] cricket, which is also
known as the cave cricket.

Look here --> http://entweb.clemson.edu/cuentres/cesheets/hhold/ce190.htm
and http://www.ent.iastate.edu/ipm/iiin/ccamelcr.html

We had alot of them in our basement - and boy, can they jump!

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Toepke,
> Kevin M
> Sent: Tuesday, March 20, 2001 9:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Lemon Juice in Ants Pooh-Poohed
>
>
> Kevin, Kevin, Kevin...
>
> Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're
> not even crickets! They're related to the grasshopper) Are the antenea as
> long as the rest of the body? And even if they are Cave Crickets,
> they won't
> bother you. They just come out of the cave to feed.
>
> Kevin Toepke
> Caver and Semi-professional, Semi-competent DBA-type guy
> P: 614/652-5117
> F: 614/652-5401
> -
> The information in this electronic mail message is Cendant Confidential
> and may be legally privileged. It is intended solely for the
> addressee(s). Access to this Internet electronic mail message by anyone
> else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or action taken or omitted to be taken
> in reliance on it is prohibited and may be unlawful.
> -
> The sender believes that this E-mail and any attachments were free of
> any virus, worm, Trojan horse, and/or malicious code when sent. This
> message and its attachments could have been infected during
> transmission. By reading the message and opening any attachments, the
> recipient accepts full responsibility for taking protective and remedial
> action about viruses and other defects. Cendant Corporation is not
> liable for any loss or damage arising in any way from this message or
> its attachments.
> -
>
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 8:26 AM
> To: Multiple recipients of list ORACLE-L
>
>
> It doesn't matter if they give off a sweet lemony aroma, I am thinking I
> don't want to eat ants!!  The only time I would eat ants is if I was
> stranded somewhere and had no food.  See, I really don't like
> insects, they
> bother me, not all of them.  A lot of ants sickens me, I am terrified of
> spiders BIG TIME!!   Also, here in Jersey, we have these bugs, they are
> called cave crickets I believe.  Oh man do they freak me out,
> they look like
> a mix of a big spider and a cricket!!  They jump about 3 feet in
> the air and
> are by far one of the ugliest things I have ever seen.  I won't
> go in a room
> if I know one is in there, I know they can't hurt me, but it's just a
> phobia.  Sorry for getting so far off of the topic!
> Kev
>
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Toepke, Kevin 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: Glenn Travis
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Re: Free Oracle DBA tests on the web

[Andy Duncan]

Hi Andrey,

> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materials , articles , books , etc ...
> Please share your resources !
> Thanks a lot in advance .



Check out the links in Table 1-1 on the following page:
=> http://www.oreilly.com/catalog/oracleopen/chapter/ch01.html

It took me and Sean Hull a ridiculous period of time to collect all of those
(too much to mention).  If you'd like to read about how we did it, why we did
it, and get as much installation/user documentation on them all, as we could
physically squeeze into 500 pages, please book your copy now, of:

=> http://www.oreilly.com/catalog/oracleopen/ (out around April 15th)

 :-)

Rgds,
AndyD

PS> The cheque's in the post.

=
[EMAIL PROTECTED]

O'Reilly's "Oracle and Open Source": 
=> http://www.oreilly.com/catalog/oracleopen/

Orac, Perl/Tk and Perl DBI Database DBA & Development Tool: 
=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andy Duncan
  INET: [EMAIL PROTECTED]

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

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

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz - s

[Dasko, Dan]

WoooHooo, this could really get things hot down here.  Again, I have no idea
of what I'm talking about.  Just a bunch of stuff that I "know" which is
probably wrong.  Additionally, I imagine people in Miami think Philadelphia
is the Great White North, so the whole bikini thing was a jab at the
stereotype, not the reality, and I do hear the Hortons rule, but look out
for Krispy Kreme hehe.  Quebec, is that like the crazy Uncle no one wants to
talk about?  The cultural thing is from some vague newspaper dropping of a
story I kind of vaguely remember from 6 years ago :)

Dan looking forward to a Tim Horton

-Original Message-
Sent: Tuesday, March 20, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L


First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball.  Go look it up.  
However, he was in the States when he invented it.  

Once we get rid of Quebec we will have no issues as to what language
we are.  We are bilingual.  Except for Quebec we are accepting of that.
Another Canadian trait.  

As for bikini's, it can actually get quite warm in Canada.  I have seen
many a bikini.  Personally I don't wear one but I would not be cold if
I did wear one in the summer.  Did you know that there are parts of Canada
that are further south then the USA.  I actually went up quite a few 
degrees when I moved from Halifax, NS to Portland, OR.  Check it out.

And as for us being culturally like the US, don't see it man.  We are
not nearly as paranoid (generalizing here on in) as Americans.  We pay
so much more taxes, and we do complain, but the people here bring it to
a whole new level.  I hear that we are friendlier but I am not so sure
of that one.  Maybe initially it seems like that because we are not 
so paranoid and trust right away.  Lets see, how many school shooting did
we have last year.  I know of one but there might have been more.  Never
been to a school with a metal detector but I do know of one high school that
is bigger then a lot of Universities that does have a cop on site.  We are
much more accepting of technology.  Got that one out of the news many times,
plus it amazes me some of the things you guys just don't do in the States
that we have been doing for years.  Our banks carry foreign currency and are
much easier to deal with.  Almost like they like customers.  That
has been a big problem for me here in Portland. 

I could go on but I am sure I pissed many Americans off already.  Don't
get me wrong, I like the States and am enjoying my time here but we are not
Americans!  Nor do we want to be.  I just want the money:-)

-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
>

Indexes and tablespaces

[Berindei Alex]

 
Hello,
 
I have a partitioned historical table in tablespace TS1 with 8 local
indexes.
I'm not sure how is better to:
- put the eight indexes in separate tablespaces (with small extents) or
- create just one big tablespace (with larger extents) for all indexes.
 
Other concerns include:
- a formula to calculate extents for indexes, tablespaces and data files
associated.
- is there a tool to help?
 
Thanks, alex.
 
 
Below the definitions for table and indexes (don't laugh too much!), using
just one big tablespace UC_OP_TSIX_200103.
 
CREATE TABLESPACE UC_OP_TS_200103
 DATAFILE
   'D:\ORANT\DATABASE\UC_OP_TS_200103_1.ORA'  SIZE 512M AUTOEXTEND ON NEXT
512M
 ,  'D:\ORANT\DATABASE\UC_OP_TS_200103_2.ORA'  SIZE 512M AUTOEXTEND ON NEXT
512M
 SIZE 1024M AUTOEXTEND ON NEXT 1024M;

CREATE TABLESPACE UC_OP_TSIX_200103
 DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_1.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
, DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_2.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
, DATAFILE 'D:\ORANT\DATABASE\UC_OP_TSIX_200103_3.ORA' SIZE 512M AUTOEXTEND
ON NEXT 512M
 SIZE 512M AUTOEXTEND ON NEXT 512M;

CREATE TABLE OPERAZIONE (
   ID   NUMBER(13) NOT NULL,
   ABI  VARCHAR2(5) NULL,
   CAB  VARCHAR2(5) NULL,
   PERSONALE_MATRICOLA  VARCHAR2(10) NOT NULL,
   DIPENDENZA   NUMBER(5) NOT NULL,
   TERMINALENUMBER(3) NOT NULL,
   NUMERO   NUMBER(7) NOT NULL,
   DATA_CONTABILE   DATE NOT NULL,
   DATA_DATE NOT NULL,
   DATA_DISPONIBILITA   DATE NULL,
   DATA_VALUTA  DATE NULL,
   COD_TRANSAZIONE  VARCHAR2(8) NULL,
   DIVISA_UIC   NUMBER(3) NOT NULL,
   IMPORTO  NUMBER(18,3) NOT NULL,
   TIPO VARCHAR2(1) NOT NULL,
   NUM_RIFERIMENTO  NUMBER(10) NULL,
   COD_CAUSALE  NUMBER(3) NULL,
   CONTO_DIPENDENZA NUMBER(5) NULL,
   CONTO_CATEGORIA  NUMBER(3) NULL,
   CONTO_NUMERO NUMBER(7) NULL,
   DESCRIZIONE  VARCHAR2(50) NULL,
   DATA_IMPORTAZIONEDATE NOT NULL,
   BUSTA_ID NUMBER(11) NULL,
   IMMAGINE_ID  NUMBER(11) NULL
) 
PARTITION BY RANGE( DATA_ )
(
  PARTITION OP_P_200103 VALUES LESS THAN(TO_DATE('01-04-2001
00:00:00','DD-MM- HH24:MI:SS'))
TABLESPACE UC_OP_TS_200103
PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);

CREATE INDEX OPERAZIONE_IX_ID ON OPERAZIONE
(
  ID ASC
)
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_BUSTA_ID ON OPERAZIONE
(
   BUSTA_ID   ASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_IMMAGINE_ID ON OPERAZIONE
(
   IMMAGINE_IDASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_DIPENDENZA ON OPERAZIONE
(
   DATA_  ASC,
   DIPENDENZA ASC,
   PERSONALE_MATRICOLAASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_IMPORTO ON OPERAZIONE
(
   DATA_  ASC,
   DIPENDENZA ASC,
   IMPORTOASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_CONTO ON OPERAZIONE
(
   CONTO_NUMERO   ASC,
   CONTO_DIPENDENZA   ASC,
   CONTO_CATEGORIAASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);
 
CREATE INDEX OPERAZIONE_IX_RIFERIMENTO ON OPERAZIONE
(
   DATA_  ASC,
   NUM_RIFERIMENTOASC
) 
LOCAL
(
  PARTITION OP_P_200103  TABLESPACE UC_OP_TSIX_200103

PCTFREE 5 PCTUSED 60
STORAGE ( INITIAL 1024M NEXT 1024M MAXEXTENTS UNLIMITED PCTINCREASE 0)
);

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

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

To REMOVE yourself from this mailing li

RE: OT -- A humorous reply to the Canada rulz

[Hand, Michael T]

Dan,

You've made one of the only mortal sins of the Internet, it's not dis'ing
the Canadians.  It's making an inaccurate Star Trek reference.  The ensign
of Russian-descent was Pavel Checkov played by . . . joined the cast in
episode # ...   entitled ...

Your penance should be long and severe.

Mike

-Original Message-
Sent: Tuesday, March 20, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * We don't marry our kin-folk. 
> 
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year 
> 
> * We ALL have frozen our tongues to something metal and lived to tell
> about it. 
> 
> *  BUT MOST IMPORTANT! 
> 
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on. 
> 
>  ooh Canada!! 
> 
>  Oh yeah... and our elections only take one day. 
> 
>  
-- 
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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

RE: OT -- Canada Rules! / Chocolate ...

[Hand, Michael T]

Kathe,
I thought every red-blooded American knew what Smarties where.  And since I
have become the newest OCP (Other Confection Professional), I will enlighten
you.  Smarties are a "penny" candy, sour in taste about the size of an M&M
vended in plastic wrap of 12-15 in a stack.  I think Crispy Crunch is
similar to our Cracker Jacks, but I'll let some of our northern neighbors
confirm that.

More importantly what was this War of 1812 I keep hearing about ;)

Mike

-Original Message-
Sent: Tuesday, March 20, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


Well, group-
I have completely enjoyed the discussion on Canada, especially since I
make my first trip
to Toronto this April.
But can someone tell me what Smarties are?  And Crispy Crunch/Coffee
Crisp?
Thanks-
Kathe


--
Kathe C. Newsome
Centenary College of Louisiana
Sr. Software Manager/Database Administrator
Email : [EMAIL PROTECTED]
Telephone : 318.869.5213
Fax : 318.869.5004
Cols. 1:9


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

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

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

Find special characters in the database

[Shakeel Qureshi]

Can someone give me a guideline as to how I
should draw a script to find special characters
in the database and replace them with blanks.

TIA

Shakeel Qureshi
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shakeel Qureshi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: SUN vs. HP

[Gene Sais]

Check the numbers again, especially the software.  Having done the same study 1.5 yrs 
ago, HP was a little more expensive in the HW but much cheaper in SW.  Reason being 
Sun uses Veritas Trusted Cluster (expensive $100k) for HA and HP uses MCServiceguard.  
I've worked 5 yrs w/ Sun and 1.5 yrs w/ HP equipment.  They were both good, but if I 
had to choose, HP gave you many more tools whereas w/ Sun you buy everything.  

My last flavor of unix to conquer is IBM AIX.  They do it differently also.  For that 
matter, so did DEC OSF/1, now Compaq Tru64 unix (hard to say compaq unix). 

Just my $.02.

Gene Sais

PS. Lets not forget OpenVMS, dam good OS!


>>> [EMAIL PROTECTED] 03/20/01 01:31PM >>>
Hi,

we are currently in the process of evaluating a high availiability cluster 
for our production database. The final two solutions are:

SunCluster 2x420R 2Gig 2x450Mhz 
Storage 100Gig

Hewlett Packard MC ServiceGuard
2xL-Class 2x440Mhz 2Gig 
Storage VA 7100 100Gig

Based on our criterias (scalability, performance, TCO, price, reliability, 
support, in house experience  ...) it looks like a dead race...

Any suggestions or thoughts would be help full 

cheers alex

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

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

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

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

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

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

RE: SUN vs. HP

[Kimberly Smith]

I have no experience with the Sun cluster but I do have
experience with the HP ServiceGuard as its what we run
here.  We have even had it fail.  We do have a Sun server
here with a database on it and although I like the server
and have no complaints I am much happier with HP.  There
are just little things that drive me crazy on the Sun side.

If you have any specific questions on the HP side though
them out.  If I don't know the answer the sys. admin. team
is in the cube beside me.

I do know that they are happy with support from both companies,
which is very important.

-Original Message-
Sent: Tuesday, March 20, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L


Hi,

we are currently in the process of evaluating a high availiability cluster 
for our production database. The final two solutions are:

SunCluster 2x420R 2Gig 2x450Mhz 
Storage 100Gig

Hewlett Packard MC ServiceGuard
2xL-Class 2x440Mhz 2Gig 
Storage VA 7100 100Gig

Based on our criterias (scalability, performance, TCO, price, reliability, 
support, in house experience  ...) it looks like a dead race...

Any suggestions or thoughts would be help full 

cheers alex

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

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

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

RE: OT -- Canada Rules! (fwd)

[Kimberly Smith]

Do you know that all most of the top ranked American/European hockey
players actually played in the CHL.  They start by getting drafted in
the major junior leagues.  So ya, you could be just as good as an
American, as long as you train in Canada.  In Canada if you are playing
hockey for your University team that is pretty much the end of your
career (unless you want to play senior).

-Original Message-
Sent: Tuesday, March 20, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L


Yeah, but we could kick your XXX!!  Not to mention that American Hockey
players are just as good if not better than Canadians!
-- 
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).

RE: OT -- Canada Rules!

[Kimberly Smith]

Smarties rule.  Much better then M&M's.  And for those
of you who think that Smarties are those sugar candies, its
not that man.  People here at work had no clues either so
I had my mom ship up a whole wack of them.

I don't like Crispy Crunch bars but the Coffee Crisp bars
are pretty good.  Personally I am a Snickers fan though
so I am not suffering in that area.  

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Well, group-
I have completely enjoyed the discussion on Canada, especially since I
make my first trip
to Toronto this April.
But can someone tell me what Smarties are?  And Crispy Crunch/Coffee
Crisp?
Thanks-
Kathe


--
Kathe C. Newsome
Centenary College of Louisiana
Sr. Software Manager/Database Administrator
Email : [EMAIL PROTECTED]
Telephone : 318.869.5213
Fax : 318.869.5004
Cols. 1:9


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

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

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

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

[Rachel Carmichael]

I thought it was that, but figured it was better to ask... you can find rock 
candy these days in the fancier candy stores masquerading as coffee stir 
sticks :)


>From: "Hand, Michael T" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Tue, 20 Mar 2001 09:30:27 -0800
>
>
>Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her
>hard candy nomenclature.  In the US its refered to as Rock candy, basically
>colored, flavored, crystaline sugar (sucrose, not glucose) available in
>various shapes and sizes though I haven't seen much of it lately. [It's
>probably gone the way of ribbon candy and other treats of yesteryear...
>(Norman Rockwell moment).] The most common US seaside confection is
>Saltwater taffy, or cotton candy.
>
>Confectionarily yours,
>Mike
>
>-Original Message-
>Sent: Tuesday, March 20, 2001 10:16 AM
>To: Multiple recipients of list ORACLE-L
>
>
>ermI don't know how this travels.
>
>Like a sugary candy which is extremely hard, you do have candy canes in the
>States for Christmas trees etc ??
>Sort of thicker, straighter version and normally minty in the UK - very
>popular at Seaside resorts where the sweet is manufactured with the name of
>the resort printed all the way through the middle. Oh God - this is 
>sounding
>more weird, the more I try and describe it.
>
>Any other Brits who have lived/worked extensively in the States care to
>offer a better translation ??
>
>Cheers
>
>Lee
>
>
>
>-Original Message-
>Sent: 20 March 2001 13:26
>To: Multiple recipients of list ORACLE-L
>
>
>rhubarb flavored rock  I'm working on a tentative assumption here that
>you don't mean actual rocks... translation please!
>
>
> >From: lerobe - Lee Robertson <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Tue, 20 Mar 2001 00:05:25 -0800
> >
> >Been drinking it in the UK for most of my 37 years !!!
> >
> >Used to be a plain old pick me up for years (if you ever had to go into
> >hospital or indeed went visiting, you were either given or giving a
> >bottle).
> >
> >Nowadays it is used by sportsmen etc for exactly what you have described.
> >
> >Regards
> >
> >Lee (one of the original Lucozade kids)
> >
> >PS. This was one of my mothers cravings when she was pregnant with me -
> >however she could only drink it whilst eating rhubarb flavoured rock -
> >WEIRD
> >!!
> >
> >-Original Message-
> >Sent: 19 March 2001 20:41
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Speaking of sugar...
> >
> >I just returned from Trinidad (on a mission trip to build a church in
> >Toco).
> >While working in the 95 degree sun all day we often walked up to the 
>corner
> >store and bought water and cokes (the coca cola was much sweeter there 
>than
> >in the US, but also less carbonated).  What we also found was a product
> >called Lucozade (http://www.lucozade.com/).  This was a sport drink
> >essentially made of glucose syrup.  From their website - "When you drink
> >it,
> >the glucose gets rapidly absorbed into your bloodstream and gives you a
> >quick burst of energy.  Glucose is the natural preferred fuel for the 
>body
> >becuase of the speed with which it can be digested and absorbed.  Once
> >absorbed it is a readily available source of fuel, whic all cells of the
> >body can utilise."
> >
> >Official drink of on-call DBAs.
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C.
> > > Applewhite
> > > Sent: Monday, March 19, 2001 11:16 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> > >
> > >
> > > Kimberley,
> > >
> > > I'd be surprised if you can get "real" raw sugar in stores.
> > >
> > > When I was in the U.S. Peace Corps in Belize in the mid
> > > '70s, raw sugar was readily available, since sugar was a
> > > primary export from that beautiful little country.  If you
> > > let a couple of pounds of raw sugar sit in a brown paper bag
> > > for a day or two, the molasses would settle to the bottom
> > > and puddle - a jar, shaken occasionally, was a better
> > > storage option.
> > >
> > > It was delicious!  There's nothing quite like a peanut
> > > butter and raw sugar sandwich!  Ironically, the Belizians
> > > preferred refined, white sugar, since it was considered more
> > > "upscale" than the raw sugar.
> > >
> > > BTW, other advantages to living in a sugar-exporting country
> > > included very cheap soft drinks and rum!...Oh, and Reggae!
> > > ;-)
> > >
> > > Jack
> > >
> > > 
> > > Jack C. Applewhite
> > > Database Administrator/Developer
> > > OCP Oracle8 DBA
> > > iNetProfit, Inc.
> > > Austin, Texas
> > > www.iNetProf

RE: RE: RE: OT: Rachel in Vietnam

[Rachel Carmichael]

I'm old but not THAT old :)  would not have been draftable even at the end 
of the war (even if I were male!)


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: RE: OT: Rachel in Vietnam
>Date: Tue, 20 Mar 2001 08:02:26 -0800
>
>Dick ,
>
>Didn't you know? Rachel WAS in Nam. But she
>never talks about it. I think it had to do
>with the bugs.
>
>Just a thought.
>
>Ross
>
>-Original Message-
>Sent: Tuesday, March 20, 2001 8:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Rachel,
>
> If you were given one, as I was in Nam, you'd not know the difference.
>Looks like, & tastes like a crunch bar for the most part, except for the
>logo on
>top.  It just crunches better.
>
>Dick Goulet
>
>Reply Separator
>Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
>Date:   3/19/2001 4:10 PM
>
>but Moom, the icky bugs TOUCHED the chocolate!   :)
>
>
>
> >From: Kimberly Smith <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 13:45:29 -0800
> >
> >You could just lick the chocolate off.
> >
> >-Original Message-
> >Sent: Monday, March 19, 2001 10:11 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> > I have a phobia about bugs...
> >
> >what a waste of perfectly good chocolate
> >
> >
> > >From: [EMAIL PROTECTED]
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> > >Date: Mon, 19 Mar 2001 09:11:20 -0800
> > >
> > >OK you chocaholics try this on for size:
> > >
> > >  Reuters Monday, March 19, 2001
> > >
> > >Chocolate-Coated Bugs Are Latest Treat
> > >
> > >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> > >in chocolate and promoted as a high-protein snack, are proving
> > >popular among peckish Londoners.
> > >
> > >Designer Todd Dalton, who trained as a chef in Louisiana and
> > >acquired a taste for cooked insects on his travels in Asia and
> > >central America, says he has sold 5,000 chocolate-coated bugs
> > >since he began marketing them in December.
> > >
> > >"They are very high in protein and very low in fat. They have a
> > >higher percentage of protein than any meat or fish that we
> > >commonly eat," he told Reuters.
> > >
> > >The creepy-crawly chocs sell for between three and 3.50 pounds
> > >($4.30-$5.00) at upmarket London stores such as Selfridges and
> > >the Conran Shop and will soon be appearingin shops in Munich
> > >and Zurich.
> > >--
> > >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).
> >
> >_
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: 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 subscrib

RE: 32bit vs 64bit (was: Just like Christmas)

[Kimberly Smith]

We are going 64-bit for HP but keeping Oracle at 32-bit.  We really
had no choice for the HP side.  We just need the memory that 32 bit
could not support.  We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking).  But we are
getting rid of all our K-class servers.  The model we are running have
been nothing but trouble.  We hate to turn one off because it seems
like every time we reboot hardware dies.  Other fabs have been having
the same issue.  So we are going N-class for the database cluster
and A-class for the remaining.  Since your K-class servers are new they
probably don't have the same hardware issues we have.  HP even owned up
to having issues.

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.




This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- A humorous reply to the Canada rulz

[Kevin Kostyszyn]

Wow that was good!!  You know, I don't really like baseball, but I am pretty
sure that when you drive into Hoboken it says on a sign "Home of Baseball
and Frank Sinatra". hmm   Canada invented hockey, but they also invented
curling didn't they.  Yeah, isn't that like the Canadian version of shuffle
board?

-Original Message-
Sent: Tuesday, March 20, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of?
>
> * Smarties
>
> * Crispy Crunch & Coffee Crisp
>
> * The size of our footballs fields and one less Down
>
> * Baseball is Canadian
>
> * Lacrosse is Canadian
>
> * Hockey is Canadian
>
> * Basketball is Canadian
>
> * Apple pie is Canadian
>
> * Mr. Dress-up kicks Mr. Rogers ass
>
> * Tim Hortons kicks Dunkin' Donuts ass
>
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure...
>
> * Canada has the largest French population that never surrendered to
> Germany.
>
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere.
>
> * Our civil war was a bar fight that lasted a little over an hour.
>
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught.
>
> * We knew plaid was cool far before Seattle caught on.
>
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company
>
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes.
>
> * We still know what to do with all the parts of a buffalo.
>
> * We don't marry our kin-folk.
>
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year
>
> * We ALL have frozen our tongues to something metal and lived to tell
> about it.
>
> *  BUT MOST IMPORTANT!
>
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on.
>
>  ooh Canada!!
>
>  Oh yeah... and our elections only take one day.
>
>
--
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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing lis

OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

[Kimberly Smith]

First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball.  Go look it up.  
However, he was in the States when he invented it.  

Once we get rid of Quebec we will have no issues as to what language
we are.  We are bilingual.  Except for Quebec we are accepting of that.
Another Canadian trait.  

As for bikini's, it can actually get quite warm in Canada.  I have seen
many a bikini.  Personally I don't wear one but I would not be cold if
I did wear one in the summer.  Did you know that there are parts of Canada
that are further south then the USA.  I actually went up quite a few 
degrees when I moved from Halifax, NS to Portland, OR.  Check it out.

And as for us being culturally like the US, don't see it man.  We are
not nearly as paranoid (generalizing here on in) as Americans.  We pay
so much more taxes, and we do complain, but the people here bring it to
a whole new level.  I hear that we are friendlier but I am not so sure
of that one.  Maybe initially it seems like that because we are not 
so paranoid and trust right away.  Lets see, how many school shooting did
we have last year.  I know of one but there might have been more.  Never
been to a school with a metal detector but I do know of one high school that
is bigger then a lot of Universities that does have a cop on site.  We are
much more accepting of technology.  Got that one out of the news many times,
plus it amazes me some of the things you guys just don't do in the States
that we have been doing for years.  Our banks carry foreign currency and are
much easier to deal with.  Almost like they like customers.  That
has been a big problem for me here in Portland. 

I could go on but I am sure I pissed many Americans off already.  Don't
get me wrong, I like the States and am enjoying my time here but we are not
Americans!  Nor do we want to be.  I just want the money:-)

-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * We don't marry our kin-folk. 
> 
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> c

Re: Insert without telling column names

[William Beilstein]

You are misinformed. If you have a table of the form

col1varchar2(1)
col2   number
col3   date

You can insert into it with the insert statement
INSERT INTO MYTABLE VALUES('X',23,SYSDATE);

As long as ALL the columns are included in the values clause in the order they were 
created in the table, you don't have to define the column names.


>>> [EMAIL PROTECTED] 03/20/01 11:36AM >>>
Roland,

You can't.  There are a number of ways to really cut down on the code
required to do an insert, but if you think about it, how will Oracle
know where the data is supposed to go if you don't give it the column
name(at some point)?

If you're using 8i, there is a direct load insert, but as far as I'm
aware, this will work only for a select * from another table.

Dynamic SQL works pretty well for this kind of stuff.  What are you
trying to do?

Regards,

David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth

[EMAIL PROTECTED] wrote:
> 
> Hallo,
> 
> How can I create an insert statement without telling all the names of the columns?
> Give an example, please.
> 
> Roland Sköldblom
> 
> --
> 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: David A. Barbour
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: William Beilstein
  INET: [EMAIL PROTECTED]

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

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

OFF TOPIC: RE: Lemon Juice in Ants Pooh-Poohed

[Glenn Travis]

I think what you are referring to is the camel [back] cricket, which is also
known as the cave cricket.

Look here --> http://entweb.clemson.edu/cuentres/cesheets/hhold/ce190.htm
and http://www.ent.iastate.edu/ipm/iiin/ccamelcr.html

We had alot of them in our basement - and boy, can they jump!

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Toepke,
> Kevin M
> Sent: Tuesday, March 20, 2001 9:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Lemon Juice in Ants Pooh-Poohed
>
>
> Kevin, Kevin, Kevin...
>
> Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're
> not even crickets! They're related to the grasshopper) Are the antenea as
> long as the rest of the body? And even if they are Cave Crickets,
> they won't
> bother you. They just come out of the cave to feed.
>
> Kevin Toepke
> Caver and Semi-professional, Semi-competent DBA-type guy
> P: 614/652-5117
> F: 614/652-5401
> -
> The information in this electronic mail message is Cendant Confidential
> and may be legally privileged. It is intended solely for the
> addressee(s). Access to this Internet electronic mail message by anyone
> else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or action taken or omitted to be taken
> in reliance on it is prohibited and may be unlawful.
> -
> The sender believes that this E-mail and any attachments were free of
> any virus, worm, Trojan horse, and/or malicious code when sent. This
> message and its attachments could have been infected during
> transmission. By reading the message and opening any attachments, the
> recipient accepts full responsibility for taking protective and remedial
> action about viruses and other defects. Cendant Corporation is not
> liable for any loss or damage arising in any way from this message or
> its attachments.
> -
>
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 8:26 AM
> To: Multiple recipients of list ORACLE-L
>
>
> It doesn't matter if they give off a sweet lemony aroma, I am thinking I
> don't want to eat ants!!  The only time I would eat ants is if I was
> stranded somewhere and had no food.  See, I really don't like
> insects, they
> bother me, not all of them.  A lot of ants sickens me, I am terrified of
> spiders BIG TIME!!   Also, here in Jersey, we have these bugs, they are
> called cave crickets I believe.  Oh man do they freak me out,
> they look like
> a mix of a big spider and a cricket!!  They jump about 3 feet in
> the air and
> are by far one of the ugliest things I have ever seen.  I won't
> go in a room
> if I know one is in there, I know they can't hurt me, but it's just a
> phobia.  Sorry for getting so far off of the topic!
> Kev
>
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Toepke, Kevin 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: Glenn Travis
  INET: [EMAIL PROTECTED]

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

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

Function in a view problem

[Jamadagni, Rajendra]

Hi all,

One of our developer is testing a function as shown below and this function
is used in a view. Just to see how many times the function is called, we
have a dbms_output statement in the function body. I was surprised to find
that the function gets called 3 times for each row. 

Maybe the glaring truth is right in front of me, but I don't see it. For all
that matters, "episode_airings" is a large table.

Please help .. why the function is being called 3 times? I also traced it
with dbms_pipe, all the input parameters are same for all the threee calls.


CREATE OR REPLACE PACKAGE DBPK_raj_TEST1 IS
function getnumber(nemp in number, nNumberIN number) return number;
PRAGMA RESTRICT_REFERENCES (GetNumber,WNDS);
END DBPK_raj_TEST1;
/

CREATE OR REPLACE PACKAGE BODY DBPK_raj_TEST1 IS
function getnumber(nemp in number, nNumber In Number) return number is
x number;
BEGIN
  dbms_output.put_line ('In Procedure' || to_char(nNumber));
  sendtracemessage('VIEW: ' || to_char(nemp) || ' - ' || to_char(nnumber) ||
' - ' || to_char(nnumber+1));
  Return (nNumber + 1);
END getnumber;
--
END DBPK_raj_test1;
/



create or replace view raj_test (dept_no, rn, pkg_rtn) as
select ep_number Dept_no, rownum rn, dbpk_raj_test1.getnumber(ep_number,
rownum) pkg_rtn
from episode_airings where rownum < 10



Declare
cursor c is select dept_no, rn, pkg_rtn from raj_test;
n1 number := 0;
n2 number := 0;
n3 number := 0;
begin
dbms_output.enable(10);
dbms_output.put_line ('$$$');
dbms_output.put_line ('$ For Loop Cursor $');
dbms_output.put_line ('$$$');
for r in c loop
n1 := c%rowcount;
dbms_output.put_line ('$ Loop Counter ' || to_char(n1));
dbms_output.put_line ('$ value ' || to_char(r.dept_no) || ' - ' ||
  to_char(r.rn) || ' - ' ||  to_char(r.pkg_rtn));
end loop;
/



SELECT STATEMENT Optimizer=RULE
  VIEW OF RAJ_TEST
COUNT (STOPKEY)
  TABLE ACCESS (FULL) OF EPISODE_AIRINGS



SQL> @raj
$$$
$ For Loop Cursor $
$$$
In Procedure1
In Procedure1
In Procedure1
$ Loop Counter 1
$ value 32635 - 1 - 2
In Procedure2
In Procedure2
In Procedure2
$ Loop Counter 2
$ value 32636 - 2 - 3
In Procedure3
In Procedure3
In Procedure3
$ Loop Counter 3
$ value 32637 - 3 - 4
In Procedure4
In Procedure4
In Procedure4
$ Loop Counter 4
$ value 32638 - 4 - 5
In Procedure5
In Procedure5
In Procedure5
$ Loop Counter 5
$ value 32639 - 5 - 6
In Procedure6
In Procedure6
In Procedure6
$ Loop Counter 6
$ value 32640 - 6 - 7
In Procedure7
In Procedure7
In Procedure7
$ Loop Counter 7
$ value 32641 - 7 - 8
In Procedure8
In Procedure8
In Procedure8
$ Loop Counter 8
$ value 32642 - 8 - 9
In Procedure9
In Procedure9
In Procedure9
$ Loop Counter 9
$ value 32643 - 9 - 10


Connected to: 
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

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

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



*

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

*

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Free Oracle DBA tests on the web

[Ron Rogers]

Andrey '
Electronic books can be found at:
RUSSIAN FREE BOOKS HTML FORMAT_+++

 http://docs.rinet.ru/ 
 ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/20/01 12:36PM >>>
Hi DBAs !
I'm looking for some FREE Oracle DBA / developer resources on the web :
self-tests , OCP preparations materials , articles , books , etc ...
Please share your resources !
Thanks a lot in advance .
Andrey .

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

Re: redo log timing

[Rodd Holman]

Ian,
This is one of those where you can get the old "it depends" answer.
What type of database is this?  What level of transaction activity do you 
have?  How big are your redo logs if you switch every 15 min, 20 min, 30 min? 
How critical is recovery to the current time to you?

If you don't want the overhead of lots of log switches and you can stand to 
have a possible loss of 30 minutes of data on a recovery then 2/hr would 
work. (Possiblity of data loss based on losing all logs and mirror logs in a 
recovery scenario).

Others may have differing opinions on this, but I normally keep mine running 
in the 15-20 minute range.  The overhead difference between 2 switches/hour 
and 3 or 4 per/hour is generally not noticeable.  It makes for smaller 
archives which makes the gzip of the log run faster and take up less cpu 
time.  (I run a cron job that compresses the archived logs to save disk 
space).

On Tuesday 20 March 2001 11:36, you wrote:
>
> Now for an Oracle question.  It is often touted that redo logs should
> switch every 15 minutes to 30 minutes.  Are these the lower and upper
> limits, should the average time to switch logs be within that range, or
> should the median be between that range?
>
> Ian MacGregor
> Stanford Linear Accelerator
> [EMAIL PROTECTED]
>
>

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- Canada Rules! (fwd)

[Kevin Kostyszyn]

Yeah, but we could kick your XXX!!  Not to mention that American Hockey
players are just as good if not better than Canadians!

-Original Message-
Patrice J
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of?
>
> * Smarties
>
> * Crispy Crunch & Coffee Crisp
>
> * The size of our footballs fields and one less Down
>
> * Baseball is Canadian
>
> * Lacrosse is Canadian
>
> * Hockey is Canadian
>
> * Basketball is Canadian
>
> * Apple pie is Canadian
>
> * Mr. Dress-up kicks Mr. Rogers ass
>
> * Tim Hortons kicks Dunkin' Donuts ass
>
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure...
>
> * Canada has the largest French population that never surrendered to
> Germany.
>
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere.
>
> * Our civil war was a bar fight that lasted a little over an hour.
>
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught.
>
> * We knew plaid was cool far before Seattle caught on.
>
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company
>
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes.
>
> * We still know what to do with all the parts of a buffalo.
>
> * We don't marry our kin-folk.
>
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year
>
> * We ALL have frozen our tongues to something metal and lived to tell
> about it.
>
> *  BUT MOST IMPORTANT!
>
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on.
>
>  ooh Canada!!
>
>  Oh yeah... and our elections only take one day.
>
>
--
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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

SUN vs. HP

[Alex Apostolopoulos]

Hi,

we are currently in the process of evaluating a high availiability cluster 
for our production database. The final two solutions are:

SunCluster 2x420R 2Gig 2x450Mhz 
Storage 100Gig

Hewlett Packard MC ServiceGuard
2xL-Class 2x440Mhz 2Gig 
Storage VA 7100 100Gig

Based on our criterias (scalability, performance, TCO, price, reliability, 
support, in house experience  ...) it looks like a dead race...

Any suggestions or thoughts would be help full 

cheers alex

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

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

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

RE: OT -- A humorous reply to the Canada rulz

[Dasko, Dan]

U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything?  I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither.  Penicillin and the
telephone??  Other delusions of grandeur?  How about the only country that
can't decide if they're English or French?  How about the US's biggest
colony via cultural conquest(ohh, that's a low blow).  How about never
saw a bikini except in National Geographic?  I could go on, but I'm not sure
my humor translates all that well, and the firewall has Babelfish blocked.

Dan "not about to give up my day job"

-Original Message-
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L


Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * We don't marry our kin-folk. 
> 
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year 
> 
> * We ALL have frozen our tongues to something metal and lived to tell
> about it. 
> 
> *  BUT MOST IMPORTANT! 
> 
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on. 
> 
>  ooh Canada!! 
> 
>  Oh yeah... and our elections only take one day. 
> 
>  
-- 
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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

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

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

OT -- Canada Rules!

[Kathe Newsome]

Well, group-
I have completely enjoyed the discussion on Canada, especially since I
make my first trip
to Toronto this April.
But can someone tell me what Smarties are?  And Crispy Crunch/Coffee
Crisp?
Thanks-
Kathe


--
Kathe C. Newsome
Centenary College of Louisiana
Sr. Software Manager/Database Administrator
Email : [EMAIL PROTECTED]
Telephone : 318.869.5213
Fax : 318.869.5004
Cols. 1:9


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

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

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

RE: How long will 8.0.6 be supported?

[Adams, Matthew (GEA, 088130)]

Title: RE: How long will 8.0.6 be supported?





According to a spreadsheet I've got 
normal support ends 30-Sep-2001


Extended Assistance Support ends
30-Sep-2004



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)



> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How long will 8.0.6 be supported?
> 
> 
> I can't get into Metalink.  Can anyone tell me how long 8.0.6 will be
> supported?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> -- 
> 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).
> 

32bit vs 64bit (was: Just like Christmas)

[Jesse, Rich]

Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.




This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Free Oracle DBA tests on the web

[andrey]

Hi 
Gurus !
Just 
wanted to clarify that i'm interested in ANY FREE Oracle DBA related 
resources on the web , not only OCP stuff .
Thanks 
a lot for your attention !
Andrey 
.
 

  -Original Message-From: andrey 
  [mailto:[EMAIL PROTECTED]]Sent: Tue, March 20, 2001 7:49 
  PMTo: oralist@lists; [EMAIL PROTECTED]; 
  [EMAIL PROTECTED]Subject: Free Oracle DBA tests on the web 
  
  Hi DBAs 
  !
  I'm looking for 
  some FREE Oracle DBA / developer resources on the web :
  self-tests , OCP 
  preparations materials , articles , books , etc ...
  Please share your 
  resources !
  Thanks a lot in 
  advance .
  Andrey 
  

Re: Insert without telling column names

[Regina Harter]

At 08:36 AM 3/20/01 -0800, you wrote:
>Roland,
>
>You can't.  There are a number of ways to really cut down on the code
>required to do an insert, but if you think about it, how will Oracle
>know where the data is supposed to go if you don't give it the column
>name(at some point)?

Of course you can.  The only caveat is Oracle will assume you are filling 
all the columns in order, therefore you must provide a value for every 
column, ie
For Table T1(firstname, lastname, telephone, fax, email)

insert into T1 values('John','Smith','4849910','','[EMAIL PROTECTED]')

Note the '' in place of a fax number.  I could also have used null.

I never use this method in applications or procedures, of course, because 
then if you change the table definition it no longer works, but for testing 
stuff, or something I'm only going to run once it's a decent shortcut.

>If you're using 8i, there is a direct load insert, but as far as I'm
>aware, this will work only for a select * from another table.
>
>Dynamic SQL works pretty well for this kind of stuff.  What are you
>trying to do?
>
>Regards,
>
>David A. Barbour
>Oracle DBA
>Formerly with the now defunct and bankrupt ConnectSouth
>
>[EMAIL PROTECTED] wrote:
> >
> > Hallo,
> >
> > How can I create an insert statement without telling all the names of 
> the columns?
> > Give an example, please.
> >
> > Roland Sköldblom
> >
> > --

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Free Oracle DBA tests on the web

[Ron Rogers]

Andrey,
 Here is a partial list that I have.
I give credit for these site and their content to the original authors. This is a 
partial list I have gleaned from this list.
ROR mª¿ªm

http://www.stewartmc.com/oracle 
 http://www.stewartmc.com/oracle/tips.html 
www.oraes.com/scr/expfull.sh 
http://www.lazydba.com
http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/ 
http://www.oreilly.com/catalog/orinternals/ 
www.perl.com

http://www.hot-oracle.com/ 
http://www.pitchmark.freeserve.co.uk/cert.htm 
http://www.brainbench.com/ 
http://www.oraclenotes.com/ 
http://www.selftestsoftware.com 
http://www.geocities.com/SiliconValley/Heights/1397/index.htm Chris
Dempster's site (includes OCP  guides)
http://www.geocities.com/kgkrish K Gopalakrishnan's site (Details of new 8i
OCP)
http://cramsession.brainbuzz.com/ 

http://technet.oracle.com 
http://www.orafaq.org 
http://www.lazydba.com 
http://www.oracle-dba.com 
http://www.revealnet.com/generator.htm 
http://ourworld.compuserve.com/homepages/Peter_Koletzke 
http://www.orafans.com 
http://www.oreview.com/ 
http://www.solvit.net/dbscripts 
http://www.ipass.net/~davesisk/oont.htm 
http://www.oracle-users.com 
http://www.oracleguru.com 
http://www.dbdomain.com 
http://www.oracletool.com/ 
http://www.stewartmc.com/oracle/ 
http://www.teleport.com/~jkstill/util/ 
http://www.ozemail.com.au/~gpiper/index.html 
http://homepage.interaccess.com/~akaplan/oracle.html 
http://www.AppsDBA.com 
http://www.orapub.com 
http://www.oramag.com/ 
http://www.uaex.edu/srea/ 
http://www.onwe.co.za/frank/faqmain.htm 
http://www.geocities.com/SiliconValley/Peaks/4535/oracle/ 
www.mindspring.com/~hayden 
http://www.jlcomp.demon.co.uk/index.html (scroll down)
http://www.webdiego.com/osr 
http://www.appsdba.com (oracle application orientated)
http://www.tusc.com 
tuning tips--
U may find these white papers useful:

"Oracle Performance and Tuning: Overview"
http://pillango.sirma.bg/oracle/N014_p%26t_overview.pdf 

"Performance Tuning - Now You are the V8 Expert"
http://pillango.sirma.bg/oracle/N023_tun_all.doc 

"Identifying Resource Intensive SQL in a production environment" -
http://pillango.sirma.bg/oracle/N026_tuning2.pdf 

"Database Tuning Methodology" -
http://pillango.sirma.bg/oracle/N027_DB_Tune.doc 

"SQL Tuning for the Oracle DBA" -
http://pillango.sirma.bg/oracle/N050_tuning.pdf 

"Practical Tuning Advice for the Oracle8 DBA" -
http://pillango.sirma.bg/oracle/N064_tuning.pdf 

"Finding the Performance Bottlenecks in Your Application" -
http://pillango.sirma.bg/oracle/N067_performance.pdf 

"Inside the Oracle Cost Based Optimizer" -
http://pillango.sirma.bg/oracle/N080_optimizer.doc 

"Seven Deadly SQL Traps and How to Avoid Them" -
http://pillango.sirma.bg/oracle/N082_tuning.doc 

"Secrets of SQL and Application Tuning" -
http://pillango.sirma.bg/oracle/N108_tuning.doc 

You can get the same kind of info on indexes. For sample code see the
following:
 http://www.oracle.com/oramag/code/cod04139.html 

http://www.solvit.net/dbscripts/resize_db.html 
http://www.dbasupport.com/scripts/Administration/Session_Management/ 

HOT BACKUP INFO
http://www.wolfenet.com/~jeremiah/hot-backup.html 

24X7 oracle
http://www.wolfenet.com/~jeremiah/oracle.html 

"Oracle DBA Checklist"
http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf 
"DBA101: A Refresher Course" 
http://pillango.sirma.bg/oracle/N092_dba.doc 
http://harbinger.sirma.bg/Oracle 
Here's a newer (v1.3) version of the same document.

http://www.geocities.com/tbcox23/dba_checklist13.doc 
http://technet.oracle.com/software/products/oem/software_index.htm 

http://technet.oracle.com/cgi-bin/go?oem21-full 

Account administration guidelines. The table of contents:

http://www.oreilly.com/catalog/orasec/toc.html 

and here is a sample chapter, "Developing a Database Security Plan":

http://www.oreilly.com/catalog/orasec/chapter/ch07.html 

FREE SPACE SCRIPT
Take a look at OraSnap : http://www.stewartmc.com/oracle/orasnap/ 
RAID INFO
 http://sw.expert.com

REPORT.TXT info
Try send a few sample report files to http://www.oraperf.com/.

CRAMMSESSION ORACLE 8i UPGRADE
http://cramsession.brainbuzz.com/cramsession/oracle/Oracle8iupgrade

EXCEL to ORACLE
 http://www.oraxcel.com 

STATUS REPORT TIPS
www.arikaplan.com
REDO LOG INFO
For info on the log block size, please see
http://www.ixora.com.au/tips/creation/raw_log_files.htm.
For the answer on redo wastage please see
http://www.ixora.com.au/q+a/1999_09.htm and scroll down to the entry
from 25 September 1999.

>>> [EMAIL PROTECTED] 03/20/01 12:36PM >>>
Hi DBAs !
I'm looking for some FREE Oracle DBA / developer resources on the web :
self-tests , OCP preparations materials , articles , books , etc ...
Please share your resources !
Thanks a lot in advance .
Andrey .
--
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, Califo

RE: Lemon Juice in Ants Pooh-Poohed

[Kimberly Smith]

Actually, he was very valid in his request.  He did not ask that 
you completely stop but rather add the OFF-TOPIC into the subject
so it can be ruled out.  It has been a rather long discussion with
lots of e-mails (not that I am complaining, just seeing his point).


-Original Message-
Sent: Tuesday, March 20, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Paul, you are in deep trouble :-). Somebody will sure "remind" you in that
you have delete button etc. 

Alex Hillman

-Original Message-
From:   Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 20, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Lemon Juice in Ants Pooh-Poohed


Can't the list members PUH-LEEZE stick (mostly) to messages germane
to the
purpose of this list?  I don't mind the occasional off-topic post,
but, for
crying out loud, how about a little restraint?  The original recipe
posting(s) have given rise to a plethora of  messages about
chocolate,
sugar, ants, travel, etc. etc.

I open list messages as they arrive and I don't appreciate the
cumulative
waste of my time in reading all of this nonsense.  

If you all MUST ventilate at length about eating chocolate-covered
ants,
let's adopt a convention of including "OFF-TOPIC" in the message
header, at
least, so it's possible to filter them out.

And no, I am not a grouch, curmudgeon, in need of lightening up,
etc.
Sometimes enough is enough, already.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717  (mobile)

-- 
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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

Re: How long will 8.0.6 be supported?

[Bill Gentry]

09/30/2001 unless you have Extended Support, then it's 09/30/2004
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 10:36 AM


> I can't get into Metalink.  Can anyone tell me how long 8.0.6 will be
> supported?
> 
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> 
> -- 
> 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: Bill Gentry
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Lemon Juice in Ants Pooh-Poohed

[Hillman, Alex]

It was sarcastic.

Alex Hillman

-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Lemon Juice in Ants Pooh-Poohed

Actually, he was very valid in his request.  He did not ask that 
you completely stop but rather add the OFF-TOPIC into the subject
so it can be ruled out.  It has been a rather long discussion with
lots of e-mails (not that I am complaining, just seeing his point).


-Original Message-
Sent: Tuesday, March 20, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Paul, you are in deep trouble :-). Somebody will sure "remind" you
in that
you have delete button etc. 

Alex Hillman

-Original Message-
From:   Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 20, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Lemon Juice in Ants Pooh-Poohed


Can't the list members PUH-LEEZE stick (mostly) to messages
germane
to the
purpose of this list?  I don't mind the occasional off-topic
post,
but, for
crying out loud, how about a little restraint?  The original
recipe
posting(s) have given rise to a plethora of  messages about
chocolate,
sugar, ants, travel, etc. etc.

I open list messages as they arrive and I don't appreciate
the
cumulative
waste of my time in reading all of this nonsense.  

If you all MUST ventilate at length about eating
chocolate-covered
ants,
let's adopt a convention of including "OFF-TOPIC" in the
message
header, at
least, so it's possible to filter them out.

And no, I am not a grouch, curmudgeon, in need of lightening
up,
etc.
Sometimes enough is enough, already.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717  (mobile)

-- 
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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

Re: FK Constraints

[Rachel Carmichael]

I don't get new user requests.. I get requests from end-users for data.

But I understand. And I know that it's a question of coming in with the 
baseball bat and assorted heavy weaponry and making a stand (or as my CTO is 
fond of saying "putting a stake in the ground")

Just haven't collected all the cudgels yet :)


>From: Rodd Holman <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: FK Constraints
>Date: Tue, 20 Mar 2001 07:35:32 -0800
>
>Rachel,
>One way I got this across to my developers and users was in creating new
>users for the DB.  Every time I got a new user request, I would forward it 
>to
>the director of the group that officially "owns" the data to get his
>permission to allow them in HIS data.  After a few round robins of this the
>people finally realized that when I said Ops, Acctg, etc. owned the data, I
>also made them responsible for THEIR  data.  We still have fun every now 
>and
>then with "Can you recover this for me" type reqests, but most of the time
>they recognize that I keep the system going and they keep the data correct.
>
>On Monday 19 March 2001 18:10, you wrote:
> > the DBA is not responsible for the data?? Could you PLEASE come to my
> > office and explain that (I'll bring the heavy club) to my developers, 
>users
> > and management?
> >
>
>
>--
>Rodd Holman
>Oracle DBA
>(605) 988-1373
>[EMAIL PROTECTED]
>Comments made are my own opinions and views. They do not represent views,
>policies, or procedures of LodgeNet Entertainment Corporation
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rodd Holman
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

RE: NLS_DATE_FORMAT not effective..help!

[VIVEK_SHARMA]

Arul

In init.ora have you specified MM/DD/ WITHOUT Quotes , as follows simply
:-

NLS_DATE_FORMAT=MM/DD/


> -Original Message-
> From: Martin Kendall [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 6:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: NLS_DATE_FORMAT not effective..help!
> 
> Just create a Database on-logon trigger and setup the date as you want it.
> Then providing any "client" does not do an alter session you will have a 
> standard DB date format.
> 
> -Original Message-
> Sent: 20 March 2001 08:36
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Gurus,
> 
> We want to change the default date format of oracle from
> 'dd-mon-yy'  to 'MM/DD/' format for one of our database ( 8.1.6 ).
> 
> I have set NLS_DATE_FORMAT as "MM/DD/" (also tried  for year!)
> in init file.  It doesn't seems to have any effect when i query sysdate
> (SQL PLUS)  from a client PC (Win 95 / Oracle 8 client / SQL PLUS) .
> Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default
> format - dd-mon-yy)
> 
> Ofcourse, after modifying, i bounced the db and listener.
> 
> Interesting thing is when i query sysdate from SQLPLUS of my server
> (where Oracle is installed ), it is giving me the date as
> 
> SELECT SYSDATE FROM DUAL;
> 
> 03/20/200  ( it should be 03/20/2001 )
> 
> What went wrong? Did anyone faced similar problem?
> Do i need to modify registry in client PCs ( Win 9X)...??
> 
> Thank You.
> Arul.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Lemon Juice in Ants Pooh-Poohed

[Kevin Kostyszyn]

Everything about them is long except their body's.  Oh Man!!  If you
like'em, come on down to my house this spring and you take all of them out
of the pool change room!!  They sit in there, on the cieling, on the floor
on the walls!!  I can't deal, I know they can't hurt me, but they are just
so nasty lookin!!

-Original Message-
Kevin M
Sent: Tuesday, March 20, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


Kevin, Kevin, Kevin...

Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're
not even crickets! They're related to the grasshopper) Are the antenea as
long as the rest of the body? And even if they are Cave Crickets, they won't
bother you. They just come out of the cave to feed.

Kevin Toepke
Caver and Semi-professional, Semi-competent DBA-type guy
P: 614/652-5117
F: 614/652-5401
-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-


-Original Message-
Sent: Tuesday, March 20, 2001 8:26 AM
To: Multiple recipients of list ORACLE-L


It doesn't matter if they give off a sweet lemony aroma, I am thinking I
don't want to eat ants!!  The only time I would eat ants is if I was
stranded somewhere and had no food.  See, I really don't like insects, they
bother me, not all of them.  A lot of ants sickens me, I am terrified of
spiders BIG TIME!!   Also, here in Jersey, we have these bugs, they are
called cave crickets I believe.  Oh man do they freak me out, they look like
a mix of a big spider and a cricket!!  They jump about 3 feet in the air and
are by far one of the ugliest things I have ever seen.  I won't go in a room
if I know one is in there, I know they can't hurt me, but it's just a
phobia.  Sorry for getting so far off of the topic!
Kev


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin 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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

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

RE: DBMS_OUTPUT.PUT_LINE

[Diana Duncan]

Yup.  Like I said, you'd never want to do this in real life.  I was just
illustrating the idea.

-Original Message-
Sent: Tuesday, March 20, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L


Won't that continuously print:

Inserted 1 rows.
Inserted 1 rows.
...

(well, as long as you don't get a primary/foreign key exception)  :)

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX


-Original Message-
Sent: Tuesday, March 20, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L


Roland,

The only trick with dbms_output.put_line is to set your serveroutput on.
The following is a sample script to be run in SQL*Plus.  Warning: it's a
stupid script, you'd never want to do this in real life. :)

set serverout on
declare
cursor some_cursor is
select *
from some_table;
begin
for curRec in some_cursor loop
insert into another_table (col1, col2)
values (curRec.col1, curRec.col2);
dbms_output.put_line('Inserted ' || SQL%rowcount || '
rows.');
end loop;
end;
/

Diana

-Original Message-
Sent: Tuesday, March 20, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L


Hello,

Anyone who has a suggestion how to  write the DBMS_OUTPUT.PUT_LINE command
if I  want to display the numbers of inserts done in that script?
Would appreciate it  very much if anyone could help..


Roland Sköldblom

-- 
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: Diana Duncan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Jeffery Stevenson
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Diana Duncan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Insert without telling column names

[Diana Duncan]

Roland,

Check out the SQL manual, the syntax diagram clearly illustrates that you
don't need to explicitly name the column names as long as you are inserting
into all of the columns in the order they are defined in the data
dictionary.

insert into table_A values ('Hi', 'there');

A word of friendly caution -- the list will rapidly recognize you by name
and fail to answer questions when it is obvious that you haven't taken the
time to 1) try it yourself and 2) read the docs.  Also, you need to give
more information in your queries.  We realize that Oracle is a big, bad
world and there is a lot to know, but most of us don't have the time to
answer every question every newbie has.  I, of course, am an exception at
the moment since I am just killing time this week waiting to be laid off...

Regards,

Diana

-Original Message-
Sent: Tuesday, March 20, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L


Hallo,

How can I create an insert statement without telling all the names of the
columns?
Give an example, please.

Roland Sköldblom



-- 
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: Diana Duncan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Lemon Juice in Ants Pooh-Poohed/Redo Log Switching

[MacGregor, Ian A.]

While I've stayed away from the discussions about offended dieties and the like where 
people espouse their philosophies of life, I could not let an assertion which was 
clearly mistaken stand.  In fairness to Mr. Steven, ants will have some citric acid in 
their bodies; it is an intermediate step in the oxidation of glucose.

Now for an Oracle question.  It is often touted that redo logs should switch every 15 
minutes to 30 minutes.  Are these
the lower and upper limits, should the average time to switch logs be within that 
range, or should the median be between
that range?

Ian MacGregor
Stanford Linear Accelerator
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, March 20, 2001 6:31 AM
To: Multiple recipients of list ORACLE-L



Can't the list members PUH-LEEZE stick (mostly) to messages germane to the
purpose of this list?  I don't mind the occasional off-topic post, but, for
crying out loud, how about a little restraint?  The original recipe
posting(s) have given rise to a plethora of  messages about chocolate,
sugar, ants, travel, etc. etc.

I open list messages as they arrive and I don't appreciate the cumulative
waste of my time in reading all of this nonsense.  

If you all MUST ventilate at length about eating chocolate-covered ants,
let's adopt a convention of including "OFF-TOPIC" in the message header, at
least, so it's possible to filter them out.

And no, I am not a grouch, curmudgeon, in need of lightening up, etc.
Sometimes enough is enough, already.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717  (mobile)

-- 
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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

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

AUDITING - DEFAULT FOR CONNECT INTERNAL

[Raj Sakthi]

Hi Folks ,
When I was tracing connect internal in sqlplus I came
across this quirk and of course I have to investigate
Guess what I found...: )

  

Bookmark Fixed font  Go to End 

Doc ID:  Note:107842.1 
Audit Trail: Connect Internal 
Type:  BULLETIN 
Status:  PUBLISHED 
 Content Type:  TEXT/PLAIN 
Creation Date:  06-MAY-2000 
Last Revision Date:  06-JUN-2000 
Language:  USAENG 
 

PURPOSE
---

Assist in resolving why Application Log may be filling
up,
and/or why Events auditing connects are frequently
written to
the Application Log.

 
SCOPE & APPLICATION
---

This article is intended for Oracle Support Analysts
and Customers
to assist in troubleshooting frequent connect events
in the Application Log.


Application Log is Full with Event ID 34 : Audit
Trail: Connect Internal


In Oracle8i on Windows NT, auditing can be configured
so that audit trail
actions are written to the Application Log in the
Windows NT Event Viewer.
These Events will be logged into the Application Log
with Event ID 34.
Most of these Events are not logged unless the
INIT.ORA parameter
AUDIT_TRAIL is set to either OS or DB.  The default
for this parameter is NONE.

However, auditing of the Events for Connect Internal
and/or Connect as SYSDBA 
or SYSOPER is enabled by default and cannot be
disabled.  Therefore, regardless 
of whether you have set the AUDIT_TRAIL parameter in
the init.ora, Oracle will 
still log Events to the Event Viewer every time a
Connect Internal or Connect 
as SYSDBA/SYSOPER occurs.  What you will see in the
Application Log in the 
Event Viewer is an Event with ID 34 and the Source
will be Oracle..  
Clicking on the Event will give you a description such
as:


Audit trail: ACTION : 'connect internal' OSPRIV : DBA
CLIENT USER: 
SJESSE\SJESSE CLIENT TERMINAL: SJESSE. 

This is no cause for concern unless you detect that an
unauthorized client
has made a connection.  In most cases, a connect
internal is a fairly 
infrequent occurrence.

However, in instances where frequent connects occur,
this can be an annoyance.  
Depending on how frequently a Connect Internal Occurs,
you may see a number of 
these actions in your Application Log.  This can cause
particular problems when 
running Oracle Failsafe.  Oracle Failsafe has a
polling machanism which does a 
Connect Internal at a specified Polling Interval to
check if the database is
up.  By default, this polling interval is once every
minute.  Therefore, when 
running Oracle Failsafe, because of the auditing of a
Connect Internal, the
Application Log is likely to fill up very rapidly with
these messages.

Since there is currently no way to disable these audit
actions, you will have 
to work around this problem.  This can be done in a
couple of different ways:

1.  Increase the size of the application log.  By
default, this is only 512k.  
It can be increased to an appropriate size by
choosing 'Log Settings' under
the LOG menu in the Event Viewer, and then
entering an appropriate number 
for Maximum Log Size.

2.  Also in the Log Settings Menu, you can specify if
Events should be 
overwritten, and if so, how frequently.  Choosing
the option to  
'Overwrite Events as Needed'  will prevent the Log
from filling up.  
However, be sure to make the Maximum Log Size
large enough to avoid 
overwriting critical events before the log can be
checked.

3.  If running Oracle Failsafe, you can reduce the
frequency of the polling, 
and therefore the frequency of connects, by
increasing the "Is Alive" 
Interval.  As Noted above, this defaults to 6
Milliseconds, or 1 
Minute.  To increase this Interval:

 a. Log on to Failsafe Manager
 b. Find your group and expand it by clicking on the
(+) beside it.  
 c. Drill down and find the database and highlight it.
 d. With the database highlighted,  choose the
policies tab on the right-hand 
side and type in a new number for the  "Is Alive"
Interval.  Note that you 
do NOT need to change the "Looks Alive" Interval
as the polling done for 
this check does NOT do a Connect Internal.

(Click on the Help button in the policies tab for more
information on 
"Is Alive" and "Looks Alive" Polling.)

Note also that if you are running in a Failsafe
Environment and you choose to 
change the Log Settings for the Application Log, you
should make these changes 
on all nodes in the cluster.


RELATED DOCUMENTS
-

For More information on how Oracle uses the Windows NT
Event Viewer for 
auditing, refer to the following Notes:

[NOTE:67868.1]
[NOTE:99137.1]

See also the Oracle 8i (Release 8.1.6) Administrator's
Guide for Windows NT
or the   Oracle 8i (Release 8.1.5) Getting Started
Guide for Windows NT
.

 


 
 Copyright (c) 1995,2000 Oracle Corporation. All
Rights Reserved. Legal Notices and Terms of Use.  

RE: Someone changed INTERNAL password URGENT

[Cale, Rick T (Richard)]

You can use the orapwd utility to recreate password file with new internal
password.

Rick

> -Original Message-
> From: Murali Vallath [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 9:17 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Someone changed INTERNAL password  URGENT
> 
> URGENT,
> 
> Someone changed the internal password. How do you connnect or change the 
> internal password, if not able to find it?
> 
> Murali Vallath
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Murali Vallath
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Cale, Rick T (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).

Just like Christmas

[Kimberly Smith]

Two brand spanking new N-Class servers arrived yesterday as I was leaving
work.  Sure look nicer then the K-Class's we currently run on.  Can't wait
to get my hands on it.  Plus I got a brand new NT server just waiting for me
as well (although its awfully hard to get excited about that one let me tell
you).


Kimberly Smith
Database Administrator
EDS - Fujitsu/GMD
Phone: (503) 669-6050
Fax: (503) 669-5705
Email : [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).

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

[Hand, Michael T]

Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her
hard candy nomenclature.  In the US its refered to as Rock candy, basically
colored, flavored, crystaline sugar (sucrose, not glucose) available in
various shapes and sizes though I haven't seen much of it lately. [It's
probably gone the way of ribbon candy and other treats of yesteryear...
(Norman Rockwell moment).] The most common US seaside confection is
Saltwater taffy, or cotton candy. 

Confectionarily yours,
Mike

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


ermI don't know how this travels. 

Like a sugary candy which is extremely hard, you do have candy canes in the
States for Christmas trees etc ??
Sort of thicker, straighter version and normally minty in the UK - very
popular at Seaside resorts where the sweet is manufactured with the name of
the resort printed all the way through the middle. Oh God - this is sounding
more weird, the more I try and describe it.
 
Any other Brits who have lived/worked extensively in the States care to
offer a better translation ??

Cheers

Lee



-Original Message-
Sent: 20 March 2001 13:26
To: Multiple recipients of list ORACLE-L


rhubarb flavored rock  I'm working on a tentative assumption here that 
you don't mean actual rocks... translation please!


>From: lerobe - Lee Robertson <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Tue, 20 Mar 2001 00:05:25 -0800
>
>Been drinking it in the UK for most of my 37 years !!!
>
>Used to be a plain old pick me up for years (if you ever had to go into
>hospital or indeed went visiting, you were either given or giving a 
>bottle).
>
>Nowadays it is used by sportsmen etc for exactly what you have described.
>
>Regards
>
>Lee (one of the original Lucozade kids)
>
>PS. This was one of my mothers cravings when she was pregnant with me -
>however she could only drink it whilst eating rhubarb flavoured rock - 
>WEIRD
>!!
>
>-Original Message-
>Sent: 19 March 2001 20:41
>To: Multiple recipients of list ORACLE-L
>
>
>Speaking of sugar...
>
>I just returned from Trinidad (on a mission trip to build a church in 
>Toco).
>While working in the 95 degree sun all day we often walked up to the corner
>store and bought water and cokes (the coca cola was much sweeter there than
>in the US, but also less carbonated).  What we also found was a product
>called Lucozade (http://www.lucozade.com/).  This was a sport drink
>essentially made of glucose syrup.  From their website - "When you drink 
>it,
>the glucose gets rapidly absorbed into your bloodstream and gives you a
>quick burst of energy.  Glucose is the natural preferred fuel for the body
>becuase of the speed with which it can be digested and absorbed.  Once
>absorbed it is a readily available source of fuel, whic all cells of the
>body can utilise."
>
>Official drink of on-call DBAs.
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C.
> > Applewhite
> > Sent: Monday, March 19, 2001 11:16 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >
> >
> > Kimberley,
> >
> > I'd be surprised if you can get "real" raw sugar in stores.
> >
> > When I was in the U.S. Peace Corps in Belize in the mid
> > '70s, raw sugar was readily available, since sugar was a
> > primary export from that beautiful little country.  If you
> > let a couple of pounds of raw sugar sit in a brown paper bag
> > for a day or two, the molasses would settle to the bottom
> > and puddle - a jar, shaken occasionally, was a better
> > storage option.
> >
> > It was delicious!  There's nothing quite like a peanut
> > butter and raw sugar sandwich!  Ironically, the Belizians
> > preferred refined, white sugar, since it was considered more
> > "upscale" than the raw sugar.
> >
> > BTW, other advantages to living in a sugar-exporting country
> > included very cheap soft drinks and rum!...Oh, and Reggae!
> > ;-)
> >
> > Jack
> >
> > 
> > Jack C. Applewhite
> > Database Administrator/Developer
> > OCP Oracle8 DBA
> > iNetProfit, Inc.
> > Austin, Texas
> > www.iNetProfit.com
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Kimberly
> > Smith
> > Sent: Monday, March 19, 2001 9:33 AM
> > To: Multiple recipients of list ORACLE-L
> > Recipe
> >
> >
> > Hey, found out that muscavado sugar is raw sugar.  Hopefully
> > I can find it in the stores.  If not I am going to Second
> > Cup and
> > "borrowing" a whole bunch of little packets;-)
> >
> > >>375g dark muscovado sugar
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kimberly Smith
> >   INET: [EMAIL PROTECTED]
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://

RE: Someone changed INTERNAL password URGENT

[Mark Kirk]

Run orapwd.

Replace the password file. This is only possible if you have admin rights on
the system.

The options will come up if you add nothing to the end of the command, and
you can go from there.

You can change the system and sys passwords using ALTER USER as an
authenticated privileged user.

That's it for now,

   Mark

Mark Kirk
  Working toward the Oracle DBA OCP
& seeking an entry level position...
 [EMAIL PROTECTED] 



-Original Message-
Vallath
Sent: Tuesday, March 20, 2001 4:18 PM
To: Multiple recipients of list ORACLE-L


URGENT,

Someone changed the internal password. How do you connnect or change the
internal password, if not able to find it?

Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Someone changed INTERNAL password URGENT

[Harsh Agrawal]

Hi, 

Pl. check in {ORACLE_HOME}/database directory there is a file

PWD.ora.

Just move this file some where and try to connect.

Bye

-Original Message-
Sent: Tuesday, March 20, 2001 4:18 PM
To: Multiple recipients of list ORACLE-L


URGENT,

Someone changed the internal password. How do you connnect or 
change the 
internal password, if not able to find it?

Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Harsh Agrawal
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: OT: Rachel in Vietnam

[Mohan, Ross]

Title: RE: RE: RE: OT: Rachel in Vietnam





Dick , 


Didn't you know? Rachel WAS in Nam. But she 
never talks about it. I think it had to do
with the bugs. 


Just a thought. 


Ross


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Re



Rachel,


    If you were given one, as I was in Nam, you'd not know the difference. 
Looks like, & tastes like a crunch bar for the most part, except for the logo on
top.  It just crunches better.


Dick Goulet


Reply Separator
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date:   3/19/2001 4:10 PM


but Moom, the icky bugs TOUCHED the chocolate!   :)




>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
>Date: Mon, 19 Mar 2001 13:45:29 -0800
>
>You could just lick the chocolate off.
>
>-Original Message-
>Sent: Monday, March 19, 2001 10:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
> I have a phobia about bugs...
>
>what a waste of perfectly good chocolate
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 09:11:20 -0800
> >
> >OK you chocaholics try this on for size:
> >
> >  Reuters Monday, March 19, 2001
> >
> >Chocolate-Coated Bugs Are Latest Treat
> >
> >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> >in chocolate and promoted as a high-protein snack, are proving
> >popular among peckish Londoners.
> >
> >Designer Todd Dalton, who trained as a chef in Louisiana and
> >acquired a taste for cooked insects on his travels in Asia and
> >central America, says he has sold 5,000 chocolate-coated bugs
> >since he began marketing them in December.
> >
> >"They are very high in protein and very low in fat. They have a
> >higher percentage of protein than any meat or fish that we
> >commonly eat," he told Reuters.
> >
> >The creepy-crawly chocs sell for between three and 3.50 pounds
> >($4.30-$5.00) at upmarket London stores such as Selfridges and
> >the Conran Shop and will soon be appearingin shops in Munich
> >and Zurich.
> >--
> >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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: 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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Pub

RE: Insert without telling column names

[Jacques Kilchoer]

Title: RE: Insert without telling column names





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> How can I create an insert statement without telling all the 
> names of the columns?
> Give an example, please.



As Jared mentioned, if you are inserting into all the columns in a table, you don't need to specify the column names. But this is a BAD IDEA, because if someone adds a column to the table all your insert statements written without column names will fail unless you add values for the new column to the insert statement. So while this might be OK when typing in SQL for "one-time" use, don't use this method in any programs/scripts that will be used more than once.

--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Free Oracle DBA tests on the web

[andrey]

Hi DBAs 
!
I'm looking for some 
FREE Oracle DBA / developer resources on the web :
self-tests , OCP 
preparations materials , articles , books , etc ...
Please share your 
resources !
Thanks a lot in 
advance .
Andrey 
.

OT -- Canada Rules! (fwd)

[Boivin, Patrice J]

Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.

With all the recipes going around, I thought it wouldn't do any harm.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
>  So, what do Canadians have to be proud of? 
>  
> * Smarties 
>  
> * Crispy Crunch & Coffee Crisp 
> 
> * The size of our footballs fields and one less Down 
> 
> * Baseball is Canadian 
> 
> * Lacrosse is Canadian 
> 
> * Hockey is Canadian 
> 
> * Basketball is Canadian 
> 
> * Apple pie is Canadian 
> 
> * Mr. Dress-up kicks Mr. Rogers ass 
> 
> * Tim Hortons kicks Dunkin' Donuts ass 
> 
> * In the war of 1812, started by America, Canadians pushed the
> Americans back...past their 'White House'.   Then we burned it...  and
> most
> of Washington, under the command of William Lyon McKenzie  who was insane
> and hammered all the time.  We got bored because they ran away, so we came
> home and partied ... Go  figure... 
> 
> * Canada has the largest French population that never surrendered to
> Germany. 
> 
> * We have the largest English population that never ever surrendered
> or withdrew during any war to anyone, anywhere. 
> 
> * Our civil war was a bar fight that lasted a little over an hour. 
> 
> * The only person who was arrested in our civil war was an American
> mercenary, who slept in and missed the whole thing...but showed up just in
> time to get caught. 
> 
> * We knew plaid was cool far before Seattle caught on. 
> 
> * The Hudsons Bay Company once owned over 10% of the earth's surface
> and is still around as the worlds oldest company 
> 
> * The average dog sled team can kill and devour a full grown human in
> under 3 minutes. 
> 
> * We still know what to do with all the parts of a buffalo. 
> 
> * We don't marry our kin-folk. 
> 
> * We invented ski-doos, jet-skis, velcro, zippers, insulin,
> penicillin, zambonis, the telephone and short wave radios that save
> countless lives each year 
> 
> * We ALL have frozen our tongues to something metal and lived to tell
> about it. 
> 
> *  BUT MOST IMPORTANT! 
> 
> *  the handles on our beer cases are big enough to fit your hands
> with mitts on. 
> 
>  ooh Canada!! 
> 
>  Oh yeah... and our elections only take one day. 
> 
>  
-- 
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).

RE: Someone changed INTERNAL password SOLVED..

[Murali Vallath]

We do not have a practice to give password for the internal account. So when 
it promoted it sounded like someone had assigned a password. Apparently 
there was a parameter

SQLNET.AUTHENTICATION_SERVICES parameter added to the sqlnet.ora file. when 
I commented this out. It worked.

Thanks for your help

Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: 'Murali Vallath ' <[EMAIL PROTECTED]>
Date: Tue, 20 Mar 2001 10:30:16 -0600

  Hi!

If you are using windows nt...

use orapw to re-change it...

if you are using unix:
you connect with svrmgrl!!!

Hope this help!



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/20/01 8:17 AM

URGENT,

Someone changed the internal password. How do you connnect or change the

internal password, if not able to find it?

Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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