Solution 1: rename all tables by hand using a tool (like TOAD)
Solution 2: write a script that does it for you, renaming by hand hundreds or thousands of tables is not an option. Here's the script, it's not error prone but works.
Known bugs: if table name is already case insensitive, it fails on renaming.
DECLARE
string varchar2(200);
BEGIN
for tabs in (SELECT table_name, upper(table_name) as uppername FROM user_tables)
loop
string := 'alter table ' || tabs.table_name || ' rename to ' || tabs.uppername;
execute immediate string;
end loop;
END;
No comments:
Post a Comment