Home » SQL & PL/SQL » SQL & PL/SQL » error adding column (oracle 9.2.0.8 on unix)
error adding column [message #416823] Tue, 04 August 2009 08:35 Go to next message
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.

Re: error adding column [message #416824 is a reply to message #416823] Tue, 04 August 2009 08:49 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have a look at this.
Just take the error code and Google it.

By
Vamsi

[Updated on: Tue, 04 August 2009 08:55]

Report message to a moderator

Previous Topic: Reg Dynamic sql in stored proc (merged)
Next Topic: Insert data in Oracle table from text file or Excel file
Goto Forum:
  


Current Time: Sat Dec 10 11:10:28 CST 2016

Total time taken to generate the page: 0.20577 seconds