| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01498 ... need some help
What version of 7.3.4 ? If it is below 7.3.4.4 and have you rebuilt indexes
with parallel clause then it may be this problem. Drop those indexes of the
table which has more than one key and recreate those indexes. Then run again
analyze command.
Hope this helps.
Regards
Rafiq
From: "Bachmann, Henrik" <Henrik.Bachmann_at_bim-consulting.de>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: ORA-01498 ... need some help
Date: Thu, 07 Sep 2000 02:00:22 -0800
Hi there,
anybody out there who can give me a hint for the following problem?
There is an Oracle server 7.3.4 with several schemes and I have detected some data trash and now I am facing with the following error after an ANALYZE TABLE VALIDATE STRUCTURE CASCADE: ORA-01498 block Check Failure - see trace file Cause: An error occurred while checking a block with the ANALYZE command.
What I have to do now respectively what can I do now to detect the whole extent of the problem?
How can I determine the affected rows to remove the data trash?
What can I do to fix the problem?
Best regards
Henrik Bachmann mailto:Henrik.Bachmann_at_bim-consulting.de B.I.M.-Consulting Magdeburg http://www.bim-consulting.de/D-39124 Magdeburg
-- Author: Bachmann, Henrik INET: Henrik.Bachmann_at_bim-consulting.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile atReceived on Fri Sep 08 2000 - 15:28:43 CDT
 |
 |