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
Originally posted by hrishy The mysource.sql will contain the all the DDL for you ..you can grep for triggers,proceedures etc.. No, the indexfile does not contain any PL/SQL code. It only contains CREATE statements for tables (commented) and their corresponding indexes.
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
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
Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
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...
Amar "There is a difference between knowing the path and walking the path."
Forum Rules