Re: How do you defrag a tablespace?

On Fri, 3 Apr 98 09:55:48 +1200, mdlcpgs_at_lhn.gns.cri.nz.nospam wrote:

>How do you defrag a tablespace? I did the check recommended in the
>tuning ref and got back bad answer. But the tuning ref is silent on how
>you fix it. (Extreme novice DBA).

If its the remaining space in the tablespace you want to defrag, use

alter tablespace <name> coalesce;

If its the actual tables in the tablespace that need defraging, you can use a third-party tool, or suffer Oracle's dinosaur method of export-with-compress/import.

(Note: I can't believe they've been selling Oracle for 20 years now, and still can't write decent utilities like table defrag!).

Ciao
Fuzzy
:-) Received on Fri Apr 03 1998 - 00:00:00 CST