Space Manager is an "offline" tool -- It creates a script that will create a
new table, populate it, and replace the old table with it, and during this
time the table is not accessible.
Live Reorg only has a "very short" window where the table is locked -- Quest
says a few seconds -- while the table is reorg'd. And, while I haven't used
it, I'm guessing that Live Reorg will not invalidate objects (like triggers)
that have a dependency on the table being reorg'd, unlike Space Manager's
brute force method.
Space Manager 3 is OK. v4 should be much nicer once it's out of beta (read:
more stable). There are enough major bugs in v4 (easy to reorg a 500K index
to a 500M index) that I'm going to wait for an "official" version. :)
Bottom Line:
Space Manager: Cheap, but needs downtime.
Live Reorg: Expensive, but no real downtime.
TS Reorg: Now owned by CA, so I probably won't even look at it. :)
Good luck!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Friday, June 15, 2001 12:11
To: Multiple recipients of list ORACLE-L
Sun Sparc Solaris 2.6/8
Oracle DB 8.0.6, 8.0.5
Oracle Apps 11.0.3
My client and I are currently planning on re-orging some of our database -
say about 90G out of a 120G database (2 schemas). We've identified 3
tools and are seeking feedback on the pros/cons of each option.
....
anyone?
Also, can anyone explain the difference between Space Manager and Live
ReOrg? Both are marketed by Quest, making me wonder what, if anything, is
the difference...
TIA
J
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
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 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).
