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
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 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 RSA Governance & Lifecycle Integration: Infosys Finacle Summary 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
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle How to Download and Reinstall the AFX Server Archive in RSA Governance & Lifecycle
Don't see what you're looking for?
