system catalog 
Author Message
 system catalog

Good afternoon

can anybody help me how to release unused chunks?

I have dbspace with many chunks. I removed data to other location and some
chunks became empty.
Almost empty, there are still pages of system catalog tables (sysdistrib,
sysprocbody, ...) and
chunk cannot be removed.
How to consolidate (move) system catalog pages to a given chunk (dbspace)
and release chunk?
I have tried "alter fragment on table sysdistrib init in the_same_dbspace"
but received error 511. :-(

Thanks a lot



Sat, 05 Jun 2004 20:47:13 GMT
 [ 1 post ] 

 Relevant Pages 

1. SQL 7.0 System Catalog and Database Catalog ERD

2. How to allow update system catalog?

3. Allow ad-hoc updates to system catalogs

4. System Catalogs

5. Bug: System catalog stored proc deadlock using MTS/ADO/SQL Server

6. Allow modifications to be made directly to the system catalogs

7. ad hoc updates to system catalogs

8. Database backup information in system catalog

9. SQL Server 7 system catalog index discrepancy

10. SQL 7.0 SYSTEM catalog

11. system catalog diagram

12. Tracking system catalog changes

Powered by phpBB® Forum Software