Component : SAP HANA database - SAP HANA Appliance

Solution : https://service.sap.com/sap/support/notes/1646743 (SAP Service marketplace login required)

Summary :
In a SAP HANA environment, tables named _SYS_SS_CE__TMPTBL, corresponding to temporarily created tables during procedure compilation, persist due to a deletion issue pre-Revision 17. These tables fail to drop, accumulating in any system updated from or operating on revisions older than 17. The provided Python script, sqlscript_utils.py, offers a resolution by generating DDL statements or directly dropping these tables. This remedy is crucial for maintaining optimal database performance and preventing unnecessary storage consumption.

Key words :
py  --action=12  --mode=0  --filter=1for dropping, naming pattern _sys_ss_ce_<guid>_tmptbl solution, py  --action=12  --mode=1  --filter=1please, naming pattern _sys_ss_ce_<guid>_tmptbl, naming pattern  _sys_ss_ce_<guid>_tmptbl, remaining _sys_ss_ce_<guid>_tmptbl tables, sap hana database instance, revision 17 temporary tables created, sap hana database, generate ddl statements

Related Notes :

1523337	SAP In-Memory Database 1.0: Central Note
1514967	SAP HANA 1.0: Central Note