RE: Wow, Man, Flashbacks!

2003-11-07 Thread Steve McClure
ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Your new book

2003-10-22 Thread Steve McClure
use without relying too heavilly on my mathematical background. I don't dare say I am confident of it though, I still remember that 32. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services

RE: Solaris /etc/system values for Oracle8i

2003-09-29 Thread Steve McClure
did ask about swap size in Tanel's case, our swap slice is 2GB we rarely use more than 500MB of swap. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Monday, September 29, 2003 7:35 AM To: Multiple recipients of list ORACLE-L Tanel: How large is the swap file? For Oracle

log miner views contain object IDs and HEX values

2003-09-19 Thread Steve McClure
://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: log miner views contain object IDs and HEX values

2003-09-19 Thread Steve McClure
OK seems I must have fat fingered something when I typed in my dictionary location in start_logmnr. Odd though I saw no errors. -Original Message- Steve McClure Sent: Friday, September 19, 2003 1:25 PM To: Multiple recipients of list ORACLE-L OK my first usage of log miner seemed

is this a good practice...pl/sql question

2003-09-17 Thread Steve McClure
I am wondering what others think. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: is this a good practice...pl/sql question

2003-09-17 Thread Steve McClure
it an elevated postition. Sorry for rambling on and on etc. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Dataguard Benchmark

2003-09-16 Thread Steve McClure
described above. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Niall LitchfieldSent: Tuesday, September 16, 2003 1:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Dataguard Benchmark Just to add to Mladen's

RE: Oracle Masters exam

2003-09-05 Thread Steve McClure
for the education requirements is pretty darned nice. Not to mention the Solaris system administrator certification, that self study guide just arrived the other day, and the Veritas backup administrator certification stuff I got the other day. This is getting to be like college. Steve McClure

RE: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-05 Thread Steve McClure
I will try to be there as well. Possibly two of us, Alec Macdonell who lurks about this list as well. Steve McClure -Original Message- John Kanagaraj Sent: Wednesday, September 03, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Hi all, We talked about this earlier and I wanted

RE: How to keep root out?

2003-08-28 Thread Steve McClure
being extra paranioid. I certainly wasn't aware my current directory was /, but it was. Luckilly the previous ,always crafty, sysadm had the foresight to place a file named -i in the directory. Really saved my bacon when I was prompted for confirmation. Steve McClure -- Please see

RE: convert number to word ???

2003-08-22 Thread Steve McClure
this question. It is from the ask tom site. It worked perfectly, and the use of to_date was brilliant and elegant. Seeing routines like that reminds me of just how far I have to go to be good at what I do. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: Text file from store procedure

2003-08-20 Thread Steve McClure
: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: OT -- Boston Globe job listings

2003-08-14 Thread Steve McClure
THAT much money in practice. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7

2003-08-14 Thread Steve McClure
exams, I read and accepted that NO hints were available if you were using the RULE based optimizer. I guess I need to fire up my test instance later today, and figure this out. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL

Oracle World anyone?

2003-08-14 Thread Steve McClure
Just completed the registration, and was wondering how much company I was going to have there. Who else has plans to attend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: COMMIT's within cursor for loops

2003-06-26 Thread Steve McClure
on the record set, you will get an error indicating an invalid cursor. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I prefer to create an inner block using BEGIN and END inside the loop. This isolates

RE: World premier performance of the BAARF party logo

2003-06-12 Thread Steve McClure
l it works. I will just have to be content knowingas good as it isit could be better yet. Steve McClure

RE: Sun to Linux on Dell

2003-06-09 Thread Steve McClure
that if they are gung ho regarding Linux, Sun now supports Linux on their hardware. I feel like I should have started this response Hello my name is Steve McClure and I am a RAC on Linux doubter Really I have felt this way for a long time. Maybe the time will come when I see it as a great idea

RE: Sun to Linux on Dell

2003-06-09 Thread Steve McClure
://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: Sun to Linux on Dell

2003-06-09 Thread Steve McClure
Ah much more reasonable. I can't believe I typed the word licensers -- I am guessing licensees was what I was going for Steve McClure Oracle Collaboration Server (Suite?) is licensed per-mailbox user $60 per user...lets see Oracle claims we have 80,000 users...(not including the infinite

RE: Interesting!

2003-06-04 Thread Steve McClure
think this was the first time I noted Jared's annoying habit of being right Steve McClure -Original Message- Waleed Sent: Tuesday, June 03, 2003 4:10 PM To: Multiple recipients of list ORACLE-L I've just discovered this, never thought if it was possible or not. Just wanted to share

RE: RMAN - Remote vs Local Backups

2003-05-30 Thread Steve McClure
Just a thought. Possibly to assist in recovery of the database box. If you have a complete media failure on the DB host, you greatly simplify the recovery process if your RMAN database is somewhere safe. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: which util do I use to see oracle's execution plan?

2003-05-29 Thread Steve McClure
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

what did I miss? -- nologging generating redo

2003-03-20 Thread Steve McClure
was really done, except I have to manually transfer all those archived logs. I am just wondering what I missed. Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Standby errors

2003-03-14 Thread Steve McClure
. Of course if you can't recover your standby it will have to be resynched as well. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

9IAS connections to database not resolving

2003-03-13 Thread Steve McClure
sessions. Sorry for the long tale, but I am hoping someone else out there has run into this before. Our forms/reports configuration is way to generic for us to be the first ones to hit this. Thanks in advance, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

investigating database lockup

2003-01-30 Thread Steve McClure
while the sessions were active. I am soliciting actively for any Hints, Tips, or Ideas you may have, Thanks, Steve McClure

RE: investigating database lockup

2003-01-30 Thread Steve McClure
ew deletes throughout the database, so I can't see where that would be affecting any of our tables let alonecontribute totying up the entire database. I do appreciate the help, If you would like more specific answers please let me know and I will respond "off list" Th

RE: Need help Reformatting output

2002-12-13 Thread Steve McClure
through it to display the output via utl_file or somesuch. Actually if you are familiar with perl you could use a similar algorithm, and the resulting code would likely be cleaner. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf

RE: archiving redo logs

2002-12-10 Thread Steve McClure
while my production system is not scheduled for upgrade till the new year. I will of course backup the database and do a complete failover/activation test before deciding whether to maintain the OS difference for even a month or so. Steve McClure -Original Message-From: [EMAIL P

RE: archiving redo logs

2002-12-10 Thread Steve McClure
by specifying log_archive_dest_2='nfs_mounted_remote_filesystem'. P.S. if you are not comfortable with perl or shell scripting, and are working with Oracle on UNIX, get comfortable with perl or shell scripting. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

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

2002-11-26 Thread Steve McClure
And everything I've learned about single malts, I've learned from this list. And save in my Teetotaller folder ;) This post is not near off topic enough...please forward this folder Steve McClure -Original Message- Michael T Sent: Tuesday, November 26, 2002 10:17 AM To: Multiple

RE: redo log file setup with mirrored drives

2002-11-26 Thread Steve McClure
of Oracle database design. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: OEM Config Assistant

2002-11-22 Thread Steve McClure
the password ASAP, as it is a well known security loophole. Steve McClure -Original Message- Sardina Sent: Friday, November 22, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Using OEM Configuration Assistant 2.2, I tried to set up a Management Server/repository, etc. and through

RE: OEM Config Assistant

2002-11-22 Thread Steve McClure
The username password you use to login to OEM defaults to sysman/sysman. I just reread my response, and saw I botched the default password. The password is actually oem_temp. Steve McClure -Original Message- Sardina Sent: Friday, November 22, 2002 11:59 AM To: Multiple recipients

RE: opinions on SAN devices for Oracle

2002-11-20 Thread Steve McClure
. That last sentence may have sounded like a complaint, it wasn't, well maybe I am complaining about losing the configuration battle, but I am a fan of the product. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 10:50 AM To: Multiple recipients of list

converting to the cost based optimizer

2002-11-19 Thread Steve McClure
to cause us troubles when switching to CBO. We have been on 8i since April of this year, and I am just now starting to gather information on the inner workings of the CBO. I know it is where I want to be, I am just looking to see how painful/painless the transition will be. Steve McClure -- Please

RE: Data Purging Strategy

2002-11-06 Thread Steve McClure
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve

RE: Get together at OOW

2002-10-28 Thread Steve McClure
It looks like I will be attending this year pending upper management balking at the registration fee. As for getting together, I think that would be great, Chevy's is great as well, In fact Tuesday evening looks great too. So how big a party does that make? Count me in. Steve McClure

RE: Failed to archive log....

2002-10-03 Thread Steve McClure
-- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: Backups

2002-10-03 Thread Steve McClure
database. Steve McClure 60% certified and counting -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Markham, RichardSent: Thursday, October 03, 2002 11:03 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Backups It would be interesting to see

RE: Lost ofall redo logs

2002-09-20 Thread Steve McClure
://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

mixed case text

2002-09-11 Thread Steve McClure
reports that require Proper text. So am I a dinosaur? Maybe it is because I am not writing the reports that are complicated by my decision to upper() everything while loading. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED

RE: More on the OCP priceing

2002-07-12 Thread Steve McClure
Am I missing something about the OCP program? The new required class is only required for the new 'Oracle Certified Master' Certification. You can still obtain OCP certification without taking any classes direct from Oracle, right? Steve McClure -- Please see the official ORACLE-L FAQ

RE: Alternative to Crystal Reports

2002-06-20 Thread Steve McClure
thing is that the new client is a large one, so my company will actually be able to invest in a nicer product. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Database backup question.

2002-05-24 Thread Steve McClure
of for switching between modes would be to avoid excessive archivalresulting from very large processes. If you have room to archive logs you should consider leaving your DB in archivelog mode.Your odds of having a satisfying recovery scenario are greatly improved that way. Steve McClure

RE: Database backup question.Thank You

2002-05-24 Thread Steve McClure
you check into Rama Veluri's "Oracle Backup and Recovery Handbook". You should at least refer to the Oracle Backup and Recovery guide. Good Luck, Steve McCLure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Meomeo NguyenSent: Friday, Ma

RE: pl/sql is INTERPRETED?

2002-05-02 Thread Steve McClure
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: WHich Unix command

2002-04-29 Thread Steve McClure
I suggest looking for large directories, and then follow up from there. You should look at the man page on du. That should do the trick. Steve McClure -Original Message- Sent: Monday, April 29, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Hi Which unix command(On Solaris

RE: Cronjob

2002-04-24 Thread Steve McClure
. Write the crontab to a file(crontab -l cronfile), edit it, and reload it (crontab cronfile). Nuke the site from orbit...It's the only way to be sure Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City

RE: standby database problem ???

2002-04-10 Thread Steve McClure
a log switch the log will be archived, and your standby database will recover without errors. Steve McClure -Original Message- Sent: Tuesday, April 09, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Hi, I created a primary and a standby database. Both are 9i on Win2000, the same

RE: Oracle Licensing - Concurrent users

2002-02-20 Thread Steve McClure
. Steve McClure -Original Message- Sent: Wednesday, February 20, 2002 9:30 AM To: Multiple recipients of list ORACLE-L Adary - Wow that is not good! Has anyone else encountered this situation? Does the licensing fee have a name? Any indication if it differs between US and non-US licensing

RE: Oracle Licensing - Concurrent users

2002-02-20 Thread Steve McClure
pharmacies, we would require over 50,000 named users. Steve McClure -Original Message- Chris Sent: Wednesday, February 20, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it was Oracle telling you that, it was the sales guy trying to get his vacation paid

RE: Oracle Licensing - Concurrent users

2002-02-19 Thread Steve McClure
learn was that Oracle will not credit any of your previous license payments. So we were able to retain them. We have 800 processor units that can be used to run a database or a forms/reports server. I don't know how or if the concurrent user licenses would be retained. Steve McClure -Original

RE: Re[2]: NOHUP SQLPLUS

2002-02-04 Thread Steve McClure
for this kind of thing. Also essential if you are dialing in from home under any circumstance. If your connection drops you just telnet back in, and reattach to your screen session exactly where you were when you dropped. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Monday

RE: How to use a package variable in pkg1 inside of package pkg2

2002-01-25 Thread Steve McClure
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Standby database foible

2002-01-24 Thread Steve McClure
I quoted above. In writing this I am pretty sure that I screwed myself up by issuing a 'shutdown normal' after my first mount attempt failed, but I figured I would go ahead and send this off to the list anyway. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve

Mirroring REDO logs to an nfs drive

2002-01-24 Thread Steve McClure
for MAXLOGFILES and MAXLOGMEMBERS. Where can I find these parameters? I was sure I would find them in v$parameter, but they were not there. Thanks for any response, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED

RE: Databases on Solaris: Online Forum Jan. 22-28

2002-01-24 Thread Steve McClure
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services

RE: creating a procedure

2002-01-23 Thread Steve McClure
anything more than compile. You need to look into The Oracle Docs on PL/SQL. Because while you might have created a procedure, it isn't very procedural. Steve McCLure -Original Message- Sent: Wednesday, January 23, 2002 3:20 PM To: Multiple recipients of list ORACLE-L I want to create

RE: RE: HP vs SUN for a UNIX box

2002-01-21 Thread Steve McClure
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: smtp via PL/SQL

2002-01-18 Thread Steve McClure
there. Thanks again, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

smtp via PL/SQL

2002-01-17 Thread Steve McClure
recommend a book or white paper on implementing 'email' from within an Oracle database? I have downloaded some sample code from Orafaq, and actually gotten it working on our db. I would just like to actually understand what I am doing, and expand on what we have. Steve McClure -- Please see

RE: TOAD Software???

2002-01-15 Thread Steve McClure
to take a trip. Well at least a drive to Liqour Store. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: TOAD Software???

2002-01-14 Thread Steve McClure
tools. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

'bug' with describe command

2002-01-10 Thread Steve McClure
. Any chance any of you have run across this in the past? I am hoping a patch exists, because 8.1.6 is the final release for my OS platform. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Oracle Future??? - from the darkside

2002-01-08 Thread Steve McClure
Title: Oracle Future??? For God's sake sell your stock!! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: Tuesday, January 08, 2002 8:51 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Future??? - from the

cannot update or edit in a view -- question

2002-01-07 Thread Steve McClure
conversion they are receiving the Cannot update or edit from a view error message. I haven't gotten the error number yet. In fact that is my next step. If I can identify the exact error message, perhaps I can rtfm. Thanks in advance for any responses. Steve McClure Duhveloper slowly evolving

RE: Centralized Alert Log Monitoring

2002-01-07 Thread Steve McClure
realize that we are actually not that far off in terms of concept. Except I bet your perl is much more ready for primetime than mine. As usual I employed brute force as often as possible. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Monday, January 07, 2002 12:35 PM To: Multiple

RE: cannot update or edit in a view -- question

2002-01-07 Thread Steve McClure
that the user can duplicate the error, and until then I am considering this unrelated to yesterday's conversion. So Thank you for any replies so far, but I would now say that this is a non issue for now. Thanks again, Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto

RE: Hot Backup Recovery Scenario

2001-12-20 Thread Steve McClure
and control files from Machine A to Machine B. 4.restart database on Machine A. 5.restore datafiles from hot backup to Machine B. 6.copy init files from Machine A to Machine B 7.issue a recover database on Machine B. Hope This Helps, Steve McClure -Original Message- Sent: Thursday

RE: WHICH SID

2001-12-19 Thread Steve McClure
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

hard disk configuration question

2001-12-18 Thread Steve McClure
them, but maybe Sun does this better than I think. Without some kind of redundancy I am reluctant to use these disks for any DB purposes. Any thoughts here are appreciated as well. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure

RE: hard disk configuration question

2001-12-18 Thread Steve McClure
: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

RE: Rollbacks - ORA-1555

2001-12-05 Thread Steve McClure
I always just tell the developers to figure out a way to accomplish their task, and avoid the error on their own. Oh the link is Cats Dogs and ORA-01555 Steve McClure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christine Turner Sent: Tuesday

RE: Has anyone heard of Mirror Accessible?

2001-12-05 Thread Steve McClure
had set for management. She managed our group for about 3 months, but we lived with trashed data for the next two years. I hope this doesn't mean I have a bad attitude. Steve McClure -Original Message- Sent: Wednesday, December 05, 2001 1:20 PM To: Multiple recipients of list ORACLE-L

[no subject]

2001-11-29 Thread Steve McClure
is this. Are these serious platforms for a business currently handling 10K OLTP transactions a day, and looking to double or triple that volume within two years? Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City

Possibly moving to Sun Equipment

2001-11-29 Thread Steve McClure
that volume within two years? Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Possibly moving to Sun Equipment

2001-11-29 Thread Steve McClure
done a bit of internet searching, and seen these Sun boxes priced under 20K. My question is this. Are these serious platforms for a business currently handling 10K OLTP transactions a day, and looking to double or triple that volume within two years? Steve McClure -- Please see the official

RE: Crontabs and Oracle

2001-11-28 Thread Steve McClure
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL

RE: Ok two databases..two machines..one database name

2001-05-25 Thread Steve McClure
confirmation. I had better be careful or I am going to confidently screw up my database one of these days. Steve McClure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rao, Maheswara Sent: Friday, May 25, 2001 6:11 AM To: Multiple recipients of list

Ok two databases..two machines..one database name

2001-05-24 Thread Steve McClure
going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Moving a database to a different machine

2001-05-24 Thread Steve McClure
period. ( probably Saturday night :( Jared On Thursday 17 May 2001 13:48, Steve McClure wrote: Koivu, Lisa said A word of warning, and you probably already know this: you can't have both databases open at the same time or you will end up with incompatible archive logs and control files. Good

Moving a database to a different machine

2001-05-17 Thread Steve McClure
retrieve my backup and recovery bible. Any Comments are appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Moving a database to a different machine

2001-05-17 Thread Steve McClure
and thanks for the tip about just moving the arc/redo/control files back to the production machine to resynch the DBs. That will save me from some tedium on moving day. Steve McClure -Original Message- Sent: Thursday, May 17, 2001 11:47 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Hi Steve, I

RE: 7.3.4 svrmgrl requiring password if called by root user

2001-04-11 Thread Steve McClure
to a backup user executes my PERL backup script, then finally, calls my newly created dumpall script as root. Allthough I felt my original solution was more elegant, this one actually works. We've all been there right? Thanks Again, Steve McClure -Original Message- From: [EMAIL