I am a new employee attempting to support an Oracle database. I have 20 years experience building and maintaining SQL Server applications. There are over 100 tables in the Oracle database. Application, database, and code modules are not documented. The company and I depend on getting information from 10 year veterans. It is not surprising that IT support people last less than 6 months.
What Oracle database documentation software do you recommend.
I am looking at DBScribe. I need to list table names and descriptions, and column names and descriptions.
Column Name Column Description
Master_RevNum Foreign key to the Revision table
Master_OrdNum Foreign key to the Order table
Master_ChgNum Foreign key the Changes table
I will enter the object descriptions.