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

Thread: Reorganize system tablespace

Threaded View

  1. 11-17-2002, 06:05 AM #3
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    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 06:09 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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