SELECT 'RENAME ' || SEGMENT_NAME || ' TO ' || 'TBL_' || SEGMENT_NAME || ';' FROM USER_SEGMENTS WHERE TABLESPACE_NAME LIKE 'Your Tablespace Name' AND SEGMENT_TYPE = 'TABLE';
然后把执行结果当作SQL语句执行
