Rename views

You can change the name of a view without changing its definition. The data remains the same type and size.

You must be the owner of the view or have the Alter privilege on views to change the view name.

To rename a view, enter:
   MYDB.SCHEMA(USER)=> ALTER VIEW emp RENAME TO employees;