Re: Anyway to reorganize the system tablespace?

If you can spare several hours with the database shut-down I suggest you do the following:

1. perform a full database export (compresses all objects)
2. create some sql scripts to recreate your data files, rollbacks etc. with reuse option.
3. shut-down the database
4. backup the control files somewhere safe and then delete them
5. recreate the database with reuse on redo logs
6. run scripts from step 2
7. Import full the whole database

I do this once every month and it reduces fragmentation in all objects, including system.

Laith Suheimat
l.suheimat_at_mdx.ac.uk

chandrasekar_at_my-dejanews.com wrote in message <78jmp8$3av$1_at_nnrp1.dejanews.com>...
>Hi Timothi, I am trying to do the same(DEFRAGMENTING SYSTEM TABLESPACE) .
I
>'ll try my level best to find a solution for this . In case if u happen to
>arrive at the solution, Please inform that to me . I promise you to do the
>same . Cheers CHANDRASEKAR
>
>
>In article <78fdp2$j19$1_at_news.ctimail.com>,
> "Timothy Leung" <tleung_at_ctimail.com> wrote:
>> I am looking for a way to defrag the tablespace SYSTEM. Since I cannot
drop
>> any object inside it. So I cannot re-organize it in a conventional
>> way(export data, drop the objects, create objects).
>>
>> Thanks in advance!
>> Tim
>>
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 26 1999 - 07:01:16 CST