Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-25 Thread Rick Westbrock
the cause and how to fix it first. -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Friday, September 25, 2015 12:37 AM To: arslist@ARSLIST.ORG Subject: Re: How does one track down a missing or broken DB table (ARERR 481

Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-25 Thread Walters, Mark
e the case - a table accessed via a db link for example? Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: 24 September 2015 20:23 To: arslist@ARSLIST.ORG Subject: Re: How does one track down a missing or broken DB table (ARER

Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-24 Thread Jason Miller
1007230200) > > > /* Thu Sep 24 2015 07:43:18.2519 */CONNECT > ARAdmin > > > /* Thu Sep 24 2015 07:43:18.3376 */SELECT > BANNER FROM V$VERSION > > > > > > -Rick > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@A

Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-24 Thread Rick Westbrock
8:45 AM To: arslist@ARSLIST.ORG Subject: Re: How does one track down a missing or broken DB table (ARERR 481)? ** Rick, I recommend this article :) https://docs.bmc.com/docs/display/public/ars81/Running+the+database+consistency+checker On Thu, Sep 24, 2015 at 9:27 AM, Rick Westbrock

Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-24 Thread LJ LongWing
Rick, I recommend this article :) https://docs.bmc.com/docs/display/public/ars81/Running+the+database+consistency+checker On Thu, Sep 24, 2015 at 9:27 AM, Rick Westbrock wrote: > ** > > A while back my development server started throwing ARERR 481 on startup > where the log only says "Requested

Re: How does one track down a missing or broken DB table (ARERR 481)?

2015-09-24 Thread Jarl Grøneng
Hi You can turn on sql-logging. Another option is this tool: https://docs.bmc.com/docs/display/public/ars81/Running+the+database+consistency+checker -- J 2015-09-24 17:27 GMT+02:00 Rick Westbrock : > ** > > A while back my development server started throwing ARERR 481 on startup > where the lo

How does one track down a missing or broken DB table (ARERR 481)?

2015-09-24 Thread Rick Westbrock
A while back my development server started throwing ARERR 481 on startup where the log only says "Requested database table not found. Please check the spelling (table name is case-sensitive)". I was really disappointed to see that it did not actually list the table with which it was having prob