Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT: Archiving not possible with SQL Server?
Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot.
Supreme Council says: "All Aboard MS SQL!" Me says: "Abandon Ship!"
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
-----Original Message-----
Patrice J
Sent: Thursday, May 31, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Jared is having a bad day.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message----- From: Jared Still [SMTP:jkstill_at_cybcon.com] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> >>Guess what happens when a long running transaction marks
>
> the log near the end, and not too long afterward the log
> needs truncated? If memory serves, ( hasn't worked too well lately
:) the
> database
> will hang. It may just truncate back to the mark, and start from
> there, but you always have the possibility of another long
> transaction starting.<<
>
> HELP
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: gweber_at_cji.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).Received on Thu May 31 2001 - 09:49:02 CDT
![]() |
![]() |