Reorganize system tablespace

[iyyappan]

Dear Gurus,

This is a 11i setup with on-going development. The source$,
argument$,idl_ub1$,idl_ub2$,obj$,dependency$ have all gone past 2000
extents. Other than recreating the database (the size of db is around 20GB)is there any method to reorg these objects.Can export drop import be used by connecting as sys/internal and taling export of the table one by one.?

Thanks in advance,
Iyyappan.M

[pando]

that wont work

rebuild is your only choice

however I doubt that affects your database performance

[Orca777]

Hi,
due to these are normal tables you could reorganize them
with

alter table move ... Storage ...

But do not forget to rebuild the indexes it they have one.

* Before doing this i would take a cold backup before
* I would test it on an local game-databse before

Orca

[pando]

when you move tables, the tables involved are locked which may avoid recursive calls

I wouldnt touch it

[slimdave]

What's your db_block_size, iyyappan, and are you using dictionary or locally managed tablespaces

[iyyappan]

Hi,

Thanks for ur reply. My database block size is 8192 (8k).

Totally 314 tablespaces is there. All tablespaces are locally managed.
Except System.

RDBMS Version 8.1.7.3.0

Awaiting ur reply,

Thanks in advance,
Iyyappan.M

[SANJAY_G]

Originally posted by Orca777
Hi,
due to these are normal tables you could reorganize them
with

alter table move ... Storage ...

But do not forget to rebuild the indexes it they have one.

* Before doing this i would take a cold backup before
* I would test it on an local game-databse before

Orca

I would not recommend to move the system tables whatsoever.
Anyway as pando said you need not worry about 2000 extents when you are using LMT. It won't affect the performance.

Sanjay

[Orca777]

To pando, SANJAY_G

you are right!

Orca