Re: so get a load of this - venting on support
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 1 Nov 2011 22:19:52 +0000
Message-ID: <CABe10sYi9ihS-EU9XGLpOeVCtK=bb_Wy_wua=WbR8w3smyQ-Sg_at_mail.gmail.com>
Presumably a la Note 370366.1? If so I'd be wondering what the improper entries were, how they got there and if there was an alternative (like removing the invalid entries). Now that note is suspiciously lacking version numbers, which given the advent of FAST DUAL in 10g might be somewhat problematic. They should however really point you at How to Recreate Dual Table (Doc ID 1163714.1) for this issue since this has the correct (IIRC) startup upgrade incantation!. Assuming that this is a fair summary of your problem I'd definitely give the feedback on what happened and how the response could have been improved (or indeed made to be accurate!). Is this by any chance a much upgraded database?
Date: Tue, 1 Nov 2011 22:19:52 +0000
Message-ID: <CABe10sYi9ihS-EU9XGLpOeVCtK=bb_Wy_wua=WbR8w3smyQ-Sg_at_mail.gmail.com>
Presumably a la Note 370366.1? If so I'd be wondering what the improper entries were, how they got there and if there was an alternative (like removing the invalid entries). Now that note is suspiciously lacking version numbers, which given the advent of FAST DUAL in 10g might be somewhat problematic. They should however really point you at How to Recreate Dual Table (Doc ID 1163714.1) for this issue since this has the correct (IIRC) startup upgrade incantation!. Assuming that this is a fair summary of your problem I'd definitely give the feedback on what happened and how the response could have been improved (or indeed made to be accurate!). Is this by any chance a much upgraded database?
On Tue, Nov 1, 2011 at 6:32 PM, <TESTAJ3_at_nationwide.com> wrote:
>
> Content-Type: text/plain; charset="US-ASCII"
> a SR is opened due to an issue with dbms_metadata.get_ddl.
>
> Solution: drop and recreate sys.dual,
>
> so the junior DBA does as said and now can't recreate due to ORA-1775
> looping chain of synonyms. I'm biting my tongue to not give support a
> real piece of my mind, oh and this was to an escalated individual.
>
> He comes and sees me to get it fixed, google comes to rescue on how to fix
> it but geez support, REALLY, DROP DUAL????
>
> joe
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 01 2011 - 17:19:52 CDT