Reorganize system tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Reorganize system tablespace

  1. #1
    Join Date
    Jun 2002
    Posts
    88

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    that wont work

    rebuild is your only choice

    however I doubt that affects your database performance

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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 05:09 AM.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    when you move tables, the tables involved are locked which may avoid recursive calls

    I wouldnt touch it

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What's your db_block_size, iyyappan, and are you using dictionary or locally managed tablespaces
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jun 2002
    Posts
    88
    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

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  8. #8
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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
  •  



Click Here to Expand Forum to Full Width