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 SEPTEMBER 19, 2018

Applies to:

Oracle Analytics Cloud Service - Version 17.1.3 and later
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!


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