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
Last Modified: 2023-10-06
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 Error: 'Fatal: libthread.so.1: version 'SUNW_1.4' not found' while installing RSA ACE/Agent 5.1 on Sun Solaris 2.6 or 2.7 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 Correct and annotated example of RSA ACE/Server services file Number of Views RSA Governance & Lifecycle Integration: Infosys Finacle Summary Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Unable to login to RSA Authentication Manager Security Console as super admin Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x
Don't see what you're looking for?
