What do you do with QCM tables(conversion tables note9385)

最新推荐文章于 2025-08-23 23:16:00 发布

转载最新推荐文章于 2025-08-23 23:16:00 发布 · 2.2k 阅读

文章标签：

#database #table #delete #informix #sql server #oracle

本文介绍如何处理数据库中未被ABAP/4字典描述的QCM前缀表，这些表通常用于临时存储转换过程中的数据。从3.0D版本开始，系统将自动删除这些表，对于早期版本，提供了手动删除的方法，包括检查表一致性、确认原始表数据的正确性等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

tables whose name starts with the prefix "QCM" exist in the database,
but are not described in the ABAP/4 Dictionary.

Cause and prerequisitesITPUB个人空间X2jk-/.DJ%DoO5Q

During conversions, the data from the tables for conversion
jJ8gu_a|YA}1H13316are temporarily stored in tables with the name "QCM<table_name>". These QCM tables are deleted for the corresponding table before each upgrade.
Z�f,y'FKN ]13316These tables are, however, not immediately deleted after being converted and so take up unnecessary database space.

SolutionITPUB个人空间n"qEa/I T

As of Release 3.0D, the QCM tables will be automatically deleted after a sucessfully completed conversion.ITPUB个人空间ntcs/ W!df`h
Prior to Release 3.0D, you can delete these tables with DB means or the database utility.
UD#J%|"/rz[�r13316Be sure to check, however, before deleting, whether the table is consistent. The database utility should not display a restart log or a conversion procedure termination. In addition, check whether the data of the original table is legible (e.g. by using transaction SE16). If application programs do not run correctly which use the affected original table, do not delete the QCM table yet.
[ZP5JyyK-r13316Once you are certain that the QCM table is ready for deletion, you can delete on the database using 'sqlplus' or 'sqldba' (ORACLE), 'dbaccess' (INFORMIX), 'xutil' (ADABAS), 'ISQL/W' or 'Enterprise' under 'Manager->Tools-> Query Tool' (SQL Server in each case).
2T4lCBJg-]w13316As of Release 3.0D, you can also use the database utility for deleting QCM tables. To do this, start transaction SE14 and select 'Extras->Invalid temp. table' in the menu bar. This displays all the QCM tables that can be deleted. Simply mark them and delete with the push of a button. QCM tables in which the conversion is not yet complete are not listed.