Jump to content

Oracle Dba Discussion Board

KOTC

By KOTC
in Old Discussions

 Share

Recommended Posts

dkchinnari LEGEND

dkchinnari

Posted
Posted

[quote name='Silence..Please' timestamp='1367462894' post='1303694710']
[img]http://www.desigifs.com/sites/default/files/king_bemmi_recordit2.gif?1290371037[/img]
[/quote]Dengyyy

  • Replies 412
  • Created
  • Last Reply

Top Posters In This Topic

  • KOTC

    156

  • peru_edaite_enti

    40

  • deals2buy

    38

  • Gachibowli_Diwakar

    38

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

peru_edaite_enti
peru_edaite_enti

[quote name='STFU' timestamp='1364842055' post='1303522710'] [url="http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm"]http://docs.oracle.c...192/bkup004.htm[/url] [b] 4.4.4 Impro

KOTC Hero

KOTC

Posted
  • Author
Posted

[quote name='CheGuevara' timestamp='1367437543' post='1303692972']
evaridaggara aina oracle certification related dumps or practice tests unnaya.....or ekkada doukutayo cheppandi...
[/quote]


http://www.andhrafriends.com/topic/367440-o-r-a-c-l-e-c-e-r-t-i-f-i-c-a-t-i-o-n/page__st__30

juvenile Sr. Hero

juvenile

Posted
Posted

[color=#282828][font=helvetica, arial, sans-serif]selecting from dba_triggers and and have to delete those triggers from database....[/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set trims on[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set pages 0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]spool Trigger_list_$SCHEMA[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]select trigger_name from user_triggers;[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]for i in `cat Trigger_list_$SCHEMA`[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]do[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]done[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]@delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]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 ..[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]i just need trigger names .. nothing else in spool[/font][/color]

juvenile Sr. Hero

juvenile

Posted
Posted

i have to delete all the triggers for specific User !!!!

How to do it

peru_edaite_enti Celebrity

peru_edaite_enti

Posted
Posted

[quote name='STFU' timestamp='1367526837' post='1303698129']


[url="http://www.andhrafriends.com/topic/367440-o-r-a-c-l-e-c-e-r-t-i-f-i-c-a-t-i-o-n/page__st__30"]http://www.andhrafri...-n/page__st__30[/url]
[/quote]


andulo ee links uu pani chestaledu kada bhayya....

peru_edaite_enti Celebrity

peru_edaite_enti

Posted
Posted

[quote name='AggiRamudu' timestamp='1367528264' post='1303698239']
i have to delete all the triggers for specific User !!!!

How to do it
[/quote]

ask your DBA to do it vayya.. kasta aniki kuda pani iyyarade

KOTC Hero

KOTC

Posted
  • Author
Posted

[quote name='CBZ' timestamp='1367528810' post='1303698293']
andulo ee links uu pani chestaledu kada bhayya....
[/quote]


Akkada adigav kadha naku no idea,adi gurthu unde so adi paste chesa anthe

juvenile Sr. Hero

juvenile

Posted
Posted

[quote name='CBZ' timestamp='1367528833' post='1303698296']
ask your DBA to do it vayya.. kasta aniki kuda pani iyyarade
[/quote]

Ne ne DBA vayya ...

sSc_hidingsofa[size=4] [/size][size=4] sSc_hidingsofa[/size]

[color=#282828][font=helvetica, arial, sans-serif][size=4]selecting from dba_triggers and and have to delete those triggers from database....[/size][/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set trims on[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set pages 0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]spool Trigger_list_$SCHEMA[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]select trigger_name from user_triggers;[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]for i in `cat Trigger_list_$SCHEMA`[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]do[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]done[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]@delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]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 ..[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]i just need trigger names .. nothing else in spool[/font][/color]

KOTC Hero

KOTC

Posted
  • Author
Posted

[quote name='AggiRamudu' timestamp='1367528971' post='1303698310']
Ne ne DBA vayya ...

sSc_hidingsofa[size=4] sSc_hidingsofa[/size]

[color=#282828][font=helvetica, arial, sans-serif][size=4]selecting from dba_triggers and and have to delete those triggers from database....[/size][/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set trims on[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set pages 0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]spool Trigger_list_$SCHEMA[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]select trigger_name from user_triggers;[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]for i in `cat Trigger_list_$SCHEMA`[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]do[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]done[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]@delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]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 ..[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]i just need trigger names .. nothing else in spool[/font][/color]
[/quote]


asalu ne em cheyali anukuntav adi chepu daily job adi leka endi asalu matter enti

juvenile Sr. Hero

juvenile

Posted
Posted

[quote name='STFU' timestamp='1367529164' post='1303698329']


asalu ne em cheyali anukuntav adi chepu daily job adi leka endi asalu matter enti
[/quote]

oka user create chesina triggers mottam delete cheyyali !!

ala oka 10,15 users ..10,15 systems lo delete cheyyali ..

Rather than doing it one by one .. i am planning to automate it ..

Script raasanu ..

This part trigger names output to Trigger_list_$SCHEMA file ..

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]set trims on[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]set pages 0[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]spool Trigger_list_$SCHEMA[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]select trigger_name from user_triggers;[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]exit[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]END_PROC[/background][/size][/font][/color]

This part creates a SQL file containg SQL commands to delete all those triggers

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]for i in `cat Trigger_list_$SCHEMA`[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]do[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]done[/background][/size][/font][/color]

ee part executing SQL file to delete triggers

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]@delete_triggers.sql[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]exit[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]END_PROC[/background][/size][/font][/color]




[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]Ippudu first part lo spool ni trim cheyyali .. ledante un-necessary ga SPOOL OFF , ivanni coming .. which inturn adding to SQL file in step 2 and step 3 error out autundi .. [/background][/size][/font][/color]

peru_edaite_enti Celebrity

peru_edaite_enti

Posted
Posted

LTT... "scripting ante ACP mayya.. ACP mayya ante scripting" aaina oche varaku lift cheddam

nexus Jr Artist

nexus

Posted
Posted

[quote name='AggiRamudu' timestamp='1367529411' post='1303698343']
oka user create chesina triggers mottam delete cheyyali !!

ala oka 10,15 users ..10,15 systems lo delete cheyyali ..

Rather than doing it one by one .. i am planning to automate it ..

Script raasanu ..

This part trigger names output to Trigger_list_$SCHEMA file ..

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]set trims on[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]set pages 0[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]spool Trigger_list_$SCHEMA[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]select trigger_name from user_triggers;[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]exit[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]END_PROC[/background][/size][/font][/color]

This part creates a SQL file containg SQL commands to delete all those triggers

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]for i in `cat Trigger_list_$SCHEMA`[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]do[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]done[/background][/size][/font][/color]

ee part executing SQL file to delete triggers

[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]@delete_triggers.sql[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]exit[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]END_PROC[/background][/size][/font][/color]




[color=#282828][font=helvetica, arial, sans-serif][size=2][background=rgb(247, 247, 247)]Ippudu first part lo spool ni trim cheyyali .. ledante un-necessary ga SPOOL OFF , ivanni coming .. which inturn adding to SQL file in step 2 and step 3 error out autundi .. [/background][/size][/font][/color]
[/quote]

Test with the below script


sqlplus[color=#ff0000] -s [/color]username/password << EOF
[color=#ff0000]set feedback off lin 300 pages 300 echo off heading off[/color]
spool test.spool
select count(*) from user_objects;
spool off
exit;
EOF

superhit Sr. Hero

superhit

Posted
Posted

recordset vunna data nu how to assign it to a variable using VB Script....yevaraina easy ga code veyyandi plz

CheGuevara Sr. Hero

CheGuevara

Posted
Posted

[quote name='AggiRamudu' timestamp='1367528239' post='1303698235']
[color=#282828][font=helvetica, arial, sans-serif]selecting from dba_triggers and and have to delete those triggers from database....[/font][/color]


[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set trims on[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]set pages 0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]spool Trigger_list_$SCHEMA[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]select trigger_name from user_triggers;[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]for i in `cat Trigger_list_$SCHEMA`[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]do[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]echo "DROP TRIGGER '$i'" >> delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]done[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]sqlplus $SCHEMA/$PASSWORD <<END_PROC[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]@delete_triggers.sql[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]END_PROC[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]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 ..[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]i just need trigger names .. nothing else in spool[/font][/color]
[/quote]

set echo off

edi use chey ravu avi

KOTC Hero

KOTC

Posted
  • Author
Posted

Oracle DBA positions internal ga em ayina unte chepandi vayya.

 Share
Go to topic listing
×
×
  • Create New...