Re:RE: Just got back from SQL*Server 2000 training...

I find both the observations Jim made during the class and the remarks from the SqlServer list as both interesting. Having worked with SQL*Server as well as being an Oracle addict I observe that we each view our RDBMS choices as the best there is which is kind of valid. It's just very interesting how much more you can do when the software vendor is not so self assured that he knows best. Oh, you don't believe MicroSlop knows what is in your best interest? Go read the fine print on your license agreement, you've already agreed to that.

    Now pardon me while I allow Bill to drive. He says I need a patch for Access & those Oracle tools are in the way and require deleting.

Dick Goulet

____________________Reply Separator____________________
Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com>
Date:       2/19/2002 8:43 AM

> ----- Original Message -----
> To: "SQL 7 Discussions" <sql7_at_ls.swynk.com>
> Sent: Tuesday, February 19, 2002 5:29 PM
>
> *When txn log fills up, have to just "truncate" the log in order for
> processing to continue. Leaves system vulnerable until you get a full DB
> backup.
> >>>>>> Seems a little like disk space filling up in Oracle. How is this
> >>>>>> different?

Interesting. When this happened to us Oracle-wise, I just moved the oldest archives to a mount point that did have enough room. Since we at least had enough forethought to incorporate several redo log groups, the DB never stopped. And since we never actually deleted any archive logs, we were never at great risk of permanent loss of data.

Or we could have also duplexed the arches offsite, too. Because we all know that RAID controllers NEVER fail...

"Truncate the log." Yeah, right.

Ya know, as much as I have whined about the way Oracle does some things (e.g. stupid-ass security-by-obscurity for DBAs and some wierd things with OiD), I still think it's the best yet available.

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).