ORA-01754: a table may contain only one column of type LONG - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 13, 2023 6:57:00 PM ● Video Link: https://www.youtube.com/watch?v=tSrjBsUh3bA

Duration: 1:53

9 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-01754: a table may contain only one column of type LONG
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.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database