Hi, I've a problem creating an index in our database. The tool xsql tells me, that the index already exists, but this isn't the case.
have a look: ============================================================================ =================== linux:/opt/sapdb/depend/bin # xsql -d DBNAME -u USER,PASSWORD > select * from domain.indexes where tablename ='TAB_SHIPPINGSTATUS' OWNER | TABLENAME | INDEXNAME | TYPE | CREATEDATE | CREATETI | USER | TAB_SHIPPINGSTATUS | DATETIME | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | DISPONENT_ID | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | SHIPMENT_NUMBER | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | TOUR_ID | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | TYPE | | 2030.11.22 | 00:11:22 | * Ok > CREATE INDEX "SHIPPINGSTATUS_SHIPPER_ID" ON TAB_SHIPPINGSTATUS(SHIPPER_ID) * -6008: Duplicate index name > > quit ============================================================================ =================== I can't find the problem, so I hope that somebody knows the solution ;-) thanks ...GERD... -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
