-
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
-
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
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
|