error adding column [message #416823] |
Tue, 04 August 2009 08:35  |
goo321
Messages: 28 Registered: June 2008 Location: houston
|
Junior Member |
|
|
When I try to add a column to a table I get the following error message.
ALTER TABLE CDRMSC2.FT_CDR_I ADD (operator NUMBER)
Error at line 3
ORA-22856: cannot add columns to object tables
This partitioned table has only number and varchar2 columns.
Any ideas what is going on?
You can add a column on a compressed table in oracle 10 but not 9, I believe.
I have tried to pinpoint the exact condition that this happens to. But I have not been able to narrow it down yet. (Partitions, indexes, data in table, and so on. )
It would be difficult to create a new table and copy the data as some of the tables in production are half a terabyte. The only backup solution I have is making a new table, making a view combining new and old table, with the view name same as the old table.
Thanks.
|
|
|
|