Re: Basic SQL Error Handling Qs ?

Hi,

I understand that the files are lost forever and judging from the filenumber it is probably a fairly large database, but from a support point of view I would probably still consider looking at fixing this issue.

Otherwise You'd probably be looking at individual table analyzes excluding the ones in the missing datafile(s)

brgds

Jack

On 24/12/2007, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
>
> Thanks for responding.
>
> Fixing the underlying issue is NOT possible as the respective MISSING
> files have been LOST forever.
>
> Degree=48 used as the Machine is a SF15K Server with 24 CPUs
>
> Cheers
>
>
> ________________________________
> From: sol beach [sol.beach_at_gmail.com]
> Sent: Monday, December 24, 2007 10:32 AM
>
> DEGREE=48?????????
>
> What metrics led to using this value?
>
> Why don't you fix the under lying problem of "MISSING" files; rather than
> fight resultant symptoms?
>
> On Dec 23, 2007 7:06 PM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com<mailto:
> VIVEK_SHARMA_at_infosys.com>> wrote:
>
> Folks
>
> Ran the following SQL with 48 Parallel processes (degree=48) to get the
> Error below.
> NOTE - This error is expected as some Datafiles are MISSING from the
> Database & hence
>
> Qs Is it possible for the same SQL Statement to continue executing inspite
> of the error i.e. to ignore the error
> Qs Will "exec sql whenever sqlerror continue" achieve this ELSE what other
> options exist?
>
> Cheers & Thanks
>
> SQL:-
> begin
> dbms_stats.gather_schema_stats(
> ownname => ...,
> degree => 48
> );
> end;
> ERROR:-
> ORA-12801: error signaled in parallel query server P059
> ORA-00376: file 1235 cannot be read at this time
> ORA-01111: name for data file 1235 is unknown - rename to correct file
> ORA-01110: data file 1235: '/oracle/.../MISSING01235'
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
J.A. van Zanen

--
http://www.freelists.org/webpage/oracle-l