Hi We had a different problem with our upgrade but the same error message - there is a patch available from Oracle that is supposed to help(did n't for us though)
Regards, N. -----Original Message----- [EMAIL PROTECTED] Sent: 01 April 2003 09:04 To: Multiple recipients of list ORACLE-L Hi gurus, I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on Windows 2000) but when I try to query my partitoned tabless I get the error ORA-00604 'error occured at recursive SQL level 1' ORA -00904 'Invalid column name' I have run the scripts U0801060.sql (which calls catalog.sql and catproc.sql) in vain. I can access unpartitioned tables without errors. Any ideas? Moses Mmoya This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
