Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Rename an Index
How To Rename an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes
✍: FYIcenter.com
Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index:
CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); Table created. SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'STUDENT'; INDEX_NAME TABLE_NAME UNIQUENES ----------------------- --------------------- --------- SYS_C004153 STUDENT UNIQUE SYS_C004154 STUDENT UNIQUE ALTER INDEX SYS_C004153 RENAME TO student_pk; Statement processed. SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'STUDENT'; INDEX_NAME TABLE_NAME UNIQUENES ----------------------- --------------------- --------- STUDENT_PK STUDENT UNIQUE SYS_C004154 STUDENT UNIQUE
2007-05-02, 5070👍, 0💬
Popular Posts:
Should synchronization primitives be used on overrided bean methods? No. The EJB specification speci...
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...
How To Create an Add-to-NewsGator Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
What is the difference between mysql_fetch_object() and mysql_fetch_array() functions in PHP? mysql_...
How do I install JUnit? First I will download the lastest version of JUnit. Then I will extract all ...