How to rename an Index?

The normal way of renaming an index is by the following two commands:

drop index id1;

create index id2 on table_name(column_name, column_name1);

But starting from Oracle 8i, you will be able to rename an index by issuing the following command:

alter index id1 rename to id2;

No comments :

Post a Comment