Re: Reorganize System Tablespace

"Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> wrote in message news:7ca2852.0209091939.4a0d38e0_at_posting.google.com...
> Hi
> Sybrand's suggstion that i take full export and recreate and full
> import may not be possible as the database is around 400GB and there
> is no downtime window, though it may be the conventional and safe
> method.
> I think i can rebuild those objects using alter table move...command
> and get it reorganized. Guess i need to note down the indexes on these
> tables and their type,uniqueness,columns,column position alone. Once i
> rebuild the table , as the indexes become unusable, i can immediately
> rebuild these indexes also. I tried it on my desktop database, seems
> to be fine. Are there any pitfalls?
>
> Cheers,
> Ashok
>

The objects you noted? You can't be serious! You will seriously compromise database operation when you do so, also those objects are in use almost permanently. If you can't afford downtime

- hire a second server
- export the database
- recreate the database on the second server
- clone the database to the source server.

I would go ahead with your own strategy if you want to loose your job. I'm NOT joking. It's up to you!

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address