What is the SYS.ORA_TEMP_1_DS_% table sometimes seen in a running query in RSA Identity Governance & Lifecycle
Originally Published: 2015-06-29
Article Number
Applies To
RSA Version/Condition: All
Platform: Oracle
Issue
Below is an example of such a query:
insert /*+ append */ into sys.ora_temp_1_ds_2666110 SELECT /*+ parallel(t,5) parallel_index(t,5) dbms_stats cursor_sharing_exac t use_weak_name_resl dynamic_sampling no_monitoring no_substr b_pad */"GROUP_NAME","MEMBER_NAME","MEMBER_TYPE","DC_ID","RUN_I D" from "AVUSER"."T_DC_SOURCEDATA_GROUP_MEM" sample ( .083989 t UNION ALL SELECT * FROM sys.ora_temp_1_ds_2666110 WHERE 1 = 0
Note this query inserts data into table SYS.ORA_TEMP_1_DS_2666110. What is this table?
Resolution
Related Articles
RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL' Number of Views Patch fails on remote database because execute privilege is not granted to AVDWUSER on SYS.DBMS_LOB in RSA Identity Lifecy… Number of Views ORA-39070: "Unable to open the log file" error or ORA-06512: at "SYS.DBMS_SYS_ERROR" and "SYS.DBMS_DATAPUMP" errors when b… Number of Views Upgrade/patch fails with 'ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated' error in RSA Identity… Number of Views Approval workflow slow or stuck in decision node in RSA Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA-2026-07: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
