Re: Oracle Error 600, [733] ...
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 25 Feb 2010 06:45:42 -0800 (PST)
Message-ID: <38b724e9-35e9-48cb-844a-860438eb8d1c_at_o30g2000yqb.googlegroups.com>
On Feb 25, 8:48 am, Andreas Mosmann <mosm..._at_expires-28-02-2010.news- group.org> wrote:
> gazzag schrieb am 23.02.2010 in
> <8eeb5157-7099-4400-813c-8b5e67b21..._at_s17g2000vbs.googlegroups.com>:
>
>
>
>
>
> > On 22 Feb, 10:10, Andreas Mosmann <mosm..._at_expires-28-02-2010.news-
> > group.org> wrote:
> >> Hi,
>
> >> For case of statistics there is made a copy from a database some time
> >> ago. I produced a SQL- Statement, that worked fine on the actual
> >> database, but when I use the same statement on the other DB I got an
> >> Oracle Error 600, followed by some values (the 1st is 733).
> >> I do not know the differences between both DBs exactly, but of course
> >> the admin changed some preferences for this one way DB. When I looked
> >> for the reason of this error to find out, which changes are to be made
> >> to get the results of my statement, I read, that there is/was a
> >> metalink- Page, that describes some/all 600- errors depending on the 1st
> >> parameter.
> >> I could not connect to metalink (I did it last time many month ago),
> >> because it did not only want to get to know very much of my personal
> >> state, but any kind of service number. Assuming that there is no free
> >> way to go there anymore I like to ask you the following:
> >> - Is there someone, who knows about this web form? Does it exist
> >> anymore, so that it is useful to buy such service number?
> >> - Does anybody know the problem OE 600, [733]?
>
> >> Best regards
> >> Andreas
>
> >> Oracle 9.2.0.7.0
>
> > Try patching to 9.2.0.8 and get back to us.
>
> thank you for your correct answer. I know this is the correct answer to
> all the questions outside including questions for the wheather of the
> next 10 years, but I can not do this (neither I nor the admin) because
> this has to be kept unchanged (If I would believe that an upgrade would
> solve this problem I probably could built an independent new database
> with the same data, but I am afraid I don't. Metalink told, that such
> bug should be handled in 9.2.0.5 so I suppose I have a similar but not
> the same. And I don't believe that especially this bug is fixed in
> 9.2.0.8 if a solve is mentioned for .5). So I have to find a work around
> for this.
> Do you have the 2nd best answer for me?
>
> > </Oracle support>
> > -g
>
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de- Hide quoted text -
>
> - Show quoted text -
Date: Thu, 25 Feb 2010 06:45:42 -0800 (PST)
Message-ID: <38b724e9-35e9-48cb-844a-860438eb8d1c_at_o30g2000yqb.googlegroups.com>
On Feb 25, 8:48 am, Andreas Mosmann <mosm..._at_expires-28-02-2010.news- group.org> wrote:
> gazzag schrieb am 23.02.2010 in
> <8eeb5157-7099-4400-813c-8b5e67b21..._at_s17g2000vbs.googlegroups.com>:
>
>
>
>
>
> > On 22 Feb, 10:10, Andreas Mosmann <mosm..._at_expires-28-02-2010.news-
> > group.org> wrote:
> >> Hi,
>
> >> For case of statistics there is made a copy from a database some time
> >> ago. I produced a SQL- Statement, that worked fine on the actual
> >> database, but when I use the same statement on the other DB I got an
> >> Oracle Error 600, followed by some values (the 1st is 733).
> >> I do not know the differences between both DBs exactly, but of course
> >> the admin changed some preferences for this one way DB. When I looked
> >> for the reason of this error to find out, which changes are to be made
> >> to get the results of my statement, I read, that there is/was a
> >> metalink- Page, that describes some/all 600- errors depending on the 1st
> >> parameter.
> >> I could not connect to metalink (I did it last time many month ago),
> >> because it did not only want to get to know very much of my personal
> >> state, but any kind of service number. Assuming that there is no free
> >> way to go there anymore I like to ask you the following:
> >> - Is there someone, who knows about this web form? Does it exist
> >> anymore, so that it is useful to buy such service number?
> >> - Does anybody know the problem OE 600, [733]?
>
> >> Best regards
> >> Andreas
>
> >> Oracle 9.2.0.7.0
>
> > Try patching to 9.2.0.8 and get back to us.
>
> thank you for your correct answer. I know this is the correct answer to
> all the questions outside including questions for the wheather of the
> next 10 years, but I can not do this (neither I nor the admin) because
> this has to be kept unchanged (If I would believe that an upgrade would
> solve this problem I probably could built an independent new database
> with the same data, but I am afraid I don't. Metalink told, that such
> bug should be handled in 9.2.0.5 so I suppose I have a similar but not
> the same. And I don't believe that especially this bug is fixed in
> 9.2.0.8 if a solve is mentioned for .5). So I have to find a work around
> for this.
> Do you have the 2nd best answer for me?
>
> > </Oracle support>
> > -g
>
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de- Hide quoted text -
>
> - Show quoted text -
You might consider opening a SR. It is possible the fix requries a one off patch or was delivered via a CPU patch set and was not automatically included in the base patch level.
HTH -- Mark D Powell -- Received on Thu Feb 25 2010 - 08:45:42 CST