Re: No automatic indexes

Brex wrote:
> Thank you guys for your comments.
>
> The reason I don't want to generate indexes automatically when creating
> tables with Pk in Oracle is that I'm creating my tables with a
> powerdesigner script in which model I've already defined pks, fks and
> indexes(half of them are defined on the same columns as the ones in the
> primary keys). PD is obviously generating a CREATE INDEX statement
> after a CREATE TABLE and when running the script, Oracle complains
> because some columns are already indexed.

Edit the script and fix it. This is a really bad idea.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org