oracle rename view

oracle rename view

                 

 oracle rename renames  view, all constraints,indexes , grants will be transferred to new name.

SYNTAX:

Rename <old Name> to <new name>;

Create a View called V1;

create or replace view v1
as
select * from employees;

renames v1 view to v2;

SQL>rename v1 to v2 ;

SQL> select * from v2;

Note:  rename will rename triggers associated with that view.

Tags:  rename view  in oracle,oracle rename view , oracle rename syntax, oracle rename cons,oracle rename pros, How to rename view  in oracle,rename view  affect on triggers.