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

Thread: Reorg

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96

    Angry

    Hi all
    I'm running 8.0.6.2 on UX-HP 10.20. can someone tell me exactlly the steps to follow in order to "reorg " my database?
    any internet site?

    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Typically, when people talk about "reorg"ing a database, they are talking about moving data from one tablespace to another while compressing extents. Since you're on 8.0.x, you have two options:
    1. export your entire database and import
    2. create similar structures in another tablespace and fill them with SQL queries. When you are done, rename the existing structures to _OLD and rename the new structures to the real table name.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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