Igor Kromin |   Consultant. Coder. Blogger. Tinkerer. Gamer.

A project I've recently started working on is moving away from a legacy Oracle 9i database and I'm helping with the data migration to a new system. That means that I still have to go and poke around the 9i system from time to time. My usual experience has been with Oracle 10g and up so I was surprised when I tried to run 'desc table_name' to get the following error...
Error report -
ORA-01460: unimplemented or unreasonable conversion requested
01460. 00000 - "unimplemented or unreasonable conversion requested"

Luckily the data dictionary still exists and it is still possible to get a description of your table using a standard SQL statement. The following SQL will do the trick... (replace 'table_name' with the actual name of your table).
select column_name, data_type, data_length from all_tab_columns where table_name='table_name'


A quick disclaimer...

Although I put in a great effort into researching all the topics I cover, mistakes can happen. Use of any information from my blog posts should be at own risk and I do not hold any liability towards any information misuse or damages caused by following any of my posts.

All content and opinions expressed on this Blog are my own and do not represent the opinions of my employer (Oracle). Use of any information contained in this blog post/article is subject to this disclaimer.
Hi! You can search my blog here ⤵
NOTE: (2022) This Blog is no longer maintained and I will not be answering any emails or comments.

I am now focusing on Atari Gamer.