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
Error report -
ORA-01460: unimplemented or unreasonable conversion requested
01460. 00000 - "unimplemented or unreasonable conversion requested"
*Cause:
*Action:


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).
 SQL
select column_name, data_type, data_length from all_tab_columns where table_name='table_name'




-i

Skip down to comments...
A quick disclaimer...

Although I put in a great effort into researching all the topics I cover, mistakes can happen. If you spot something out of place, please do let me know.

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.
 
comments powered by Disqus
Other posts you may like...