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