How to get object discription from databases using a script.
Posted on 2014-07-22
I have a data base having 160 tables. I need a SQL script which can output table name and its description
accessing oracle metadata.
The script should spool output the Describe Table for each and every table in following way.
1) desc TableA
2) desc TableB
Basically I want to compare the same set of tables between the 2 data bases to find the deviations since they exists in our environment.
deviations like 2 different data types
more columns in one DB and less in other for the same table.
If I can spool information in a text file I can find diff using a tool. If there is another easier way without creating db_links I will go for it.
Please help me to find a way without comparing table by table manually.