Knut Pfefferkorn wrote : >Hello,
>with some tables I get the following error: >select * from columns where tablename = 'MY_TABLE' >[SAP AG][LIBSQLOD SO][SAP DB]General error;-9205 POS(1) System error: >AK Catalog information not found:00000000000002FB001700. >the following query works fine: >select OWNER, COLUMNNAME,MODE,DATATYPE,LEN from columns where >tablename = 'MY_TABLE' >Do I have a corrupted catalog? >Is there a way to repair it, or do i need to recover a consistant >state from backup? Unfortunately it's true, your catalog is corrupt. For at least one column of your table 'MY_TABLE' the last alter date/time cannot be found anymore. Please try the following statement to repair the catalog : CHECK TABLE MY_TABLE CATALOG Be sure, that the you commit the transaction. If that does not help, you could try to copy the table into a new one, drop MY_TABLE and rename the new table to MY_TABLE, i.e. CREATE TABLE AUX AS SELECT * FROM MY_TABLE DROP TABLE MY_TABLE RENAME TABLE AUX TO MY_TABLE But please note, that this solution will drop all views, privileges etc. based on MY_TABLE. The last chance of course is a complete database recovery. I'm also interested in the reason for that corruption. Can you give me any hint, what kind of sql statement produced the problem ? Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
