My Oracle Support Banner

OAC : How to increase number of rows for Exported to CSV/Excel in Oracle Analytics Cloud Service (Doc ID 2288114.1)

Last updated on NOVEMBER 19, 2019

Applies to:

Oracle Analytics Cloud - Classic - Version 17.1.3 and later
Oracle Analytics Cloud - Version 18.3.3 to 18.3.3 [Release 18]
Information in this document applies to any platform.

Goal

How to increase the number of rows when downloading to csv from OAC. Currently the following error is seen when exporting a report with close to million rows to csv :

State: HY000. Code: 60008. [nQSError: 60008] The query for user xyz exceeded the maximum query governing rows 100000 from the database

Solution

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
Goal
Solution
References

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