for Oracle you can rename a table by:
ALTER TABLE table_name2 RENAME TO table_name1;