How do i extract procedures / triggers /views alone from
export dump.
Printable View
How do i extract procedures / triggers /views alone from
export dump.
Hi
You could use imp userid=system/manager file=expdat.dmp rows=n indexes=n full=y indexfile=mysource.sql log=mylog.log
The mysource.sql will contain the all the DDL for you ..you can grep for triggers,proceedures etc..
regards
Hrishy
No, the indexfile does not contain any PL/SQL code. It only contains CREATE statements for tables (commented) and their corresponding indexes.Quote:
Originally posted by hrishy
The mysource.sql will contain the all the DDL for you ..you can grep for triggers,proceedures etc..
Hi Jmodic
That was faux-paus from my side..i am sorry..you are right..He should be using toad or soemthin for that
regards
Hrishy
Another option is to use the freeware databee tool, this will generate the required scripts
http://www.databee.com/dt_home.htm
Regards
yep thats an excellent tool...
removed a lot of headach...
the HTML output can be deployed on a webserver (i use apache)
helps in checking the database structure...