The biggest trouble comes with every new release. To enhance our application we have to know about the latest state of all DB objects. To find this out, we have to run through the history of all PL/SQL files.
There must be a better way to solve this problem. We want something like "export all objects" so we get a lot of SQL files that contain the definitions of all objects. We take these files and put them into our new DB, so we have the latest state of the DB (without running through the history).
Dig deeper on Using Oracle PL-SQL
Related Q&A from Mike Ault, Senior Oracle Consultant, Burleson Consulting
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.