| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to DROP ALL TABLEs?
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>There is a possible disadvantage with a script like this:
>
>If there are a lot of objects in each tablespace then
>the number of free extents generated can become
>very large. This results in a large cluster of fet$ entries
>which (due to the code Oracle uses to find and allocate
>free extents) can lead to a significant time-cost when
>creating new objects.
>
>If necessary a small modification to the script could
>be made to produce an output which does:
> drop single object
> coalesce tablespace for physical object
> drop single object
> coalesce ....
Thanks. That's a good idea!
Chris
 |
 |