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;
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;