We have a view (below is the ddl) (view name is a)
Please help me, why this is happening.
When a table is created using CREATE TABLE AS SELECT all options revert back to default, e.g. all columns are NULLable, all indices are lost.
In your case you can do a
SET SESSION DATEFORM = ANSIDATE before or change you user's default
MODIFY USER xxx AS DATEFORM = ANSIDATE