Results 1 to 5 of 5

Thread: help!

  1. #1
    Join Date
    Sep 2013
    Posts
    14

    Unanswered: help!

    SQL> alter table store_reps
    2 ADD CONSTRAINT rep_id_pk PIRMARY KEY (rep_id)
    ADD CONSTRAINT rep_id_pk PIRMARY KEY (rep_id)
    *
    ERROR at line 2:
    ORA-01735: invalid ALTER TABLE option

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how do you normally spell primary
    ..whenever you see such thing always check your code for typos
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2013
    Posts
    14

    Help!!

    SQL> alter table store_reps
    2 modfiy comm set default 'Y';
    modfiy comm set default 'Y'
    *
    ERROR at line 2:
    ORA-01735: invalid ALTER TABLE option

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    See post #2
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by healdem View Post
    See post #2
    Sorry, this was my bad... I merged an orphan thread from MySQL with the original Oracle thread (because it had your excellent response).

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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