ORA Database Error Messages ORA-30487: ORDER BY not allowed here November 1, 2017 mpbod ORA-30487: ORDER BY not allowed here Cause: DISTINCT functions and RATIO_TO_REPORT cannot have an ORDER BY Action: none Back to previous menu https://support.oracle.com/ http://www.oracle.com/ Share this:Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Pocket (Opens in new window)