In the last version of DBCleaner is functionality added for LogCleaning. This options has specific SQL for MS-SQL which didn't work in Oracle. The component is still marked as DBMS All.

GetLogTableRowCount contains several sys. tables that not exists in Oracle. This is a part of this SQL:

SELECT
   t.NAME AS TableName,
   p.rows AS RowCounts
FROM
   sys.tables t
INNER JOIN     
   sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
   sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
   sys.allocation_units a ON p.partition_id = a.container_id
LEFT JOIN
   {Entity} en on en.physical_table_name = t.name
LEFT JOIN
   {Espace} e ON e.id = en.espace_id
WHERE
   t.NAME NOT LIKE 'dt%'
   AND t.is_ms_shipped = 0
   AND i.OBJECT_ID > 255
   AND t.name like 'oslog%'
GROUP BY
    e.name, en.name, t.Name, p.Rows

At the start of DBCleaner is the application runs the preparation that uses this code in for instance LogCleanupFeatureAvailable.

Is there already somebody who is fix this for Oracle?

Regards,

Kees Kleybeuker