Re: ANOTHER DEFRAG QUESTION
Date: 1996/04/17
Message-ID: <1996Apr17.065152.450_at_ns2>#1/1
In article <3172A95B.43BB_at_explorer.csc.com>, Charles Walker <cwalker_at_explorer.csc.com> writes:
>Hi,
>
>I keep reading conflicing statements from Oracle's own documentaion on
>this point. One stance is the ONLY way to defrag a tablespace is to do a
>USER export, drop and recreate the tablespace and import.
>Another says to defrag the tables in a tablespace it's OK to use a TABLE
>export, drop and recreate the table and import. My problem is I have a
>user that spans mulitple tablespaces, but want to defrag one tablespace
>at a time. Can I defrag a tablespace by defraging the tables in it?
That depends. Table fragmentation means that a table consists of more than one
extent. You could fix this by exporting the table, dropping it and importing it
again.
Tablespace fragmentation is another - and worse - case. To fix this you have to
drop the tablespace and create it again. If you were "smart" enough to give a
user quota on more than one tablespace, you have a lot more work to do than if
you hadn't.
| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |
| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |
| Flagellant in Dreamland | ********************************************************************************Received on Wed Apr 17 1996 - 00:00:00 CEST