I'm running 18.104.22.168 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
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.
Click Here to Expand Forum to Full Width