DPA: Oracle data collections fail with: Failed to create temporary ORA table: ORA-01031: insufficient privileges
Summary: Data Protection Advisor: Oracle data collections fail with the following error: Failed to create temporary ORA table: ORA-01031: insufficient privileges
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
Data collection is succeeding but no data is showing in the reports for Oracle or RMAN.
Within the dpagent.log or run running the data collection in debug (Modtest) the following error is present:
DBG1 28262.28262 20180824:114359 sodbc.oracle.exec - cociCursorExec(): SQL is CREATE GLOBAL TEMPORARY TABLE t_database ON COMMIT PRESERVE ROWS AS SELECT * FROM v$database UNKN 28262.28262 20180824:114359 sodbc.oracle.exec - cociCursorExec(): error executing statement: 1031; ORA-01031: insufficient privileges ; SQL was CREATE GLOBAL TEMPORARY TABLE t_database ON COMMIT PRESERVE ROWS AS SELECT * FROM v$database DBG2 28262.28262 20180824:114359 sodbc.oracle.exec - cociCloseCursor(): transaction count zero, committing UNKN 28262.28262 20180824:114359 agent.mod.rman - createTempTablesForVirtualViews(): Failed to create temporary ORA table: ORA-01031: insufficient privileges
Cause
DPA requires CREATE TABLE privilege to be granted to the user account which DPA is utilizing to access the Oracle/RMAN DB. This additional permission was a change to resolve a bug in data collection and was introduced with the release of DPA 6.5.0 b12.
Resolution
To resolve this issue have the Oracle DBA do the following for the DPA user:
"grant create any table limited_user;"
This will set the permissions on the user account so it can create and remove global temporary tables on the DB.
The requirement for these additional permissions is documented in the release notes for DPA 6.5.0 b12 and above.
"grant create any table limited_user;"
This will set the permissions on the user account so it can create and remove global temporary tables on the DB.
The requirement for these additional permissions is documented in the release notes for DPA 6.5.0 b12 and above.
Please contact Dell EMC Technical Support for further details or information.
Article Properties
Article Number: 000167607
Article Type: Solution
Last Modified: 23 Oct 2025
Version: 4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.