RENAME

The Oracle RENAME statement allows you to rename an existing table or index in any schema (except the schema SYS).

The general format is:

RENAME tablename TO newtablename;
RENAME INDEX indexNnme TO newindexname;