modifying table names in Oracle

<<< Memo >>> Answer1: ALTER TABLEOld_table_name RENAME toNew_table_name; (Uppercase as System command) Answer2:sql> select tname from tab; Tname------------------------------Test sql> rename test to temp; Table renamed. Sql> select tname from tab; Tname------------------------------TEMPRename can only modify the table below its schema. Answer3: Create new_table as SELECT * from Old_table;drop table old_table;

modifying table names in Oracle