Ralf Bender wrote:
> Sybrand Bakker wrote:
>
>> On Wed, 18 Feb 2004 20:28:37 +0100, Ralf Bender <ralf.bender_at_arcor.de>
>> wrote:
>>
>>
>>> Dear All,
>>>
>>> I'm urgent looking for Oracle 8.0.5 for Windows! It's no joke.
>>>
>>> On OTN there no link anymore for doenloading the old version. I need
>>> it temporary for reconstruction of the old database version.
>>>
>>> What happens:
>>> We got a normal file backup of all database files from one of our
>>> customers.
>>> Ok, I install Oracle 8.1.7 and copy all the files to the new
>>> installed database and start a migration. But there a some tables
>>> where I can't see any data. I got Oracle Error ORA-00604: error
>>> occurred at recursive SQL level 1 .
>>> I changed initora parameter for open cursor, but nothing would help.
>>>
>>> So, I hope to do the same with 8.0.5 and it will work. Or did someone
>>> know another way?
>>>
>>> regards
>>> ralf
>>
>>
>>
>> Why do you think you need to increase cursors when you get ora-604.
>> Ora-604 is the first line of an error stack and will result in a trace
>> file in the user_dump_dest directory. You would better address the
>> problem, you are now curing a symptom.
>>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
> why ? i read it somewhere in the newsgroups. it was also obsolete to me,
> but I think "changing the parameter could not damage anything"
> the only information after ora-604 is ora-904
ORA-904 means invalid column name - perhaps your 805 database used
column names that became reserved words by 817?
904s are usually seen during import/export as a result of not having run
catexp.sql...
--
Andy - Opinions are mine and do not necessarily reflect those of
Advantica Ltd
Received on Fri Feb 20 2004 - 06:04:12 CST