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

Thread: While importing problem

  1. #1
    Join Date
    Oct 2001
    Posts
    13
    Hi,

    We have received a dump file from our client.

    While importing we are getting the following error

    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.05 via conventional path

    Warning: the objects were exported by SYSTEM, not by you

    import done in UTF8 character set and UTF8 NCHAR character set
    export server uses US7ASCII NCHAR character set (possible ncharset conversion)
    . . importing table "AV_CLASS_MAP" 0 rows imported
    . . importing table "AV_META_DATA" 212 rows imported
    IMP-00017: following statement failed with ORACLE error 2261:
    "ALTER TABLE "AV_META_DATA" ADD CONSTRAINT "UK_AV_META_DATA_0" UNIQUE ("OBJ"
    "ECT_ID") ENABLE "
    IMP-00003: ORACLE error 2261 encountered
    ORA-02261: such unique or primary key already exists in the table
    . . importing table "BANDWIDTH_DEF" 6 rows imported

    The export is taken from 8.1.5 import utility. In 8.1.5 if we have a primary key on a column and if we try to create a unique constraint on the same column Oracle will give an error. If that is the case then how the above two statements came into the dump file while is creating an error while importing.

    Thanks in advance,
    Sreelatha

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    I think the database into which you are trying to import, has that table.
    In these circumstances, you can try to import with IGNORE=Y option.

    Vijay.

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