RE: what happens if a remove a job that is running?

2003-08-14 Thread Scott . Shafer
Yes. If you really want to kill the job, the graceful way is to break it first (dbms_job.broken) and then remove it (dbms_job.remove). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 10:00

RE: Oracle SCN Question

2003-07-31 Thread Scott . Shafer
I thought Bass and Rap were synonymous? Or am I out of touch with the current music scene? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 4:24 PM To: Multiple recipients of list ORACLE-L

RE: STATSPACK in Oracle 8.1.6.0

2003-07-18 Thread Scott . Shafer
Metalink, Technet, Google, or at the scripts themselves (which all have explanatory headers). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Richard Foote [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:34 AM To: Multiple recipients of list ORACLE-L

RE: Recent reports on outages caused by DB2 and 9iRAC issues

2003-07-18 Thread Scott . Shafer
That's funny, I thought SAC's motto was SAC eats it's young. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Goulet, Dick [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recent reports

RE: Interview Questions for a Unix Solaris System Admin

2003-07-15 Thread Scott . Shafer
question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message

RE: Interview Questions for a Unix Solaris System Admin

2003-07-15 Thread Scott . Shafer
You only spend time on the technical stuff if they pass this round. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview

RE: log for transaction

2003-06-24 Thread Scott . Shafer
We use a similiar method which involves inserting periodic rows into a log table, which is dumped to a file at end-of-job. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:05 PM

RE: Re: Passwords and authentication

2003-06-19 Thread Scott . Shafer
HIPAA Auditing for Oracle Database Security Nice. Well, Arup, Get to publishing! ;-) --Scott -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 3:19 PM http://www.dba-oracle.com/bp/bp_titles.htm Look about in the middle of the page. -Original

RE: copy a datafile to a raw device

2003-06-19 Thread Scott . Shafer
You left out, ...and why is there a goat in the corner? Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the

RE: World premier performance of the BAARF party logo

2003-06-12 Thread Scott . Shafer
And the satanic redeye is a nice effect for a dba. Could this be the start of oracle pr0n? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/03 6:19 PM Hey, Who cares about that RAID thing. Whose the cutie in the pictures - hehe. -Original Message-

RE: why SAN ? why not external storage ?

2003-03-14 Thread Scott . Shafer
Oh, Gods forbid the sysadmins would have to gulp do their job... HAHAHAHAHA!!! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject

RE: RE: why SAN ? why not external storage ?

2003-03-14 Thread Scott . Shafer
All of the places I've worked its been sysadmins fat-fingering that has hosed or cross mounted disks. Then again, we've never had EMC... HP arrays are enough trouble. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent

RE: POLL: Database to DBA ratio

2003-03-11 Thread Scott . Shafer
139 remote production servers/instances (30 are large to VLDB, the rest small), 5 development instances, 1 9iAS test instance, 3 dba's. Mostly reporting with batch ETL jobs run nightly. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Robin Ilardi [SMTP:[EMAIL

RE: Teradata baned from IOUG???

2003-02-19 Thread Scott . Shafer
Soon you too will be assimilated. The TUSC Collective will add your distinctiveness to its own. --Seven of Nine-Hundred Ninety-Nine -Original Message- From: Daniel W. Fink [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:59 PM To: Multiple recipients of list ORACLE-L

RE: AIX Oracle 9.2

2003-02-13 Thread Scott . Shafer
How about relink all from the $OH/bin directory? Or is this utility gone in 9i? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Tim Gorman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Subject

RE: STATSPACK

2003-01-29 Thread Scott . Shafer
See: http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html and related articles. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:49 PM To: Multiple recipients

RE: AUTORAID and VA7100 disk arrays for rp7400

2003-01-23 Thread Scott . Shafer
We are using the VA7100's and VA7400's. They are several orders of magnitude faster than the old 12H AutoRAID arrays if configured properly. I'm no expert, but I know the VA7X00's combine some caching technology with faster IO channels. Scott Shafer San Antonio, TX 210.581.6217 -Original

RE: Slightly OT - Who would you take with you...

2002-11-26 Thread Scott . Shafer
Well, there's Schlitz, King Cobra, Olde English, Mickey's Big Mouth, et al. Single Malt Liquor at its finest! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Hand, Michael T [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 12:17 PM To: Multiple

RE: Oracle you have just received a card from .

2002-11-25 Thread Scott . Shafer
What is this, flippin' Virii Day or what? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Jay Earle (DBA) [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Oracle you have just received

RE: Data Purging Strategy

2002-11-08 Thread Scott . Shafer
Burnt mud? Isn't that all scotch? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Steve McClure [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Data Purging Strategy Sherry

RE: Installing iAS 9.0.2.0.1

2002-10-29 Thread Scott . Shafer
No, 1.0.2 is a leaner product - no infrastructure required. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Installing iAS

RE: Installing iAS 9.0.2.0.1

2002-10-25 Thread Scott . Shafer
Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 25, 2002 2:34 PM To: Multiple

RE: CodeNotes for Oracle9i...

2002-10-15 Thread Scott . Shafer
Yeah, hearing the Goddess describe massaging the 'data' in sultry detail would surely be a distraction... grin Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Connor McDonald [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 5:03 AM To: Multiple

RE: Oracle list for developers ??

2002-10-11 Thread Scott . Shafer
Forgot the smiley ;-) - it was a rough day. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle list

RE: Thanks - Oracle list for developers ??

2002-10-11 Thread Scott . Shafer
Who'd a thunk it? LOL! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Johnston, Tim [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Thanks - Oracle list for developers ?? Thanks

RE: cpu on AIX

2002-10-10 Thread Scott . Shafer
an idea... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Henry Poras [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: cpu on AIX Dennis, Users are complaining, and at least

RE: Oracle list for developers ??

2002-10-10 Thread Scott . Shafer
No there isn't. And a google search certainly wouldn't turn up any. Give up the quest and read your manuals. That is all. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Droogendyk, Harry [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:44 PM

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
echo $ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
of SIDs to perform ops on multiple db's if needed, i.e., sqlplus user@current_sid ... exit echo $current_sid logfile in your script. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Fink, Dan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:34 PM

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
Or a here document that allows you to iterate through a list of SID's if necessary. Env variables don't have to be static on *nix... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:44

RE: RE: MIcrosoft Blackmail

2002-09-26 Thread Scott . Shafer
Then there's OpenOffice. Very nice. http://www.openoffice.org - I use it regularly and have had no problems. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:28 PM To: Multiple

RE: How long did job run?

2002-09-05 Thread Scott . Shafer
) NLS_ENV VARCHAR2(4000) MISC_ENV RAW(32) INSTANCE NUMBER SQL You need to look more carefully. There is a column called LAST_DATE. Scott Shafer San Antonio, TX 210.581.6217 -Original Message

RE: ssh client for Windoze

2002-09-04 Thread Scott . Shafer
TeraTerm (does not support ssh2) Hummingbird Reflection PuTTY (current fave) Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject

RE: Temp problem

2002-09-04 Thread Scott . Shafer
add space to the temp tablespace. ALTER TABLESPACE... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Peter R [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Subject: Temp problem Hi

RE: Creating Scott/Tiger

2002-08-30 Thread Scott . Shafer
13 2001 demodrop.sql Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Jonathan Gennick [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Subject: Creating Scott/Tiger I need to create the Scott/Tiger

RE: basic Unix question ???

2002-08-29 Thread Scott . Shafer
uname -a will give you OS version and machine type on most *nixes. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Janet Linsy [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 6:10 PM To: Multiple recipients of list ORACLE-L Subject: basic Unix

RE: Unix question: how to display SID and path in prompt

2002-08-27 Thread Scott . Shafer
Obviously. If you had worked on VMS, why would you want to emulate it? evil grin Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Subject

RE: Unix question: how to display SID and path in prompt

2002-08-27 Thread Scott . Shafer
Oh I agree - it was a rock solid platform, but the syntax was annoying and tedious at best. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:13 AM To: Multiple recipients of list ORACLE-L

RE: Cannot start database (already running)

2002-08-21 Thread Scott . Shafer
Or go into svrmgrl, connect internal, issue a shutdown abort, then startup. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Hately Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE

RE: SSO - and nothing else

2002-08-15 Thread Scott . Shafer
Nope. To get SSO in 9.0.2 you have to install the _entire_ Infrastructure. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Subject

RE: PL/SQL Editor.

2002-08-15 Thread Scott . Shafer
vi or vim. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Place for oracle [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject: PL/SQL Editor. Hello, I need a nice PL/SQL editor any

RE: RE: PL/SQL Editor.

2002-08-15 Thread Scott . Shafer
You should see me trying to type a word document. vi command syntax doesn't go over to well... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 11:43 AM To: [EMAIL PROTECTED]; Multiple

RE: RE: PL/SQL Editor.

2002-08-15 Thread Scott . Shafer
Hehehe, this'll really get you - I take 1 part command-line SCCS for versioning to 2 parts vi for editing. Serve on the rocks. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:51 PM

RE: Oracle9i Installation Error

2002-08-13 Thread Scott . Shafer
to ORACLE_HOME from your environment (PATH, LD_LIBRARY_PATH, etc). Hopefully this gives you some ideas to try. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 10:35 AM To: Multiple recipients of list

RE: Apple rack-mounted servers

2002-08-13 Thread Scott . Shafer
mach kernel, IIRC. The old NeXTStep unix. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: Apple rack-mounted servers

RE: Apple rack-mounted servers

2002-08-13 Thread Scott . Shafer
Cool. Sound like it may be worth checking out, at least for home use. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE

RE: missed Anjo's webcast..

2002-08-09 Thread Scott . Shafer
Ditto. Put me down for at least one copy! Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: missed Anjo's webcast

RE: Ids and passwords for application users

2002-07-29 Thread Scott . Shafer
--Create roles for the possible user types. --Grant permissions to the roles. --Create induhvidual lusers in the database. --Assign the appropriate role to the appopriate luser. Anything else can quickly become a maintenance/monitoring nightmare. This is why roles were rolled out. Scott Shafer

RE: Myers-Briggs

2002-07-23 Thread Scott . Shafer
The C is for Sales-Critter. The High part? Well, remember, the rule is: puff, puff, pass. Don't bogart the good stuff, 'kay? ;-) Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:28 AM

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
Good luck. The smooth install is at a grinding halt at the moment, with half the components throwing java exceptions all over the place. Did I mention java sucks? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
Gene, I dunno anymore. 9.0.2 came out in May '02, according to the cd. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: A DBA

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE

RE: Cognos

2002-07-18 Thread Scott . Shafer
Conos cube builds = database performance killer, especially if users are allowed to build data cubes on the fly. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Weatherman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 11:08 AM To: Multiple

RE: A DBA looks at OAS

2002-07-17 Thread Scott . Shafer
Thanks, mkb. I'm installing 9.0.2 now on HPUX. Good info. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: mkb [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: A DBA looks at OAS

RE: RE: (Fwd/2)

2002-07-16 Thread Scott . Shafer
With any luck, they'll all have the privilege of meeting Ray-Ray on Cell Block D. Maybe we should move this to OT, eh? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:59 PM To: Multiple

RE: 9iAS Application Server: Win2k vs. Linux?

2002-07-16 Thread Scott . Shafer
I'm fighting with 9iAS 9.0.2 on HP at the moment. This is one lng install on an underpowered machine (2 cpu's, 2G mem). Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 2:45 PM

RE: runInstaller

2002-07-10 Thread Scott . Shafer
*** inline... -Original Message- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] All this ranting is nice but consider the following: 1) You do not install oracle on a server so much. In fact, in our shop this is done by the technical people, not the DBA. The DBA got the machine

RE: runInstaller

2002-07-10 Thread Scott . Shafer
Yeah! Andy/Jared. I'm pimpin' you guy's Perl stuff pretty hard. How 'bout some scoobie-snacks for yer boyz? grin Scott Shafer San Antonio, TX -Original Message- From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] 2/3) Yes, Java is everywhere for a reason. But real cross platform

runInstaller

2002-07-09 Thread Scott . Shafer
Thankyou. I feel better about hating 9iAS now. Scott Shafer San Antonio, TX 210-581-6217 -- 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

RE: runInstaller

2002-07-09 Thread Scott . Shafer
, etc. OEM 1.6 still had mostly Tcl/TK pieces and parts and ran fast and reliably. Not so for OEM 2.x. Give me a command line back for installs. That's not too much to ask, right? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Ray Stell [SMTP:[EMAIL PROTECTED

RE: 2003 IOUG Meeting

2002-07-08 Thread Scott . Shafer
If you have the money... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 11:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: 2003 IOUG Meeting I NEVER get to see every

RE: Oracle Applications Development Database Refresh

2002-07-08 Thread Scott . Shafer
Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581

RE: 2003 IOUG Meeting

2002-07-08 Thread Scott . Shafer
That wasn't a dig at anyone, Rachel. It may be worth it, but if you don't have the means to begin with, you can't very well write it off. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:19

RE: Oracle Applications Development Database Refresh

2002-07-08 Thread Scott . Shafer
Gotchya. Thanks, that's why I wasn't sure what had to be done there. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle

RE: Oracle Applications Development Database Refresh

2002-07-08 Thread Scott . Shafer
My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL

RE: Count rows in textfile

2002-07-03 Thread Scott . Shafer
Roland, Just go ahead and open the file. You know you want to. We both know that it would be soo satisfying to just take a peek inside, right? That way you can count lines. I'm sure you can handle up to ~20 or so with your zipper up, right? No one needs to know... Scott Shafer San

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
And then you could have a background like mine which made it rather painful... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
Don't. Its not worth the hassle. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Michael Cupp [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle DBA with TS SCI Clearance Needed

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
Get a job requiring the clearance, either as a direct government employee or as a contractor. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:39 PM To: Multiple recipients of list ORACLE-L

RE: Oracle 9.0.1.3 or 9.2.0?

2002-06-14 Thread Scott . Shafer
Yep. We just upgraded to 8.1.7.x. v9.x isn't even on the radar screen, yet... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject

RE: off topic: anyone form Amsterdam, Holland / other major europ

2002-06-11 Thread Scott . Shafer
Cost of living will largely depend on how much time you spend in the Red Light District... ;-) Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 5:13 AM To: Multiple recipients of list ORACLE-L

RE: OEM

2002-06-10 Thread Scott . Shafer
http://www.oracle.com Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: OEM Hi Does somone tell me how to check price

RE: Sqlloader

2002-06-06 Thread Scott . Shafer
Typing on a keyboard can accomplish this. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Sqlloader Hallo, Anyone whom

RE: Sqlloader

2002-06-06 Thread Scott . Shafer
Then place your thumb squarely atop the fine manual... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Suzy Vordos [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Subject: Re: Sqlloader First

RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-31 Thread Scott . Shafer
So that's why the Gods died out... Hehehe... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Weaver, Walt [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

RE: 64 BIT ORACLE FOR SOLARIS 64 BIT

2002-05-24 Thread Scott . Shafer
http://metalink.oracle.com click on Patches. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Hamid Alavi [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 5:50 PM To: Multiple recipients of list ORACLE-L Subject: 64 BIT ORACLE FOR SOLARIS 64 BIT

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Scott . Shafer
it. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Xie, Tom [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Subject: How to drop a datafile from a tablespace quickly Dear gurus: I just added a data

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Scott . Shafer
serious problems in the future. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to drop a datafile from a tablespace

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Scott . Shafer
Exactly my point. The answer is 42. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to drop a datafile from

RE: Deadlock ORA-60

2002-05-15 Thread Scott . Shafer
kick the power cable to your server... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: Deadlock ORA-60 Hi I am getting ORA

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Scott . Shafer
I did not know that. Didn't Douglas Adams recently adjourn to the right hand of Hubble, there to claim his 42 virgins in Paradise? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Tim Gorman [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:38 PM

RE: Deadlock ORA-60

2002-05-15 Thread Scott . Shafer
Bad week. Extra cranky today. You do have to admit, it would solve the problem... --Scott -Original Message- From: Ray Stell [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Deadlock ORA-60 On Wed, May

RE: Datawarehousing help

2002-05-07 Thread Scott . Shafer
Come on, Rachel! Zero Experence has never stopped anyone from publishing. Just look at academia and MCSE study guides... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 8:19 AM

RE: DB Size

2002-05-03 Thread Scott . Shafer
Physical size (disk) or logical size (bytes of actual data)? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Simon Waibale [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: DB Size Hi all

RE: Can't Connect to DB

2002-05-02 Thread Scott . Shafer
Start the database and listener services. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Subject: Can't Connect to DB Oracle 9i on XP

RE: SIMPLE QUESTION

2002-05-01 Thread Scott . Shafer
What OS? Oracle version? Oh yeah, stop SHOUTING. We can hear you just fine here on the Good Ship Lollipop. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Hamid Alavi [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:18 PM To: Multiple recipients

RE: SQL*NET VERSION

2002-04-29 Thread Scott . Shafer
You can't unless you read the documentation that came with your database. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:13 AM To: Multiple recipients of list ORACLE-L Subject: SQL*NET

RE: PATCH?

2002-04-29 Thread Scott . Shafer
At least you got it. Tell Brian to squeeze... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Subject: PATCH? How to give birth

RE: Unix - Writing stderr to a file and stdout

2002-04-28 Thread Scott . Shafer
command 21 logfile Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 1:31 PM To: Multiple recipients of list ORACLE-L Subject: Unix - Writing stderr to a file and stdout Hi

RE: How come I don't get postings

2002-04-26 Thread Scott . Shafer
Please send jpgs. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 8:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: How come I don't get postings I can not see you

RE: How come I don't get postings

2002-04-26 Thread Scott . Shafer
You ain't popped out that litter yet? Get to walking, girl! Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Subject: OT: How come I don't

RE: AUDIT_ACTIONS

2002-04-25 Thread Scott . Shafer
read ?/rdbms/admin/cataudit.sql insert into audit_actions values (102, 'LOGOFF BY CLEANUP'); insert into audit_actions values (103, 'SESSION REC'); insert into audit_actions values (104, 'SYSTEM AUDIT'); Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Charlie

RE: single clustered tables

2002-04-25 Thread Scott . Shafer
Objection 1) Most Oracle docs recommend: don't store data in clusters if it's going to be updated frequently. Updating clustered tables is bad. If its being updated, its not a true data warehouse. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From

RE: AUDIT_ACTIONS

2002-04-25 Thread Scott . Shafer
And Note:99137.1 details how to drill down through system_privilege_map, et al. to find out what's going on. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Godlewski, Melissa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 4:21 PM To: Multiple

RE: single clustered tables

2002-04-25 Thread Scott . Shafer
I'm going with the Kimball-ian definition of a DW showing changes over time (temporal). You don't want to go back and update historical data - unless you're Enron grin - as this will skew results and trend analysis. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From

RE: Cronjob

2002-04-24 Thread Scott . Shafer
man kill Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Subject: Cronjob Anyone whom can tell me how to delete a job

RE: Cronjob

2002-04-24 Thread Scott . Shafer
Come on, Jared, its more fun to: crontab /dev/null Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob

RE: Materilized view?

2002-04-23 Thread Scott . Shafer
Beer is a very good refreshment option. Seriously, have you configured your job_queue_processes parameter in your init.ora? Are there any ora_snpx_SID processes running for your database? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL

RE: executing a stored procedure at a certain time

2002-04-19 Thread Scott . Shafer
dbms_job. See the SQL guide for your particular version of Oracle at http://technet.oracle.com Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Nelson Flores [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:53 PM To: Multiple recipients of list

RE: Number of CPUs vs. Speed of CPUs

2002-04-18 Thread Scott . Shafer
How many CPU's will the box hold? This # should be your requirement, as you can always negotiate down... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:58 AM To: Multiple recipients

  1   2   3   4   >