RUA Volunteer2?
asked on
PLSQL views that can help identify a specific record the type, the field and table names in a large Oracle DB. With NO Schema or knowledge of which table to start with?
I need to reverse engineer an Oracle database with no access to the DB schema or how the table relationships work. The software manufacturer will not allow anyone to know that and pressures its customers to purchase a very expensive report writer consultant that most customers would rather circumvent.
This expert comment shows information about Views that are available for the Oracle tool PLSQL Developer. "The views to get tables, columns and data types are readily available. Then you would just need to loop through them to build the SQL to select out the data."
Does anyone know what he is talking about and where I might find the code for this?
I assume I plug them into PLSQL and run it against the DB.
Is there a site with all this kind of info?
This expert comment shows information about Views that are available for the Oracle tool PLSQL Developer. "The views to get tables, columns and data types are readily available. Then you would just need to loop through them to build the SQL to select out the data."
Does anyone know what he is talking about and where I might find the code for this?
I assume I plug them into PLSQL and run it against the DB.
Is there a site with all this kind of info?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
ASKER
I thank you for that data modeler that looks promising. I also thank you for the tips on the programming.
That tool I spoke of was amazing to me at least because it helped me get at the data without any "database models"....where it shows all the tables in the database and links between them. I always thought that was called the "Database Schema." SQL Grep was a set and forget. It could run through a large database from anywhere from a minute to 12-15 minutes and since DB's can be so complex having the same record in multiple tables it was always helpful to see them all so I can figure out which one would be more efficient to use.
Again thank you. Now I just need to figure out how to build this concept in what looks like I will need JAVA for the GUI, Python or R and finally XML because it sounds like you are familiar with. I may be posting more questions on this which may teeter between Database and Programming forums.