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-02816: Unable to kill a process

1 Answers  


ORA-02273: this unique/primary key is referenced by some foreign keys

2 Answers   KIIT,


ORA-16132: An error occurred during activation of the standby.

1 Answers  


QSM-01105: no primary key or row id in MV, string, is found for table, string

1 Answers  


ORA-03281: invalid ALLOCATE EXTENT option

1 Answers  






PCC-02200: found unrecognized punctuation sequence

1 Answers  


DRG-12504: stoplist string does not exist

1 Answers  


ORA-27041: unable to open file

1 Answers  


RMAN-06183: datafile or datafilecopy larger than MAXSETSIZE: file# string string

1 Answers  


ORA-14641: STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition

1 Answers  


NNL-00039: no RRs

1 Answers  


ORA-36682: (XSDPART20) Partition name string appears twice.

1 Answers  


Categories