[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Better Way Of
DeFragmentation
09/20/2001 02:31
PM
Please respond
I assume you intend to also:
.5) Clone database to second machine
.6) Drop all objects in schema on 2nd machine
4.5) Take cold backup of 1st machine
With those caveats, it looks fine.
Jay Miller
-Original Message-
Sent: Thursday, September 20, 2001 10:35 AM
To: Multiple recipients of
Consider going to tablespaces where all the extents are of a uniform size.
I.e., all objects in any one tablespace have the same INITIAL and NEXT
storage parameters. These tablespaces will never need to be defragmented.
I'm not sure that your outlined procedure will work. I think that your