ORA-23291: Only base table columns may be renamed



ORA-23291: Only base table columns may be renamed..

Answer / guest

Cause: Tried to rename a column of a non-base table, like
object table/ nested table/ materialized view table.

Action: None. This is not allowed.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09320: szrfc: unable to obtain the list of valid OS roles

1 Answers  


ORA-23302: application raised communication failure during deferred RPC

1 Answers  


ORA-37113: OLAP API initialization error: (string)

1 Answers  


ORA-29827: keyword USING is missing

1 Answers  


ORA-13376: invalid type name specified for layer_gtype parameter

1 Answers  






ORA-06702: TLI Driver: cannot allocate context area

1 Answers  


ALTER TABLE JAFAR_BIZREN_REDUMPTION_DATA1 RENAME COLUMN DROP_POINT TO DEPOT_ID

0 Answers   Oracle,


PLS-00720: type 'string' has evolved

1 Answers  


RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?

1 Answers  


ORA-07707: error in archive text: need tape label name

1 Answers  


ORA-01494: invalid SIZE specified

1 Answers  


QSM-00774: there are no SQL statements to process for task string

1 Answers  


Categories