一、查找带双引号的表(一般表名为小写)
SELECT OWNER, TABLE_NAME, 'ALTER TABLE '||OWNER||'."'||TABLE_NAME||'" RENAME TO '||OWNER||'.'||TABLE_NAME|| ';' AS TSQL FROM ALL_TABLES
WHERE REGEXP_LIKE(TABLE_NAME, '[a-z]')
ORDER BY OWNER, TABLE_NAME
二、执行表改名(上面语句已批量生成)
ALTER TABLE table_name RENAME TO new_table_name;