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

Thread: Import constraint Problems

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Location
    Winnipeg
    Posts
    21
    Hi importing a DB into a new USER space and get
    . . importing table "ACTION_HARVEST_DETAIL" 10039 rows imported
    IMP-00015: following statement failed because the object already exists:
    "ALTER TABLE "ACTION_HARVEST_DETAIL" ADD CONSTRAINT "PK_ACTION_HARVEST_DETA"
    "IL" PRIMARY KEY ("ACTION_HARVEST_DETAIL_ID") USING INDEX PCTFREE 10 INITRAN"
    "S 2 MAXTRANS 255 STORAGE(INITIAL 393216 NEXT 131072 MINEXTENTS 1 MAXEXTENTS"
    " 4096 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABL"
    "ESPACE "USERS" ENABLE "


    BUT

    I get
    About to enable constraints...
    IMP-00017: following statement failed with ORACLE error 2430:
    "ALTER TABLE "ACTION_HARVEST_DETAIL" ENABLE CONSTRAINT "PK_ACTION_HARVEST_DETAIL""

    When 2430 is
    ORA-02430 cannot enable constraint (string) - no such constraint
    Cause: The named constraint does not exist for this table.
    Action: Check that a constraint exists before trying to enable it.

    Why? is it there or not there?

    (this happens for about 45% of the constraints)


    Grah,

    You'll always learn something if you take your time to ask.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I think that since the table existed as listed in the first error the constraint was not imported, therfore it can not be enabled.

    Maybe this would work, i'm not sure.
    constraints=y
    ignore=y


    In situations where multiple refreshes from a single export file are done with IGNORE=Y, certain objects can be created multiple times (although they will have unique system-defined names). You can prevent this for certain objects (for example, constraints) by doing an import with the value of the parameter CONSTRAINTS set to N. If you do a full import with the CONSTRAINTS parameter set to N, no constraints for any tables are imported.


    MH
    I remember when this place was cool.

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