var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter Table Problem
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?
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.