Skip to content
Home » Oracle » How Oracle Rename View

How Oracle Rename View

To rename a view, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example:

SQL> show user
USER is "OE"
SQL> select object_type from user_objects where object_name = 'PRODUCTS';

OBJECT_TYPE
-----------------------
VIEW

SQL> rename products to products_view;

Table renamed.

Although it returned "Table renamed.", the object is not necessarily a table.

Leave a Reply

Your email address will not be published. Required fields are marked *