ORA-54655: CREATE_TIN: scratch tables/views(string) exist and need to be dropped

ORA-54655: CREATE_TIN: scratch tables/views(string) exist and need to be dropped
Cause: Transient tables from previous CREATE_TIN operation still existed.
Action: Delete the invalid TIN from the base table (for cleanup of scratch tables), and initialize and create the TIN again. Alternately, use SDO_UTIL.DROP_WORK_TABLES with oidstring as its parameter.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:54

ORA-54655：CREATE_TIN：scratch tables / views（string）存在，需要删除,
.原因：来自先前CREATE_TIN操作的瞬态表仍存在。,
.操作：从基表中删除无效的TIN（用于清除临时表），然后重新初始化并创建TIN。或者，使用SDO_UTIL.DROP_WORK_TABLES与oidstring作为其参数。,
.

aiaiDBA

13718043309

010-86462881

ORA-54655: CREATE_TIN: scratch tables/views(string) exist and need to be dropped

1 个回答

相似问题