Page tree
Skip to end of metadata
Go to start of metadata

Message

"ORA-01795: maximum number of expression in a list is 1000."

Cause

You may encounter this message when running an export filtered by project. The error is due to an Oracle limitation. Oracle can contain no more than 1,000 expressions.

Solution

A possible work around would be to divide the export into two exports by adding Org Code into the selection criteria. You can get the same data you are looking for, and then concatenate the data together when done. 

For example, instead of this criteria:


Change the filter to:

Org Code = C001-001


Run export and download file.

Next, filter to:

Org Code = C02-TCF


Run export and download file, then combine the files together.