Running Large Queries in Discoverer User Edition Is Limited to 10,000 Rows
Last updated on MARCH 08, 2017
Applies to:Oracle Discoverer - Version 4.1.37 to 220.127.116.11.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 23-Feb-2012***
*** Checked for relevance on 1-Aug-2013 ***
Large queries in Discoverer User Edition, any editions (Desktop, Viewer, Plus, Portlet) and any version (from 4i to 11g) are limited to 10000 rows.
This may not appear immediately, especially with tabular worksheets, where Discoverer initially fetch the rows that are displayed and not the entire query dataset. This however, can occurs when all the rows are retrieved from the database for the tabular worksheet or when the worksheet is exported to a file or when a crosstab worksheet is open, as it will retrieve all rows for a correct data aggregation, in these cases a message like the following is displayed :
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms