-
Reorganize system tablespace
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
-
that wont work
rebuild is your only choice
however I doubt that affects your database performance
-
Hi,
due to these are normal tables you could reorganize them
with
Code:
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
Last edited by Orca777; 11-17-2002 at 06:09 AM.
-
when you move tables, the tables involved are locked which may avoid recursive calls
I wouldnt touch it
-
What's your db_block_size, iyyappan, and are you using dictionary or locally managed tablespaces
-
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
-
Originally posted by Orca777
Hi,
due to these are normal tables you could reorganize them
with
Code:
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
-
To pando, SANJAY_G
you are right!
Orca
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|