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
Patch fails on remote database because execute privilege is not granted to AVDWUSER on SYS.DBMS_LOB in RSA Identity Lifecy… Number of Views RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL' 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 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 Error "com.rsa.ims.security.keymanager.sys.MissingSystemKeysException: System fingerprint encrypted key is missing" on RS… Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
