Skip to Main Content

Database Software


For appeals, questions and feedback, please email

Replace LONG columns in Data Dictionary views

Chris HuntMar 19 2015 — edited Jan 11 2016

The LONG datatype has been deprecated for twenty years, yet they still feature in the Oracle data dictionary views, even (I think) relatively new ones like DBA_TAB_PARTITIONS.

LONG columns are a royal pain to deal with, and their presence in prominent Oracle-owned database objects send the message that it's a good idea to use them.

I realise that there are concerns about backward compatibility, but really, it's time to move on. If they can't be replaced, could we at least have CLOB versions of each LONG column added to the views?

Post Details
Added on Mar 19 2015