Re: ora-01408?

From: keith boulton <boulke_at_globalnet.co.uk>
Date: Sat, 16 Jan 1999 10:06:22 GMT
Message-ID: <36a06169.1161389@read.news.globalnet.co.uk>

On Tue, 12 Jan 1999 22:10:41 -0800, David Spaisman <davedba_at_intercall.com> wrote:

>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

This will happen if the primary key constraint is created after an index and then the schema exported and re-imported, because the key constraint will be created before the index during the import. Received on Sat Jan 16 1999 - 04:06:22 CST