Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: pros and cons
> SQL> alter table t drop primary key;
>
> Table altered.
>
> SQL> select index_name from user_indexes where index_name ='I';
>
> no rows selected
>
Yeah, that's the test what I did after I started doubting whether I remembered the generated flag issue correctly...
Tanel.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 01 2004 - 05:18:07 CST
![]() |
![]() |