- If a table was incorrectly identified by dbcc orphantables("drop") as orphaned and is in use, an 8201 might be reported in the ASE errorlog along with a stack trace:
1> dbcc orphantables("drop")
Running DBCC ORPHANTABLES in DROP mode.
Dropped orphan temporary table #tab00000xxxxxxxxxxxx.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
- Example of error 8201 with a stack trace:
Error: 8201, Severity: 26, State: 6
SAP Adaptive Server Enterprise 16.0 SP03 PL08 and later, and SP02 PL09
8201, Found orphan table, orphantables, des__unkeep, des_unkeep_or_drop, drop , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis 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.