- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 66 Insurance
- 536.8K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Replace LONG columns in Data Dictionary views
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?