Running Large Queries in Discoverer User Edition Is Limited to 10,000 Rows (Doc ID 1117467.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Discoverer - Version 4.1.37 to 11.1.1.7.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 ***

Symptoms

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 :

NOT ALL ROWS EXPORTED THE RESULT MAY BE INACCURATE

Cause

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