Symptom
- `sp_shrink` / `ALTER DATABASE OFF` fails with Msg 5066 for a specific table.
Msg 5066, Level 16, State 1:
Table '<table_name>' contains off-row columns that do not link back to their
owning rows. Run dbcc shrinkdb_setup to set up back links for this database. - Ran 'dbcc shrinkdb_setup`as KBA 2440368 suggested,it completes without showing error, but shrink cannot proceed with the same error.
- `dbcc checktable` and `dbcc tablealloc` both report clean (0 rows, 0 text extents)
- "sp_help <table_name>" shows below message which indicates previously had text/image/Lob columns that were subsequently dropped.
Table OWNER.<table_name> has columns dropped by no datacopy method. - Check syspartitions for this table and it has "t<table_name>_<partid>" prefixed LOB partition.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2
Keywords
shrink, LOB,phantom , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview