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

ORA-14454: attempt to reference temporary table in a referential integrity constraint

1 Answers  


ORA-28154: Proxy user may not act as client 'string'

1 Answers  


ORA-22312: must specify either CASCADE or INVALIDATE option

1 Answers  


PLS-00658: constructor method name must match type name

1 Answers  


ORA-01179: file string does not exist

1 Answers  






ORA-12654: Authentication conversion failed

1 Answers  


ORA-03296: cannot resize datafile - file string not found

1 Answers  


PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parameters

1 Answers  


ORA-13337: failure in concatenating LRS polygons

1 Answers  


ORA-16024: parameter string cannot be parsed

1 Answers  


PROT-00007: Failed to open the specified import file

1 Answers  


ORA-16540: invalid argument

1 Answers  


Categories