Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. helpdbas

    Replication Distribution Administrative Link Password missing

    The old DBA took with him the password for the Distribution Administrative Link, so I am unable to create a new Publisher and select this Distributor as the remote distributor. We are already live in production using another Publisher and this current Distributor so I cannot change the password...
  2. helpdbas

    Transaction still running in a loop after kill immediate

    My transaction is still running using a loop and the entire transaction will not kill. How do you kill the entire transaction if there is a loop?
  3. helpdbas

    kill sessions using loop

    It works!!! Thank you for teaching me about these set commands. This will be a big help for our company. Thanks for helping me look good. :)
  4. helpdbas

    kill sessions using loop

    Didn't work for me... I tried "set echo off" before the prior posting but it didn't seem to do anything and I'm not sure why? Could it be this version??
  5. helpdbas

    kill sessions using loop

    I'm not too familiar with all of the set commands to make it work this way, however I'm close to getting it working like you suggested. Can you help with how to get the output file to contain only my output from sql I run? HERE IS WHAT I DO IN SQL PLUS: set heading off SPOOL e:\test.sql...
  6. helpdbas

    kill sessions using loop

    Yep, Oracle 8.0.5 is old and we'd like to upgrade, but we aren't right at the moment. Any more takers? What's wrong with my code? It looks like it would work if I had the proper quotes or something. TYIA!
  7. helpdbas

    kill sessions using loop

    Immediate doesn't work ... Immediate is highlighted with an error stating "encountered the symbol "IMMEDIATE" when expecting one of the following :=.(@%; Any more suggestions?
  8. helpdbas

    kill sessions using loop

    I'm trying to kill sessions on a very old Oracle server (8.0.5.0) with the following script: begin for x in (select SID,Serial#,status,last_call_et,username from v$session where type='USER' and status='INACTIVE' and username = 'TESTER' and last_call_et > 1200 ) loop...

Part and Inventory Search

Back
Top