ora-01408?

Hello:

I am working on NT with oracle 8.0.4.

I am trying to set up another test database based upon a production database.

Based upon an extract of ddl by DBArtisan, I ran the extract ddl and most of the objects were created i nthe test database. One object not created were three indices. The error message given was : ora-01408:

on editool.app_activity_log(act_id asc) *
ORA-01408: such column list already indexed

And in fact there is also a primary index constraint which utilizes the same column(act_id). But when I look at production(this is a package bought from a vendor) the primary index and this same second index exist!! I can't figure out how. I looked at the original ddl we got from the vendor and it is the same as what I am running?

1. so how did this happen?
2. How do I get this second index created in the test database?

Thanks.

DAvid Spaisman Received on Wed Jan 13 1999 - 00:10:41 CST