ora-03113 when use DESC in order by clause

[acacio]

select field1, field2 from table
order by 2 desc

not work property
in some situations it

 

[Marco Kalter]

ORA-03113 usually means that the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03113 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me by e-mail?

------------------
Marco Kalter
Allround Automations

 

[benthicsoftware]

Oracle 6? Does DOA even work with that version?

 

[acacio]

Sorry, Oracle 8.1.5

Originally posted by benthicsoftware:
Oracle 6? Does DOA even work with that version?