0 Replies Last post: Feb 10, 2012 11:50 AM by Community Admin  
Novice 44 posts since
Mar 30, 2009
Currently Being Moderated

Feb 10, 2012 11:50 AM

Oracle Discoverer Not all rows have been retrieved

Running a query in Oracle Discoverer (10g, 11g) that contains over 10,000 records, results in warning 'Not all rows have been retreived.  Data may be innacurate'.

 

Solution: Open Discoverer Plus or Desktop, click on Tools > Options > 'Query Governor' tab, then in section 'Query Governor' uncheck the box 'Limit retrieved data to:'.  Click OK to apply.

 

Close and re-open the worksheet.  All records should be displayed.

More Like This

  • Retrieving data ...