ok so i'm in a good mood, how about this:
i input ur names into a table and ran this against it,
if u want to know what its doing email me if you can't figure it
out.
joe
select substr(name,1,(instr(name,' ')-1))
first, substr(name,instr(name,'
',-1,1)+1) last, decode(instr(name,'
To rename the listener.log, try this(on Unix)
1) cp listener.log listener.log.bu
2) cat /dev/null listener.log
OR you can have the following shell script submitted to cron to rename log
file
at regular intervals.
===
DT=`date +%m%d%y%H%M`
cp listener.log listener.log.$DT
cat
Title: Heads Up: Virus coming from list - Venkata Apparao
Looks like Venkata Apparao has a virus. This person called me fat!
-Original Message-
From: NAV for Microsoft Exchange-FFLMAIL
Sent: Wednesday, June 27, 2001 12:46 PM
To: Koivu, Lisa
Subject: Norton AntiVirus detected a
Kevin:
Yes, I got 2 of them and immediately deleted them. They
looked fishy to me.
Ken Janusz, CPIM
Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with
attachments. It appears to just be peaces of emails and then a see
attached and an attachement? Yeah, I'll get right
Arn't you going to make sure
you actually have the disk space to resize that data file first?
Something
OEM does not do for you.
Must go out to the server and check.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 27, 2001 7:22
AMTo:
And I thought I was in a bad mood today. All nighter last night.
-Original Message-
Sent: Wednesday, June 27, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Now I'm confused John - Is it a 2nd or 3rd rate O/S? :)
The name is Jon. While Douglas Adams may have thought it to be
Tracey,
Sorry I didn't keep the original message - seems I've only got about 10K of
space on the mail server - I have to delete almost everything immediately.
Anyway, your question intruiged me. Most everybody thought you should have
at least three tables, I suspect it's even more.
Here's my
I only get os_roles and os_authent_prefix.
???
This timed_os_statistics has potential, esp. if we can then monitor info
similar to Performance Monitor or snmp from within Oracle stats.
More views means more CPU drain though, I suspect.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Title: RE: Mark's Wild A** Vid Card
It's been 10 years since I read it, but this is the guy
who wrote Zen and the Art of Motorcycle Maintenance, right?
Robert Pirsig called those gumption traps, and they can make us wind
up cranky, misanthropic NT haters. (He didn't say that last part.)
True Fact: Unix was first invented in 1913 by my great great uncle (twice
removed) Ralph Unix. Ralph worked with him as THE first DBA.
I bet most of you didn't know that the Unix server Ralph is talking about is
powered by steam engine! ;-)
Defry
- Original Message -
To: Multiple
How about timed_statistics=true is a performance overhead.
Or you still worry about temp segments not being released after a sort.
From: Jeremiah Wilton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Common Oracle RDBMS
Now I'm confused John - Is it a 2nd or 3rd rate O/S? :)
The name is Jon. While Douglas Adams may have thought it to be 2nd rate, I
believe it to be 3rd rate. Too much to handle?
you can't have written that on a Windoze box - it would have corrected
it for you ! :)
Are you a genius or
On Wed, 27 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-Not so fast, there, Cisco Kid. It's not quite dead.
-
-There is some talk about doing the EV7 thing all the way,
-and even if the branding goes away, the technology is
-likely to migrate.
-
-Alpha has/had some killer
On Tue, 26 Jun 2001, Stephane Faroult wrote:
But in practice, why would you switch to the standby database, unless
the primary database is crashed or worse?
- Hardware replace/repair
- Move to a larger host
- O/S upgrade
- File layout revision
- Planned/impending infrastructure outage
-
Patrice,
I don't know which version of the manuals you're
looking at, but there was a doc bug where the values
for the parameter were listed as OFF, CALL LOGOFF.
The correct way to use it is to set it to an integer
value representing the number of seconds the OS stats
will be refreshed.
Also,
Jon,
Just curiousity here, are you an Oracle DBA (certified or otherwise)?
As for using a text based mua on a sun machine, which doesnt
attempt to correct mistakes, thus not creating its own, well, you are right
about that, but then it doesn't seem as if you need any help in introducing
Title: SQL-Server Presentation/Reality Check
I have the privilege of being tasked to attend a SQL Server presentation to
be conducted by Microsoft at our site. Our company's current take on SQL
Server is that it's to be used only in the case where a packaged application
requires it, or when
Connor,
Thanks for your input. I agreed with you on what you said about the cache,
however what I was asking is the read-ahead that the file system provided,
for a physical read request, the file system actually read more blocks into
the buffer, so the next physical read request can be satisfied
Thanks for the example.
Case closed :)
- Kirti
-Original Message-
From: Vladimir Begun [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Sqlplus--how to suppress Connected.
On Jun 27, 2001 at
John,oops JON,
Sounds like someone
1) Woke up on the wrong side of their UNIX box and
2) Has no tolerance for anything not similar to their own way of thinking.
I think most of us will agree that UNIX is heads a shoulders a better
platform for MOST systems that run apps like Oracle,
I also just told our network/mail person here...
From: A. Bardeen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Virus?
Date: Wed, 27 Jun 2001 10:31:50 -0800
Kevin,
Yes, I received them too. I've already notified him
yepppers, look like viruses :)
joe
[EMAIL PROTECTED] 06/27/01 01:42PM
Hey, did anyone recieve a bunch of emails for a Venkata Apparao
N withattachments. It appears to just be peaces of emails and then a
"seeattached" and an attachement? Yeah, I'll get right on opening that
Sorry, I have to argue here. Seems like wasting bandwidth is o.k. on this
list as long as OT is in the subject... :-)
These stats are only for *Registered* gun owners! How many have guns that
*nobody* knows about?
This may actually decrease the deaths per gun owner stat, so the gap
On Wed, 27 Jun 2001,Mark Leith scribbled on the wall in glitter crayon:
-And here's me thinking that the great US of A had an Executive Order banning
-them from ever taking part in any assassination - ever.. :) Or do you mean
-of the military kind Shrek?
i'm afraid i can't answer that question.
well if it was just first last, it would be
simple
select substr(name_column,1,(instr(name_column,' ')-1)
first
there is the part to pull off the first, i'll let you
experiment with the rest :)
no reason to give you the WHOLE answer :)
joe
[EMAIL PROTECTED] 06/27/01 12:26PM
Hey
Title: RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy
I'll
tell you what is disrespectful and will not be tolerated by any means. Turning
up for class with a hint of alcohol on your breath. My instructor went
ballistic. I only had a small glass of lager at a lunchtime but (according to
One easy way is the touch and the find command
1. Touch a file with the date you want to search from.
touch -t date_time file_name
where date_time is in the form of mmddhhmi.ss
and file_name is the name of a temp file to use on the search.
I
Just as a starter you could start with the below
the first two decodes check whether there are any spaces and the third
decode checks that the first and last space are different i.e there is a
middle name.
The instr(full_name,' ',-1) is checking for a space from the end of the
string.
You
man find
will tell you how to do it.
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L
Subject: how to
Jeremiah,
You've hit most of mine, but here are a few more:
* It's OK to continue using a db after you've forced
it open.
* To remove a datafile from the db, all you need to
do is offline drop it.
* All there is to switching from RBO to CBO is to
analyse the tables.
* You can apply
Tom,
Yes I also recieved that script. However I thought about it, and for what
I am doing, just scheduled exports of schemas, I don't need the seconds.
All that I really need is the hour, but the minute comes in handy!! Thanks
again:)
Kev
-Original Message-
Thomas F
Sent:
All,
I just got two emails from Venkata Apparao 'replying' to
posts I made weeks go. The only line in the text told me
to see the attachment. Yeah, I'll do that.
My mail server told me it found and cleaned a virus.
I imagine most of you, if you also received such, figured
it out yourselves.
I'm not sure, but he was probably referring to resyncing a standby. Some
people think that in order to get the standby back up after a crash, they
need to start over by copying all of the datafiles. Instead, all you have to
do is ftp the archive log files over, recover standby database and
I've got this check constraint on a column (NBR) (which is actually a
VARCHAR2(10)).
translate(lpad(NBR,9,'0'), '0123456789','--') =
'-'andNBR between 1 and 1)
As far as I can see it's left padding the string with 0's to a length of 9,
translating
My users are writing many of their own functions and it is causing performance to
suffer
on a few simple queries. For example, I have a query that just selects count(*) from a
table. With the function
select count(*) from a_table where a_column = cdk(1234567890);
It takes 5 minutes
By
Ross,
Do you mean to check v$sysstat and statname? (not parameter) If I remember
correctly, the statistics that are populated are OS dependent (not all OS's
populated all stats).
Henry
-Original Message-
Sent: Wednesday, June 27, 2001 12:33 PM
To: Multiple recipients of list ORACLE-L
Yes, I received it also and attachment was having virus so I deleted it.
Regards
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 27 Jun 2001 09:42:08 -0800
Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with
attachments.
Lisa,
I'm sure he meant: Phat.
;o)
-Rocky
--- Kimberly Smith [EMAIL PROTECTED] wrote:
Sometimes being called Fat is a complement. I really am not sure why
but
its those same people who think stupid is a complement.
-Original Message-
Sent: Wednesday, June 27, 2001 10:42 AM
To:
Will everyone please drop the 24 x 7 from the subject?! I asked the
question a few days ago and the discussion now has nothing to do with the
question. Thanks to those who actually had input to the original question.
Ron
-Original Message-
Sent: Wednesday, June 27, 2001 12:57 PM
To:
Crush him with that Ninja kick ;-)
- Kirti
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L
Subject: Heads Up: Virus coming from list - Venkata Apparao
Looks like Venkata
Yes, I got a couple.
Terry
Kevin Kostyszyn wrote:
Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with
attachments. It appears to just be peaces of emails and then a see
attached and an attachement? Yeah, I'll get right on opening that up.
Sincerely,
Kevin Kostyszyn
Title: Heads Up: Virus coming from list - Venkata Apparao
Sometimes being called Fat is a complement. I really am not sure
why but
its
those same people who think stupid is a complement.
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 27, 2001
Title: SQL-Server Presentation/Reality Check
Be
sure to ask them about Micro$ofts new pricing method. Also be sure to find
out why they are making their customers prove that they have the appropriate
number of legal licenses for each install of all M$ software. This had our
network guys
On Wed, 27 Jun 2001,Marty Bonner scribbled on the wall in glitter crayon:
-I just got a shiver down my spine as I realized... you got kicked off of
-Slashdot, didn't you? Not playing nice with the rest of the kids?
-
-Anyhoo, your rhetoric is more appropriate for that forum than this one.
On Wed, 27 Jun 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-
-As for using a text based mua on a sun machine, which doesnt
-attempt to correct mistakes, thus not creating its own, well, you are right
-about that, but then it doesn't seem as if you need any help in introducing
I'll answer my own question.
It's testing to make sure that the VARCHAR2 only contains numeric
characters. I asked my roomie to help and as I was explaining what we were
looking at I answered my own question.
Now, why they're doing this is another question.
--
Please see the official
Hi folks...
I've checked the list and the virus is NOT being propagated via the list.
The person with the infection is sending replies to all of you individually.
Each time you post a message to the list, your message is re-sent to
him/her, and the virus on their computer is sending you a reply
I think I must have something confused here.
If this list removes attachments to avoid viruses, how does a virus in
an attachment come through the list?
I would think that it might be sent out directly. This makes some
sense as it seems that not everyone is receiving the
I am curious if data available of number of Oracle books copies sold. Sorry
for being incredibly rude because this is apparently another thinly vailed
attempt to find out how much money certain authors make :-)
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
select count(*) from table
where a_column =
( select cdk(123) from dual where rownum = 1 )
or you can use DISTINCT or a NO_MERGE hint - anything
to force the subquery to be evaluated in isolation
hth
connor
--- David Turner [EMAIL PROTECTED] wrote: My
users are writing many of their own
My understanding is that most modern disks have track
buffers anyway which would obviate the need for
this...
(I'll happily stand corrected if anyone knows better)
hth
connor
--- KC [EMAIL PROTECTED] wrote: Connor,
Thanks for your input. I agreed with you on what you
said about the
It is sort of looking like he got kicked off of this one as well:)
-Original Message-
Bonner
Sent: Wednesday, June 27, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
I just got a shiver down my spine as I realized... you got kicked off of
Slashdot, didn't you? Not playing nice
Hi David,
Can you have them write the query with a variable then populate the
variable with the function?
-Rocky
--- David Turner [EMAIL PROTECTED] wrote:
My users are writing many of their own functions and it is causing
performance to suffer
on a few simple queries. For example, I have a
Bad day man? Lighten up a little bit. Would be nice first to answer some
Oracle questions posted on this list and then publish your opinion about
idiots around there.
Alex Hillman
-Original Message-
Sent: Wednesday, June 27, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Now
Why would anyone compare you to a file allocation table???
Bizarre.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 2:42 PM
To: Multiple recipients
S !!
Alex is awake !!! ;-)
- Kirti
-Original Message-
From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: 24 x 7 on NT?
Bad day man? Lighten up a little bit.
select count(*) from a_table where a_column = (select cdk(1234567890) from
dual);
Regards,
Waleed
-Original Message-
Sent: Wednesday, June 27, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
My users are writing many of their own functions and it is causing
performance to
Pat,
I received the email directly (not thru the list) from Mr. V..
luckily, the email virus software stripped his attachments out before I
got'em.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 27, 2001 4:23 PM
To: Multiple recipients of list
John Dunn wrote:
I would like to be able to amend all occurences of a string in all columns
of all rows of a table.
Can I do this, without specifying individual column names?
Please note that the string may include forward slashes /
John
John,
If you do not want to specify
Kevin,
sorry,
missed the last digit (another 9)
Bug #
1328999
Tom Mercadante Oracle Certified Professional
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 27, 2001 1:17
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Same here.
I deleted right away
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 12:17 PM
To: Multiple
Too many bugs I guess?
g,d, rlh
Thanks, Anita.
-Original Message-
Sent: Wednesday, June 27, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L
Ross,
It is as far as Oracle is concerned. Compaq Alpha NT
was desupported as of 4/30/01 (see note 93651.1).
-- Anita
---
this is not elegant, but works:
execute this is sqlplus:
host (srvinfo -od ) disk_info.txt
host blat disk_info.txt -to [EMAIL PROTECTED]
which will provide you with output of the format:
-Original Message-
Sent: Wednesday, June 27, 2001 3:48 PM
To: log_files
C$,NTFS,2048,1890,158
Privilege ? Reality? Reality and MS is an oxymoron.
I've had the fortune (misfortune) to become a SQL Server DBA
in addition to my Oracle duties, due to packaged application
requirements. As an admitted defiler of all MS stands for and
it's dubious accomplishments, I'll offer a few grains of
Right on Rachel!! You go get'em girl.
To add to the mix..
Some of the participants on this list are extremely knowledgeable and published. They
are willing and able to offer assistance when the opportunity arises. All people are
given the chance to voice their opinion and should do so with
HAHAHAHAAHAHAHHHwow that was good:)
-Original Message-
Patrice J
Sent: Wednesday, June 27, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L
Why would anyone compare you to a file allocation table???
Bizarre.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Jon,
slowly now - no - slower than that, take you hands away from the keyboard.
carefully now, shutdown your machine.
slowly back away from your desk.
now run like hell for your car.
go home, get a glass of lemonade, and find the nearest shady place.
breath deeply.
now, isn't that
The first part
translate(lpad(NBR,9,'0'), '0123456789','--') =
'-'
checks to see if the string is ENTIRELY made up of numbers. And it also
assumes there is at least 1 character in the string (using lpad of 9 instead
of 10)
The second part .
OOPS! STATISTICS names, not PARAMETER names:
e.g.
OS User time used
OS System time used
btw, it's flavor-dependent...somes OS'es have ALOT!
hth
-Ross
-Original Message-
Sent: Wednesday, June 27, 2001 2:17 PM
To: Multiple recipients
Hi
You migth try something like: select rowid, columnX from tab where
conditions for update
Svend
Kevin Lange wrote:
Hey Gang;
Does anyone know of a way to find exactly which rowid is locked in a table
?? I have a developer who has a requirement to report exactly which record
is
Yes! :-) I thought so, tooPirsig is still around, and
may well be working on a third booklet's hope so!
-Original Message-
Sent: Wednesday, June 27, 2001 3:08 PM
To: Multiple recipients of list ORACLE-L
THAT was an awesome book!
-Original Message-
Sent: Wednesday,
I think it might've been send directly because I did not receive any of the
infected e-mails from that individual. Again I just joined the list
recently. To refresh your memory, I also don't receive as many recruitment
adds as you guys do. So, some people might've got a hold of the list
It did come directly. But I think they got our addresses from the list.
-Original Message-
Sent: Wednesday, June 27, 2001 3:23 PM
To: Multiple recipients of list ORACLE-L
I think I must have something confused here.
If this list removes attachments to avoid viruses, how does a virus
Can you provide some references to lack of support of read-consistency. Not
that I don't believe you but I just read that to a guy next to me and he is
clamoring for evidence. - E
-Original Message-
Sent: Wednesday, June 27, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L
why dont you find that out from the v$session
in which u can find out which object_id,file_number,block_number and rownum
on that blockid.
based on this use the package dbms_rowid to extract the rowid of that table
you want to know
From: Svend Jensen [EMAIL PROTECTED]
Reply-To: [EMAIL
why dont you find that out from the v$session
in which u can find out which object_id,file_number,block_number and rownum
on that blockid.
based on this use the package dbms_rowid to extract the rowid of that table
you.
From: Svend Jensen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
We have approximately 40 or so people external to this office and to our
operation that require access to confidential information (with that
population is increasing). The connections to Oracle are made through
DSN/ODBC using various applications (access, excel,etc) and data are
restricted
I've got a cute one here. I saw something like this years ago, but I can't
remember what I did. The database is running Oracle 8.0.6 on Solaris 2.6. I
was just brought into this problem, so I don't know too much about the
database. It is shutdown nightly for a cold backup, and by the looks of
Hi Guru:
We have a window's machine runing oracle database. Originally the database uses static IP address. Everything is fine. Now we change the network config to use DHCP server to assign IPaddress dynamically. We have the error message. Database is up but we can't use svrmgrl, sqlplus and
Hi ,
Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc. Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access
Folks...
It is very important that you all read and adhere to this message.
The list may have had a problem recently with a hacker, and/or viruses from
an unknown source. The potential abusers have been removed, so we have a
small window of opportunity to make sure this doesn't escalate. The
1) What are the last few lines in the alert log? ( as you try to open it)
2) is there a process that is taking alot of CPU?
3) what are the mtime, ctime, and atime of the SGA shmmem segs? Appropriate?
-Original Message-
Sent: Wednesday, June 27, 2001 5:54 PM
To: Multiple recipients of
Henry,
Couple of immediate things come to mind you didn't mention:
(1) Is your archive destination full?
(2) I'm not sure at what point this file comes into play, but have you
removed any occurrence of lckSID file when the DB is shut down?
I'm sure others will have more (and probably much
Title: SQL-Server Presentation/Reality Check
I went
through this 'Reality Check' a couple of months ago. And I have deep
experience with both products. The result of check is, SQL Server is NOT as
cheap as you thought.
Zhong It's another beautiful day!
-Original Message-From:
Henry,
Look at doc # 61552.1 on Metalink.
HTH,
Michael
www.atelo.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 17:54
I've got a cute one here. I saw something like this years ago, but I can't
remember what I
Microsoft itself will tell you that it won't
allow you to read a record/row that someone
is actively changing.
They give a few examples that make very good sense to
yours truly.
I am sure that others can come up with examples that
make it look like the stupidest thing since poisonivy-based
Has anyone run across a Pocket Guide for SQL. I don't need one for
SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax
for some commands and a quick guide really helps. Sucks getting old.
I don't see one from O'Reilly which normally handles a series like this.
--
Jon
Please check for space ,specially where your log files are. Most possible
file system containing your alert log has no space left...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 27 Jun 2001 13:54:07 -0800
I've got a cute one
Hello,
I have a file to contain info about the reports detailed info (stored in a temp table in the DB) we created every night. Such as: report ID, report_name... However, sometimes there is no report generated overnight. In this case, the temp table would be empty. But this file will still spool
On Wed, 27 Jun 2001,Helen rwulfjeq scribbled on the wall in glitter crayon:
-ORA-12638: Credential retrieval failed
-
-
-BM_28047
-
-Cause: The authentication service failed to retrieve the credentials of
-a user.
-
-BM_28048
-
-Action: Enable tracing to determine the exact error.
did you
Original Message
Date: Wed, 27 Jun 2001 14:50:09 -0800
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Well, I got the answer. It's amazing what changing a couple of words in
a
Helen,
change the following in the sqlnet.ora file:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
that will fix it.
Paul
Original Message
Subject: ORA-12638: Credential retrieval failed URGENT
Date: Wed, 27 Jun 2001
Lisa Clary wrote:
We have approximately 40 or so people external to this office and to our
operation that require access to confidential information (with that
population is increasing). The connections to Oracle are made through
DSN/ODBC using various applications (access, excel,etc) and
From SQL-Server BOL (Books on Line)
READ COMMITTED
Specifies that shared locks are held while the data is being read to avoid
dirty reads, but the data can be changed before the end of the transaction,
resulting in nonrepeatable reads or phantom data. This option is the SQL
Server default.
Hi Henry
You may be hitting a bug 1399885 due to timer overflow. Can you check the uptime ? Also check the clock ticks per second. Due to a timer overflow problem, when the machine is up and running for more than 248 days (ticks=1000) or 24 days (ticks=100) then the database will hang and
Hello Alex,
Is there a reason you are asking this question? Are you thinking of
proposing a book?
Ingram (http://www.ingram.com), a large book distributor, used to have
a phone number that you could dial, punch in an ISBN number, and then
hear Ingram's sales figures for that book for the
Title: RE: Wher is an error ?
HA! Shows what I know. I just re-read. Sorry Alex and everyone. I completely missed it.
Yeah, if anyone can shed light, I'd like to know too!
--Chris
[EMAIL PROTECTED]
-Original Message-
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: Wher is an error ?
Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.
Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
userid=xxy
export userid
echo $userid
xxy
if [ $userid=xxx ]; then echo 'aaa';
I'd like to follow up on this, because I wrote the SQL*Plus Pocket
Ref, and I'm planning to revise it soon. One of the things I want to
do when I revise the book is to add material about the more commonly
used SQL statements, because, frankly, I'm convinced that's what
readers really want.
One
My apologies. I meant for my note to go directly to Alex, not to the
list. I forgot to paste in his email address before I hit send. Sorry
about that.
--
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
101 - 200 of 219 matches
Mail list logo