How can I export from the command line (or
how must my command be) all triggers, procedures, functions, etc.,
from an Oracle Database?
I'm not advancing at all in this moment.
Thanks indeed for your help.
This question posed on 18 November 2005
Answer:
It would depend on what you wished to do
with them, if it is simply to move from one Oracle database to
another then the export command using the rows=n and indexes=n
options would probably get you close. There are also tools available
to mine the export file for the code.
One thing to be aware of, the Oracle provided
packages and procedures are usually "wrapped" which means encrypted.
For just the SQL to build the objects, look at
the package dbms_metadata.
