Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Exclamation Unanswered: cannot modify a column ..... non-key preserved table

    DB1@DB1> update all_col_comments set comments='CATEGORY ID' where TABLE_NAME='DOCINDEX' and COLUMN_NAME='CATEGORYID';

    ORA-01779: cannot modify a column which maps to a non key-preserved table (DBD ERROR: OCIStmtExecute)


    ANY IDEAS, anybody
    Thanx and Regards
    Aruneesh

  2. #2
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60
    Why don't you use the normal sql command

    COMMENT ON COLUMN DOCINDEX.CATEGORYID IS 'CATEGORY ID' ;

  3. #3
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Thats works dude

    Hi
    COMMENTS on COLUMN works absolutely fine.
    Thanx and Regards
    Aruneesh

Posting Permissions

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