juvenile Posted May 2, 2013 Report Posted May 2, 2013 script raastunnanu .. selecting from dba_triggers and and have to delete those triggers from database.... sqlplus $SCHEMA/$PASSWORD <<END_PROC set trims on set pages 0 spool Trigger_list_$SCHEMA select trigger_name from user_triggers; exit END_PROC for i in `cat Trigger_list_$SCHEMA` do echo "DROP TRIGGER '$i'" >> delete_triggers.sql done sqlplus $SCHEMA/$PASSWORD <<END_PROC @delete_triggers.sql exit END_PROC Problem enti ante Spool lo starting SQL command , exit , 120 rows selected avanni vastunai .. vaatini raakunda edo set command untundi kada .. adi enti .. enni try chesina ravatla .. i just need trigger names .. nothing else in spool
juvenile Posted May 2, 2013 Author Report Posted May 2, 2013 [quote name='Jambal_haat' timestamp='1367527539' post='1303698186'] [/quote] tq
KOTC Posted May 2, 2013 Report Posted May 2, 2013 LTT ikkada kuda oka post veyi http://www.andhrafriends.com/topic/384232-oracle-dba-discussion-board/page__st__345
KOTC Posted May 2, 2013 Report Posted May 2, 2013 [font=helvetica, arial, sans-serif][color=#282828][size=3] [/size][/color][/font]
juvenile Posted May 2, 2013 Author Report Posted May 2, 2013 [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set echo off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set verify off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set feedback off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set headings off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set trimspool on[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set termout off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]did the trick !![/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Still last line lo [/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]SQL>exit[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]vastundi .. i can change script to delete lastline of spool[/background][/size][/font][/color]
KOTC Posted May 2, 2013 Report Posted May 2, 2013 [quote name='AggiRamudu' timestamp='1367528741' post='1303698285'] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set echo off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set verify off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set feedback off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set headings off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set trimspool on[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]set termout off[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]did the trick !![/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Still last line lo [/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]SQL>exit[/background][/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]vastundi .. i can change script to delete lastline of spool[/background][/size][/font][/color] [/quote]
Recommended Posts