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.)
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.