Use the clearMdex operation in the Data Ingest Web Service to remove all data records and also the schema records that define the data store configuration).
<ingest:clearMdex/>
To remove all records from the Oracle Endeca Server:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ingest="http://www.endeca.com/MDEX/ingest/1/0"> <soapenv:Header/> <soapenv:Body> <ingest:clearMdex> <ingest:OuterTransactionId>txId</ingest:OuterTransactionId> </ingest:clearMdex> </soapenv:Body> </soapenv:Envelope>This request removes the data records and the schema records in the data store.
<ingest:clearMdexResponse> <ingest:OuterTransactionId>txId</ingest:OuterTransactionId> <ingest:numRecordsDeleted>175</ingest:numRecordsDeleted> </ingest:clearMdexResponse>
Note that if you specify an outer transaction ID that does not match the ID of the currently running transaction, the clearMdex operation fails, notifying you of the transaction ID that is in progress. In addition, if no outer transactions have been started with the Transaction Web Service, but you still specify an element with the value for an ID, this request also fails.
After you have removed all the data and schema records from the data store, you want to provision it again with the default configuration settings. To provision the data store, run provisionMdex.