PrimaryKey setting for Existing Table[Oracle8]
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PrimaryKey setting for Existing Table[Oracle8]

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai
    Posts
    2

    PrimaryKey setting for Existing Table[Oracle8]

    Hai,
    I faced One problem in Oracle8.0.That is
    Consider a table
    sample(num number[20],name varchar2[30]);
    It have the values like this;
    num name

    NULL xyz
    NULL mnp
    123 kla
    543 ier


    From this i want to set primary key on this num column.
    According to the primarykey rule it should not possible.
    But in Oracle8.0 it accept it and make the num column as a Primary key. what is the problem???.
    send me.
    bye.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are you using 8.0.3 or 8.0.4 if so you are hitting bug 604833

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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