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

Thread: Reorg

  1. 08-14-2001, 05:22 AM #1
    alexandre
    alexandre is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 08-14-2001, 08:57 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    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