Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 Database Reorganisation
why? look up moving tables in the docs. Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Bernard Vicaire" <bernard.vicaire_at_wanadoo.fr> wrote in message news:bl4tj6$mc8$1_at_news-reader5.wanadoo.fr...Received on Sat Sep 27 2003 - 18:55:31 CDT
> Hi
>
> I "m looking at the best methode to reorganize an Oracle database, I'm
> usually use thes steps :
>
> - Export with optin compress=y
> - Drop user XXX cascade
> - Create User XXX
> - Import (from user=XXX touser=XXX)
>
> After deleting lines in tables and making a reorganisation, i'm surprised
to
> see in DBA studio that the used size of the tablespace is the same before
> and after these steps even if the tablespace is dropped and recreated
before
> the Import.
>
> - Why ?
> - Is these steps the good methode to reorganize a database ?
> - How to reduce the used size of the tablespace ?
> - Is it better to delete and recreate the TEMP tablespace too ?
>
> Regards
>
> Bernard
>
>
>