Oracle-L: RE: drop tablespace including contents

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 21 Aug 2002 07:38:30 -0800
Message-ID: <F001.004BB1A6.20020821073830@fatcity.com>

Russ,

You have my sympathies. I've been managing SAP databases for the last 7 years, and the last time I let SAPDBA control a reorg was 6.95 years ago. It performs some tasks reasonably well, like datafile additions and managing CBO statistics refreshes (especially since SAP wants certain tables to be left without statistics). But for reorgs, I prefer more direct control. Perhaps you can use this SNAFU to convince management to have sapdba generate the scripts, then allow you to modified them appropriately.

Mike Hand
Polaroid Corp.

-----Original Message-----
Sent: Wednesday, August 21, 2002 9:03 AM To: Multiple recipients of list ORACLE-L

I fully agree. Unfortunately management insists on it.

Russ

-----Original Message-----
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L

Dick,

There is absolutely *nothing* that SAPDBA does that a reasonably knowledgeable DBA can't do from his of her favorite toolset. ( vi, Perl and sqlplus for me :)
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hand, Michael T
INET: HANDM_at_polaroid.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 Wed Aug 21 2002 - 10:38:30 CDT