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 Approval workflow slow or stuck in decision node in RSA Governance & Lifecycle 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
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026) How to create and configure certificates for HTTPS access when using intermediate CA certs in RSA Identity Governance & Li…
Don't see what you're looking for?
