My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

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. ***   ***

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.