RE: Fragmentation ?

I worked with a really smart guy once whom I won't name for obvious reasons. He had previously worked for a software co that said "Our product includes an archive routine". It didn't, they never had to write one because hey disks held 3 times the storage for half the price before anyone wanted to archive anything - at which point you just bought some more storage.

I also probably ought to include the ongoing marital dispute that I am having regarding books, my wife maintains that anything I haven't accessed for a decade could be disposed of (think Tolkien, Donaldson, Asimov, Shakespeare, Auden). *I* maintain "well we could always buy another bookcase". Logic tends to dictate my wifes approach, management I feel confident would say "ah well doesn't cost much lets buy another bookcase".

In summary Niall's 2nd rule states that "data always goes in but never comes out". It's parkinsons law for databases

Niall

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Stephen Lee
> Sent: 13 June 2003 18:45
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fragmentation ?
>
>
>
> That's one thing good about the databases here. Tablespace
> fragmentation is rarely a problem. Most of the database here
> are a Database Roach Motel: "Data checks in. It doesn't
> check out." Somehow, the data purge part of the application
> -- that they intended to put in "one of these days" -- never
> got written.
>
>
>
> (For non-USA dwellers, Roach Motel is a trap for roaches. It
> has a sticky floor, and the sales motto is "Roaches check in.
> They don't check out.")
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> 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, 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 (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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, 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 (like subscribing).