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

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.


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: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Have a look at this.
Just take the error code and Google it.


[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 Jul 22 18:16:46 CDT 2017

Total time taken to generate the page: 0.10959 seconds