Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoid the fragmentation in 9.2
>> 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#subj1Received on Tue Mar 01 2005 - 19:16:56 CST
![]() |
![]() |