DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: analyze tabel VALIDATE STRUCTURE

  1. 08-09-2001, 12:24 PM #1
    elintrend
    elintrend is offline Member
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    Oracle8.06.1/NT4.0-sp6.
    There was a lock when 1 process by ERP and lock won't go away. I killed the session and re-ran the process, lock was back, then I killed/re-ran and lock kept coming back. This lock was on a master table and lock all the subsequence process- basically process just hang.

    I killed the session and ran analyze table validate structure and since then LOCK never came back. Does that mean I have a table corruption yesterday? How to avoid table/index corrution in the future?

    Thank you
    Elin@trend
    Reply With Quote Reply With Quote
  2. 08-13-2001, 01:36 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by elintrend
    Does that mean I have a table corruption yesterday? How to avoid table/index corrution in the future?
    Not necessarily. Your process may have been rolling back a transaction when you tried to kill it. Your process may be smart enough to know when it has died and restart itself. Kind of hard to say...
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width