Creating an AWR Snapshot fails on old (10.2) databases

Toad for Oracle - Beta
1

I tried to create an AWR Snapshot on a 10.2 DB and got the error:

ORA-00907: missing right parenthesis

This is because the following statement is executed:

SELECT sys.dbms_workload_repository.create_snapshot(Flush_level => 'ALL') as ID
FROM DUAL;

But 10.2 doesn't known named parameters in SQL.

BR
Dirk

2

Hi Dirk,

Thanks for the info. I'll fix it

-John