Re: XP Professional & 9i

2001-12-29 Thread Scott Shafer
the HELP command for other information (like subscribing). _____ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: XP Professional & 9i

2001-12-29 Thread Scott Shafer
E yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HE

Re: Help - DBA interview questions I faced

2001-12-27 Thread Scott Shafer
Opinions vary, but often involve management "fundament-snorkeling". --Scott "Diver down!" - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 6:40 AM I am wondering how such peop

Re: Data Archiving

2001-12-27 Thread Scott Shafer
Title: Data Archiving On new db:create a db link from the new server to the old server. create table history_table as select * from orginal_table where criteria = meets_my_criteria_for _archiving; On old db: delete unneeded (archived) records from the original tables.   --Scott

Fw: ScanMail Message: To Sender, sensitive content found and action taken.

2001-12-24 Thread Scott Shafer
OK, who works for textron? And how did answers to "database administration questions" turn out to be "sensitive"? Hehehe... --Scott - Original Message - To: "'Scott Shafer'" <[EMAIL PROTECTED]> Sent: Monday, December 24, 2001 5:49 PM tak

Re: database administration questions

2001-12-24 Thread Scott Shafer
*** inline... - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 24, 2001 1:15 AM Subject: database administration questions Hi! I'm looking into getting into the field of Database Administrati

Re: Help

2001-12-20 Thread Scott Shafer
Yep. According to Metalstink, its not fixed until 8.1.7.3 and that won't be out until mid-January (I'm on HPUX). Or v9.0.2 if you like the bleeding edge... --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thur

Re: Help

2001-12-19 Thread Scott Shafer
I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The releases are supposed to be out in January, IIRC. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L&quo

Re: help

2001-12-17 Thread Scott Shafer
ng Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing li

Re: RECOMPILE INVALID OBJECTS

2001-12-17 Thread Scott Shafer
Can't look at the moment, but doesn't "?/rdbms/admin/utlrp.sql" do this for you? --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 12:20 PM > Group, > Does anyon

RE: ORA-600 and ORA-603 issues with dlm resource hash list

2001-12-17 Thread Scott
a patch for the problem. Setting _lm_direct_sends forces Oracle to use only 1 message channel and this can become performance issue. Hope this helps, Scott --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote: > just out of curiosity, what flavor of Unix? > What are your dlm lock conv

Re: Create a database without using DbAssist

2001-12-16 Thread Scott Shafer
What can I say, I'm a fundament (old oracle-l joke)... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, December 16, 2001 7:45 AM > SCOTT! > > You don't let the wizzards decide how you REALLY want you

Re: Create a database without using DbAssist

2001-12-15 Thread Scott Shafer
Yes. See the DB Administrator's Guide online at http://technet.oracle.com Its often easier to do it by hand, rather than let the crappy wizards screw it up. --Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAI

Re: DB SIZE ?

2001-12-12 Thread Scott Shafer
_ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 53

Re: HP AutoRaid vol configuration

2001-12-12 Thread Scott Shafer
Autoraid? Abandon all hope of achieveing anything resembling decent throughput. Other than that, go with HP's recommendations. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 11, 2001 11:20

Re: RE: Has anyone heard of "Mirror Accessible"?

2001-12-07 Thread Scott Shafer
wrote: > > > Ain't being a DBA glamorous??? > > > > > > Me, I'm just in it because I heard that DBA's > get > > > all the chicks :) > > > > > > Believe me, I feel your pain. I have more > Oracle > > > 7.3.4 data

Re: Parallel Server

2001-12-06 Thread Scott Shafer
implementation? > > Ron Smith __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services

RE: Unix mailing List

2001-12-06 Thread Scott Shafer
: > > 1. -a : file exists (any type of file) >-d : file is a directory >-f : file is a regular file (like Scott Said) > > 2. The test is not neccessary > > vFILE_NAME='The file in question' > > if [ -f ${vFILE_NAME} ] > then > echo "F

Re: RE: Has anyone heard of "Mirror Accessible"?

2001-12-06 Thread Scott Shafer
feel your pain. I have more Oracle > 7.3.4 databases here to upgrade than I can say > without embarassment. That's what I get for being > the new hire. :) > > A fellow DBA, > Scott Lockhart > Oracle DBA > I-Link, Ltd. > Draper, UT > -- > Please see the

RE: buffer busy wait & latch free ( cache buffer chain )

2001-12-06 Thread Scott Shafer
cess / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY

Re: Unix mailing List

2001-12-05 Thread Scott Shafer
This is untested and from memory, but: if [test -f ] then echo "found" else echo "help, are you an idiot" fi --Scott --- Sinard Xing <[EMAIL PROTECTED]> wrote: > Hi all, > > Can someone recommend good unix mailing list > > by the way how to chec

Re: Anybody heard Oracle will remove the JVM from Oracle in futur

2001-12-04 Thread Scott Shafer
L PROTECTED]> Sent: Tuesday, December 04, 2001 11:01 AM > Scott, > > Java is buried deep inside the entire Oracle Apps 11i product suite, making > it literally impossible to get it out of the RDBMS in the future. Getting > rid of the 'java-fied' installer may be easier and t

Re: Listener

2001-12-04 Thread Scott Shafer
> > Hallo, > > > > Can anybody tell me simply how the listener works? > > > > Thanks in advance > > > > Roland S _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Ple

Re: simple sql problem

2001-12-04 Thread Scott Shafer
>From the unix command line you can run: sqlplus -s scott/tiger << EOF select * from emp; EOF Viraj Luthra wrote: > > Hello all, > > Why cannot I do :- > > sqlplus -s scott/tiger select * from emp; > > or sqlplus -s scott/tiger "select * from emp;&qu

Re: Listener

2001-12-04 Thread Scott Shafer
ee @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Interne

Re: Anybody heard Oracle will remove the JVM from Oracle in futur

2001-12-03 Thread Scott Shafer
Hopefully there will be an end to the java hype, the buggy, slow, java-fied installers, etc... --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 5:30 PM > Why??? > > -Original Me

RE: function help ???

2001-12-03 Thread Scott Crabtree
Andrea, Here is a version of the function you asked for, IT IS NOT WELL TESTED, should give you something to go on. Scott Crabtree FUNCTION calc_avg (student_id IN NUMBER) RETURN NUMBER AS CURSOR student_c IS SELECT snum || call# class, credit, RTRIM

Re: Anybody heard Oracle will remove the JVM from Oracle in future re

2001-12-03 Thread Scott Shafer
Haven't heard myself, but I hope this is true. Please, please, please let it be true! --Scott "Khedr, Waleed" wrote: > > Thanks, > > Waleed _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.ya

Re: DISPLAY under AIX 4.3.3, was Fwd: urgent!!

2001-12-02 Thread Scott Shafer
, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _____ Do You Yahoo!? Get your free @yahoo.com addre

Re: Has anyone heard of "Mirror Accessible"?

2001-12-01 Thread Scott Shafer
Yeah, The CEO needs to be "anonymously" informed that he needs a CIO with a higher degree of intelligence and technical expertise. The current one is a waste of flesh. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]&

Re: Testing

2001-12-01 Thread Scott Shafer
I'm getting messages in random order (just got some initial posts from 3 days ago to already resolved threads), but other than that, I guess its OK... --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, Novem

Re: Snapshot Problems

2001-11-29 Thread Scott Shafer
According to Oracle, this is a > bug. Does someone know of a work-around? > > Jeff _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Siebel.

2001-11-28 Thread Scott Shafer
I seem to remember Ralph Kimball writing in one of his DW books that the RI and constraints should be enforced in the app layer as well. However I might be wrong (once this year isn't too bad, eh?) ;-P Scott Shafer San Antonio, TX Henry Poras wrote: > > That is probably true t

Re: Fwd: A problem

2001-11-21 Thread Scott Shafer
Try sumthin' like: EDATE=$(date +%C%y%m%d) FILENAME=name${EDATE}.dmp exp / file=${FILENAME} ... Do a 'man date' to see the different formatting options. HTH, Scott Shafer San Antonio, TX Jared Still wrote: > > -- Forwarded Message -- > D

Re: exp a big tablespace

2001-11-20 Thread Scott Shafer
BEWARE! There are some versions of the split command that only work with ASCII character files. Make sure your version works with binaries as well. --Scott > "Aponte, Tony" wrote: > > Here's a tip I mined many moons ago from I don't know where. It's a >

Re: set_sql_trace_in_session

2001-11-19 Thread Scott Shafer
h) - its worth it! Check bookpool and amazon... --Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 6:10 PM > Hi Bruce, > > I thought of that but we have many VER

Re: Are corrupt index_partitions marked as unusable?

2001-11-19 Thread Scott Shafer
Have you analyzed the indexes in question? Isn't there an 'analyze index validate' command? --Scott Shafer Converse, TX [EMAIL PROTECTED] wrote: > > We have some block corruption on indexes in a copy of a database that was > restored > to an alternate host? >

Load listener.log via sqlldr

2001-11-19 Thread David Scott
t the wheel. Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Scott INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-15 Thread Scott Shafer
; > > > companies are just cutting back to save money). The problem I > > see > > > > though is > > > > that companies seem to be trimming back too much. I'm starting > > to > > > > hear > > > > little rumours here and there

Re: hide password

2001-11-15 Thread Scott Shafer
Make the parfile readable only by the oracle user (or whatever user is running the export). Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 10:20 PM But (while perform

Re: Operating Systems

2001-11-15 Thread Scott Shafer
I found it quite stable running on a beefy compaq proliant with raid 5 arrays (can't remember allthe server details). Of course, this was compared to the other DGUX servers I had at the same site... YMMV, Scott Jan Pruner wrote: > > >From our root: > Don't use Solaris

Re: Move data from Oracle into Access

2001-11-15 Thread Scott Shafer
The simplified version: Connect access to oracle using ODBC and select from the oracle tables into access tables. --Scott > "Daiminger, Helmut" wrote: > > Hi! > > What would be the easiest way to dump out an Oracle table and move it > into Access? (approx. 100,

Re: Operating Systems

2001-11-14 Thread Scott Shafer
It does work good if you have a powerful enough server. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 2:30 PM If there are no issues with Solaris on Intel, I would be enclined to prefer

Re: Operating Systems

2001-11-14 Thread Scott Shafer
e > bean-counters would prefer to pay for something rather than use a free and > supported product. Very happy with the ease of admin and speed. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 11/14/01 01:12PM >>> > Linux or Solaris Intel. A

Re: Operating Systems

2001-11-14 Thread Scott Shafer
Yeah, what was I thinking? Must be too much blood in my tequila system... ;-) --S "HAWKINS, JAMES W [IT/1000]" wrote: > > Scott, > > NT? I think the habaneros and tequila have finally taken over... > > ;) > > Seriously, stay away from NT. I have th

Re: Disk Layout Document

2001-11-14 Thread Scott Shafer
Larry, There is some discussion of this in the "Designing and Tuning for Performance" docs at: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/ch20_io.htm#11672 URL will probably wrap. I'm sure this isn't exactly what you want, but its

Re: Operating Systems

2001-11-14 Thread Scott Shafer
Linux or Solaris Intel. And maybe (gods help me! ) NT? Scott Shafer San Antonio, TX Regina Harter wrote: > > Hi Guys, > > Our SA/DBA is considering dumping Unixware and moving to a different > OS. Sun is out for reasons that are not being shared with me, probably > becau

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-14 Thread Scott Shafer
ut while I have your attention: > > I've SEEN Scott and Jeff in the same room. Ladies, find those chastity > belts -;) > > --- Scott Shafer <[EMAIL PROTECTED]> wrote: > > Doh! Sorry for the oversite - lots on my mind lately. You're > > definitely invited,

Re: STATSPACK Info

2001-11-14 Thread Scott Shafer
Raj, I think there is a book devoted to Statspack if you search Amazon or Bookpool. Scott Shafer San Antonio, TX "Jamadagni, Rajendra" wrote: > > Hope the list is up ... this message just returned to me about half hour ago > ... > > Are there any docs available

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Scott Shafer
; of these companies looking to grow have been hit hard (and the bigger > > > > companies are just cutting back to save money). The problem I see > > > > though is > > > > that companies seem to be trimming back too much. I'm starting to > > > >

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Scott Shafer
es are just cutting back to save money). The problem I see > > > though is > > > that companies seem to be trimming back too much. I'm starting to > > > hear > > > little rumours here and there of companies going, "Maybe we shouldn't >

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Scott Shafer
, "Maybe we shouldn't > > have > > gotten rid of most of our support/operations people?" It's not bad > > here > > though...it'll pick back up again...and I agree it's a great place to > > live. > > > > Guvm'

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

2001-11-13 Thread Scott Shafer
much. I'm starting to hear > little rumours here and there of companies going, "Maybe we shouldn't have > gotten rid of most of our support/operations people?" It's not bad here > though...it'll pick back up again...and I agree it's a great place to liv

RE: 9i install on Win2K

2001-11-12 Thread Scott
ory on your server. 2. Copy the contents of the Oracle Server CD to the temporary directory created in step 1. 3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll. 4. Rename each copy of the symcjit.dll to symcjit.old. 5. Run the setup.exe from the \ins

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Description for

2001-11-12 Thread Scott Shafer
ild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001

Re: blowing out rollbacks on select statements?

2001-11-08 Thread Scott Shafer
We get this all the time when running an ETL process over DB links. Too much DML on the source table at the time of the extract. No there isn't supposed to be any DML during the night, but I have remote users who think that... Oh, heck, they don't think at all! Scott Shafer San A

Re: Arch configuration -- I/O stuck

2001-11-01 Thread Scott Shafer
Allright! Back to the OT list, Hannibal! We'll discuss where you stuck your log over there. --Scott "Mohan, Ross" wrote: > > LoL! > > I always advocate "stripping" when there is a stuck log. > > -Original Message- > Sent: Thur

Re: recover on different hardware

2001-11-01 Thread Scott Shafer
___ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services

Re: Oracle 7 documentation - Good One

2001-10-31 Thread Scott Shafer
Unfortunately, we are stuck with O7 for legacy apps. Hoping to go to 8i some time in the next few years, but I really don't have much hope... Scott Shafer San antonio, TX Deepak Thapliyal wrote: > > no offense.. just a sincere question. > > are people still using o7 out

Re: Root to connect as system

2001-10-29 Thread Scott Shafer
This is still a bad idea. It would be better for root to "su" to oracle and do anything it needs to do as the oracle user, i.e., su - oracle As root, no password will be required on most *nix flavors. Happy "su"'ing, Scott Shafer San Antonio, TX - Original

Re: Database link in the same DB

2001-10-25 Thread Scott Shafer
See my reply. It does help with testing certain processes in our development environment. --Scott > "Koivu, Lisa" wrote: > > Why on earth would you want to do that?? I mean I'm bored and all but > it hasn't occurred to me to do this! > > Lisa Koivu

Re: Database link in the same DB

2001-10-25 Thread Scott Shafer
0.1 is our localhost/loopback entry in /etc/hosts like so: 127.0.0.1 localhost loopback YMMV, Scott Shafer San Antonio, TX Aldi Barco wrote: > > Hi Listers, > > Can we create and use database link within the same database ? > I have created one but still error when us

Re: Sql not exists

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

Re:

2001-10-19 Thread Scott Shafer
of list ORACLE-L > > HELP _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network

Re: QUERY PROBLEM

2001-10-19 Thread Scott Canaan
t; (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer --

OT - Capturing long running SQL

2001-10-18 Thread Scott Shafer
t; "You scumbag! You maggot! You cheap fancy.." The Pogues! I thought I was the only one who liked "Fairy Tale of New York"... Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://

Re: ANYONE OWN "The Art of Computer Systems Performance Analysis

2001-09-25 Thread Scott Shafer
Hehehe. I'll look at it. Just got back from vacation. I know you missed me... Scott SATX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 25, 2001 6:45 PM > > LOL...ok...it's the subject-nam

Re: ANYONE OWN "The Art of Computer Systems Performance Analysis Tec

2001-09-25 Thread Scott Shafer
it? > > ...andIF SO."why?" > ELSE "why not?"/ > > end if; > > thanks! > > Ross _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see t

Re: Datatype

2001-09-25 Thread Scott Canaan
name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Pl

Re: Renaming GLOBAL_NAME

2001-09-17 Thread Scott Canaan
ng list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (

Re: Subtract 1 month from current date

2001-09-17 Thread Scott Canaan
pelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475

Re: RE: OPS instalation - pretty urgent

2001-09-16 Thread Scott
yes. Scott --- Cyril Thankappan <[EMAIL PROTECTED]> wrote: > > Hi > > I am sorry if someone has replied this > > But can someone PLEASE tell me > if IBM supports OPS > across their SP frames. > > or only support OPS WITHIN SINGLE SP frame? > >

RE: Lots and lots of redo logs

2001-09-14 Thread Scott Crabtree
er sectors. This is simply because of the circular shape of a disk drive." Scott -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: What happens if you lose the alert log?

2001-09-13 Thread Scott Canaan
> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you w

Re: SO UPSET FOR ALL AMERICANS

2001-09-12 Thread Scott Shafer
Karadeniz wrote: > >> I HOPE BEST WISHES FOR ALL PEOPLE IN AMERICA . > >> > >> WE TURKISH PEOPLE ARE ALL SORRY AND HOPE YOU HEALTH. > >> BUNYAMIN _____ Do You Yahoo!? Get your free @yahoo.com address at http:

Re: Life: is that really OT?

2001-09-12 Thread Scott Shafer
their actions. Anyone aiding or sheltering these terrorists (whoever they may be) is no longer a non-combatant. I hope the US government responds with wisdom, accuracy, and ruthless efficiency. Scott Shafer San Antonio, TX Greg Solomon wrote: > > My deepest sympathies to anyone who

Re: STOP THE PRESS!!

2001-09-11 Thread Scott Shafer
Wrong. 2+2=5 for very large values of 2. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 11, 2001 7:12 PM > Don't think it's that easy. Sometime 2+2 = 11 (base 3. sorry). Let's w

Re: STOP THE PRESS!!

2001-09-11 Thread Scott Shafer
A lot of prayers/hopes go out to the emergency personell and their families. Quite a few have paid the ultimate price trying to save lives... --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 11, 2001 9

Re: OT RE: Interesting News..

2001-09-11 Thread Scott Shafer
Guys/Gals, Lighten up on Ross. We've all said something that seemed clever at the time, but came across as entirely inappropriate. Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, Se

OT Re: STOP THE PRESS!!

2001-09-11 Thread Scott Shafer
ill not be tolerated in the future... Scott Shafer San Antonio, TX PS -- Everyone who can please donate blood ASAP. "Boivin, Patrice J" wrote: > > I am wondering whether this was an attack from outside, or from people like > Timothy McVeigh. > It seems to be awfully well co-

Re: OT RE: Interesting News..

2001-09-10 Thread Scott Shafer
Ross/Eric (does anyone still believe they are different people?), I recommend large quantities of red meat, halotestin, and ephedrine. And a nice Chianti. After all, if you are going for the rage, make the most of it!!! ;-) Scott Shafer, Anger Maximization and Hostility Specialist (aka, DBA

Re: DYNAMIC SQL

2001-09-09 Thread Scott Shafer
mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other informat

Re: [1] oerr

2001-09-07 Thread Scott Shafer
Might of been. Maybe not, as I only have HPUX servers at the current gig. Of course, if I can remember what happened yesterday, I'm doing well... Scott Shafer SATX [EMAIL PROTECTED] wrote: > > Jack, > > For some reason or another I asked a similar question a couple of

Re: How to change error messages?

2001-09-07 Thread Scott Shafer
LOL! Kirti. I'm thinking of trying out a binary editor on a TEST COPY of the oraus.msb file. It will at least be educational, whether successful or not. --Scott "Deshpande, Kirti" wrote: > > The oerr script will use the oraus.msg file. > However, Oracle kernel will

Re: How to change error messages?

2001-09-07 Thread Scott Shafer
Thanks. I didn't have database access when I sent the original message. Maybe if I can dig up a binary editor - this has too much "fun potential" to leave alone... --Scott "Jamadagni, Rajendra" wrote: > > Scott, > > I believe Oracle uses the binary v

RE: "Publishing" HTML

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

Re: Destination address unreachable

2001-09-06 Thread Scott Shafer
> Not sure if this applies all over, but the Marriot Residence Inn in St Louis > used to tap a keg (or two) for happy hour each night. Free beer and > horse-de-ovaries for guests - ah that was good livin'... > > --Scott Shafer > San Antonio, TX > > > ---

Re: How to change error messages?

2001-09-06 Thread Scott Shafer
ommend doing it unless its on a "play" system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, Septembe

Re: index in data tablespace ???

2001-09-06 Thread Scott Shafer
alter index rebuild tablespace ; --Scott Janet Linsy wrote: > > Hi all, > > I got bunch of indice reside in data tablespace. > What's an easy, safy way to move them into index > tablespace? > > Thank you. > > Janet ___

Re: OT - un-tar patchset

2001-09-06 Thread Scott Shafer
'man tar' at the unix command line should help. try putting the tar file on a different mount point and using: 'tar -xvf 8172_solaris_32_patchset.tar /oracle/app/oracle/product/8.1.7/patches/8.1.7.2' (without the quotes, of course). HTH, Scott Shafer San Antonio, TX &q

Re:

2001-09-06 Thread Scott Shafer
OK, but only for you. [EMAIL PROTECTED] wrote: > > SET DIGEST-L ORACLE? > > Scott Shafer > NO. > > [EMAIL PROTECTED] wrote: > > > > SET ORACLE-L DIGEST _ Do You Yahoo!? Get your free @yahoo.com

Re:

2001-09-06 Thread Scott Shafer
NO. [EMAIL PROTECTED] wrote: > > SET ORACLE-L DIGEST _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET:

Re: Oracle DBA Leader Needed in Beaumont, Texas..

2001-09-05 Thread Scott Shafer
He, he, he! I've been to Beaumont enough times to know I don't want to go again. Good fishing, though... Scott Shafer San Antonio, TX John Lewis wrote: > > As an ex-Texan, and related to many in the Orange-Beaumont-Port Arthur area, > I'll excuse mys

Re: Oracle DBA Leader Needed in Beaumont, Texas..

2001-09-05 Thread Scott Shafer
No thank you. Beware! Beaumont is the arm-pit of hell... --Scott OraStaff wrote: > > This company is located in Beaumont, Texas and needs an Oracle DBA team leader > to join its' I.T. staff. > Selected candidate must have leadership skills to lead a team of 4 or 5 > dev

RE: OT: Oracle DBA With Internet Experience Needed in Harrisburg, PA

2001-09-05 Thread Scott Graves
Fishing, Hunting, skiing, no traffic and quarter beers Sounds too good to be true. Scott > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Scott > Sent: Tuesday, September 04, 2001 7:31 PM > To: Multiple recipients of list ORACLE-L &

Re: OPS on a single machine ?

2001-09-04 Thread Scott
e can establish the communications between the nodes. Even if you want to install OPS an single node you still need the CM. Without the CM and OPS you cannot have 2 instances concurrently accessing the same disks. It doesn't matter whether the instances are on the same machine or not. Scott

Re: OPS on a single machine ?

2001-09-04 Thread Scott
he CM is supplied with Oracle on linux. Scott --- Stefan Jahnke <[EMAIL PROTECTED]> wrote: > Hi, > > I was wondering if it is possible to set up OPS on a > single machine. > Maybe like this: > 1 disk as a raw device, then set up an instance to > use the raw devic

RE: OT: Oracle DBA With Internet Experience Needed in Harrisburg, PA

2001-09-04 Thread Scott
time in the Bars in Bozeman. I spent many a Friday in the Rockin-R drinking quarter beers. If you like the outdoors, peace and quite and no traffic and you like to drink Bozeman is great place. Scott --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > That's not unusual if yo

Re: Fail over with ODBC and standard edition

2001-09-04 Thread Scott
driver, I never tested it because I don't have any apps that use ODBC. Scott --- "Shaw, John B" <[EMAIL PROTECTED]> wrote: > Do you need to have Enterprise server for the odbc > fail over to work. I have > standard edition on a MS cluster and the odbc > conn

Re: How to find Procs run?

2001-08-31 Thread Scott Shafer
fast ;-P) Scott Shafer San Antonio, TX Scott Canaan wrote: > > First, I will say that I will contribute something to keep this list > alive. I have benefitted way more from the list than I have given. > With that said, I have a request from a customer to do a weekly >

<    1   2   3   4   5   6   7   >