Return
-
Title
Getting error "ORA-01843: not a valid month" when creating a Materialized View with the Toad Wizard -
Description
Getting error "ORA-01843: not a valid month" when creating a Materialized View with the Toad Wizard.
This happens when the language in Windows is set to Korean. -
Cause
The script generated by Toad includes the statement START WITH TO_DATE('16-11-2012','dd-mon-yyyy') .
The month is not properly converted. -
Resolution
WORKAROUND
Modify the script generated by Toad .For example in this case the correct statement would be START WITH TO_DATE('16-11-2012','dd-mm-yyyy')
STATUS
Waiting for fix in a future release of Toad for Oracle
-
Defect ID
104923