ORA-01821: date format not recognized

[big]

Hi,
On 11.2.0.4
I have the following problem:

SQL> select count(*) from all_tables where owner='APPLSYS' and to_char (last_analyzed,'DD-MMM-YY')='01-NOV-12';

                                                                                 *
ERROR at line 1:
ORA-01821: date format not recognized

What might be the correct format for date?

'DD-MON-YY' would be I think.

Thanks and regards.

[ErmanArslansOracleBlog]

Use -> DD-MON-YY