Category Archives: ORA Database Error Messages

ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP

oracle

ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP
Cause: Invalid LIMITMAP syntax, or the name resolution failure of an ANALYTIC WORSKPACE OBJECT
Action: Check the syntax of the limit map, check that the OLAP_TABLE function refers to a valid analytic workspace, check that all analytic workspace objects within the limitmap actually exist within the analytic workspace

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP

oracle

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP
Cause: There is no limitmap on the table function and either the datamap does not contain a fetch, or it errored before the fetch was called
Action: Check the datamap for errors, make sure that it executes a fetch statement, if it is not intended to execute the fetch then make sure that the table function has a valid limitmap

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP

oracle

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP
Cause: There is no limitmap on the table function and either the datamap does not contain a fetch, or it errored before the fetch was called
Action: Check the datamap for errors, make sure that it executes a fetch statement, if it is not intended to execute the fetch then make sure that the table function has a valid limitmap

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

oracle

ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
Cause: The OLAP table function given used more than one LOOP statement
Action: It is currently impossible to specify more than one LOOP composite, either remove one of the statements (and loop densely over relevant dimensions), or create a new composite that encompasses both loops and have a single loop statement refer to that

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36788: (IOSEC05) Access to the directory specified by string denied

oracle

ORA-36788: (IOSEC05) Access to the directory specified by string denied
Cause:
Action:

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36782: (IOSEC02) Directory Alias used in string does not exist, or you do not have sufficient privileges to access it

oracle

ORA-36782: (IOSEC02) Directory Alias used in string does not exist, or you do not have sufficient privileges to access it
Cause:
Action:

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36780: (IOSEC01) Current Directory Alias is not set. Cannot complete string

oracle

ORA-36780: (IOSEC01) Current Directory Alias is not set. Cannot complete string
Cause:
Action:

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified

oracle

ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified
Cause: Specified value for olap_page_pool_size out of range
Action: NONE

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36778: (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace

oracle

ORA-36778: (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace
Cause: Ran out of temporary tablespace storage
Action: Increase the amount of temporary tablespace storage

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace

oracle

ORA-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace
Cause: Ran out of temporary tablespace storage
Action: Increase the amount of temporary tablespace storage

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/