OAC : How to increase number of rows for Exported to CSV/Excel in Oracle Analytics Cloud Service

(Doc ID 2288114.1)

Last updated on OCTOBER 05, 2017

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

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