Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: Alter Table Problem

    Hello,

    I'm trying to alter a table and I'm getting the folowing error:

    ORA-22856: cannot add columns to object tables

    the sql I'm performing is:
    ALTER TABLE STATSOWNER.LOG_TRANSACTION_DETAILS
    ADD (HBW VARCHAR(1))

    as far as I know it should work, right?

    So tried to persue this a little bit more and I found out the table I'm trying to alter is in fact a synonym.

    So I got the actual table name ,which is the same as the synonym, and found that I'm logging in with its owner so there should be no problem, right?

    Can anyone help me?

    Thanks,
    Vanessa.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If it is about an object table, check this page.

    If it is about a compressed table, check this page.

    Search for "22856" on both of them. I hope one of those links will help you solve the problem.

Posting Permissions

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