Re: Oracle 8.1.7 Database Reorganisation

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Sat, 27 Sep 2003 22:30:38 GMT
Message-ID: <icodb.20330$ZR1.6348@nwrddc01.gnilink.net>

"Bernard Vicaire" <bernard.vicaire_at_wanadoo.fr> wrote in message news:bl4tj6$mc8$1_at_news-reader5.wanadoo.fr...
> 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
>
>
>

Don't reorganize without a reason. Get a life :) If reorganizing, then please tell us what your reasons are? Just to reduce the used space in a tablespace? ... you need better reasons than that for anyone to answer your question.

Anurag Received on Sat Sep 27 2003 - 17:30:38 CDT