Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    2,296

    Unanswered: Import has no PKs, strange

    Anyone have any idea why my morning imports have only a few
    primary keys on the tables instead of all the PKs?

    The export log has no errors.
    The import log only lists errors regarding the FKs (obviously due to the lack of PKs).

    Export parfile:
    Code:
    > more do_exp.par
    direct=Y
    consistent=N
    statistics=NONE
    feedback=100000
    log=integration_export.log
    owner=INTEGRATION
    Import parfile:
    Code:
    > more do_imp.par
    fromuser=INTEGRATION
    touser=PLATFORM
    log=dev_import.log
    ignore=Y
    feedback=50000
    statistics=NONE
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Even more strange are the PK lines inside the export file.
    This is not even a valid statement but it is straight from the .dmp file:

    PHP Code:
    ALTER TABLE "AC_SYSTEM" ADD  CONSTRAINT "AC_SYSTEM_PK" PRIMARY KEY 
    ("ORG_ID""CUST_ID""PREM_SEQ_NBR""AC_SYSTEM_SEQ_NBR"
    USING INDEX PCT 2 MAXTRANS 255 
    STORAGE
    (INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1
    TABLESPACE "INDX" NOLOGGING ENABLE 
    gets this error when I run it through sqlplus:
    ERROR at line 3:
    ORA-01735: invalid ALTER TABLE option
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •