Spatial Type for Oracle: Attempting to rename a table can fail with an underlying DBMS error. (Please see technical article 35222 for a suggested workaround.)
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM037121
已提交
July 30, 2008
上次修改时间
June 5, 2024
适用范围
No Product Found
找到的版本
9.3
修正版本
9.4
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
7/16/08 See KB article 35222.The fix for the problem is two changes -1. Change the local st_str varchar2 variable to a CLOB2. Change the token for finding the TO in the rename statement, pos := INSTR(rename_stmt, ' TO ') + 3;The change of the + 2 to 3 is to ensure the substr starts after the TO, the next block in the procedure removes all empty spaces.