Reorg Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Reorg

  1. #1
    Join Date
    Jun 2000
    Maputo, Maputo-Mozambique


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

    In god i trust

  2. #2
    Join Date
    Nov 2000
    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
    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