The following statement renames a table:

ALTER TABLE employees RENAME TO employee;

In the following statement, partition emp3 is renamed:

ALTER TABLE employee RENAME PARTITION emp3 TO employee3;