Guest User

Untitled

a guest
Jul 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SQL> create table a1_test (id number primary key);
  2.  
  3. SQL> create index i1 on a1_test (id);
  4. create index i1 on a1_test (id)
  5. *
  6. ERROR at line 1:
  7. ORA-01408: such column list already indexed
  8.  
  9. SQL> select index_name from user_Indexes where table_name = 'A1_TEST';
  10.  
  11. INDEX_NAME
  12. ------------------------------
  13. SYS_C0051416
  14.  
  15. SQL> drop table a1_test;
  16.  
  17. Table dropped.
  18.  
  19. SQL> create table a1_test (id number);
  20.  
  21. Table created.
  22.  
  23. SQL> create index i1 on a1_test (id);
  24.  
  25. Index created.
  26.  
  27. SQL> alter table a1_test add constraint pk_test primary key (id);
  28.  
  29. Table altered.
  30.  
  31. SQL> select index_name from user_Indexes where table_name = 'A1_TEST';
  32.  
  33. INDEX_NAME
  34. ------------------------------
  35. I1
Add Comment
Please, Sign In to add comment