View definitions cannot have an ORDER BY clause, nor are they needed. You should order your result set when you're selecting from the view, e.g.:

select * from myView order by col1, col2

HTH