-
Do anyone recognize this error??
Import from a dmp file from Unix oracle version 7.3.4 in oracle 8i nt
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "AP1099TYPES_U1" ON "AP1099TYPES" ("CODE1099" ) PCTFRE"
"E 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 "
"MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
"AULT) TABLESPACE "SQLIDX" LOGGING"
-
Error: ORA 1452
Text: cannot CREATE UNIQUE INDEX; duplicate keys found
-------------------------------------------------------------------------------
Cause: A CREATE UNIQUE INDEX statement specified one or more columns that
currently contain duplicate values. All values in the indexed colums
must be unique by row to create a UNIQUE INDEX.
Action: If the entries need not be unique, remove the keyword UNIQUE from the
CREATE INDEX statement, then re-execute the statement. If the entries
must be unique, as in a primary key, then remove duplicate values
before creating the UNIQUE index.
You may also want to take a look at ( [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=130205.1[/url] )
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|