--
-- depends on your version
-- in 9i u can just rename the table as following.
--  run the script, spool the output,run the spooled file and you are all set.

dbadmin@republic_lawd1 > create table "lowercase" ( id number);

Table created.

dbadmin@republic_lawd1 > create view "myview" as select * from emp;

View created.

dbadmin@republic_lawd1 > select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
lowercase                      TABLE
myview                         VIEW

2 rows selected.

dbadmin@republic_lawd1 > spool dummy

  1* select 'rename "'||table_name||'" to '||upper(table_name) from cat
dbadmin@republic_lawd1 > /

'RENAME"'||TABLE_NAME||'"TO'||UPPER(TABLE_NAME)
-------------------------------------------------------------------------
rename "lowercase" to LOWERCASE
rename "myview" to MYVIEW