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

PLS-00259: rights model (AUTHID) must be specified

1 Answers  


ORA-09911: Incorrect user password.

1 Answers  


ORA-23318: a ddl failure has occurred

1 Answers  


RMAN-08542: channel string: starting proxy archivelog backup at string

1 Answers  


ORA-14113: partitioned table cannot have column with LOB datatype

1 Answers  






ORA-13053: maximum number of geometric elements in argument list exceeded

1 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


PCC-02405: Variable is of undefined type

1 Answers  


ORA-02713: osnprd: message receive failure

1 Answers  


ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

1 Answers  


DGM-16944: Failover succeeded. New primary is "string"

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


Categories