Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoid the fragmentation in 9.2

Re: Avoid the fragmentation in 9.2

From: <joel-garry_at_home.com>
Date: 1 Mar 2005 17:16:56 -0800
Message-ID: <1109726216.392237.312980@z14g2000cwz.googlegroups.com>


>> Another DBA told me there is restriction of TRUNCATE table for
million
>> records even I use the drop storage option. IS that true?

>In a word, No. Get them to show you. If they can't show you set up a
test
>with say 15m records (ten times your expected load). TRUNCATE will
pass the
>test.

Shouldn't the word be maybe? We haven't determined yet if this is an "upgraded" DMT with possibly severe extent issues or other weirdness.

jg

-- 
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/23.76.html#subj1
Received on Tue Mar 01 2005 - 19:16:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US