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 biv343 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: *

  • Users: helpdbas
  • Content: Threads
  • Order by date
  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

    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