Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22856: cannot add columns to object tables
- 2 Answers
- 5868 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anil chechani
You might have not enough privileges to your tablespace, I
mean the tablespace may be 'READ ONLY'
So,I suggest check that and try to make "READ WRITE" mode
and try once again.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
Cause: An attempt was made to add columns to an object
table. Object tables cannot be altered to add columns since
its definition is based on an object type.
Action: Create a new type with additional attributes, and
use the new type to create an object table. The new object
table will have the desired columns.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-07448: ssarena: maximum number of shared arenas exceeded.
LSX-00175: a complex base within "simpleContent" must have simple content
SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF
ORA-16802: downgrading log transport mode from SYNC disallowed
NNL-00307: Server checkpointing its cache
SQL*Loader-00514: Error getting elapsed time
ORA-06909: CMX: error during acknowledge of ORACLE_SID
ORA-01185: logfile group number string is invalid
DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint
PCC-00146: Illegal value for host option, ignored
ORA-28028: could not authenticate remote server
QSM-01068: no dimensions present
Oracle Errors 
