ORA-01754: a table may contain only one column of type LONG



ORA-01754: a table may contain only one column of type LONG..

Answer / guest

Cause: An attempt was made to add a LONG column to a table
which already had a LONG column. Note that even if the LONG
column currently in the table has already been marked
unused, another LONG column may not be added until the
unused columns are dropped.

Action: Remove the LONG column currently in the table by
using the ALTER TABLE command.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NCR-03006: NCRO: Invalid operation

1 Answers  


PLS-00635: method does not override

1 Answers  


ORA-16570: operation requires restart of database "string"

1 Answers  


O2F-00319: No OUTTYPE file specified

1 Answers  


LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  






PCC-00116: This array already given in an ARRAYLEN statement

1 Answers  


ORA-30130: invalid parameter key type received

1 Answers  


ORA-14304: List partitioning method expects a single partitioning column

1 Answers  


ORA-06563: top level procedure/function specified, cannot have subparts

1 Answers  


ORA-19909: datafile string belongs to an orphan incarnation

2 Answers  


DRG-12302: invalid column list

1 Answers  


ORA-27036: translation error, unable to expand file name

1 Answers  


Categories