There is nothing wrong with your create view statement.
Where are you trying to run it, on SQLPLUS?

If so the paste a snapshot of:

SQL> desc xy_table
SQL> create view test_v as
select x, y from xy_table
order by x,y;

including the output you get.

Thanks.

Syed