DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle import error

  1. #1
    Join Date
    Jan 2001
    Posts
    91

    Post

    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"



  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width