https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idi-p/1043330 <P>ArcMap 10.8.1, Pro 2.7.2 creates the "sde logfile tables as Oracle Global Temporary Tables GTT when make a selection that exceeds the selection threshold, for the "data owner", "editor" and "viewer" users.</P><P>We can also manually create the sde logfile tables as GTT, see the support article.<BR /><A href="https://support.esri.com/en/technical-article/000009061" target="_self">How To: Create log file tables in an enterprise geodatabase as global temporary tables in Oracle</A></P><P><STRONG>Notes:</STRONG></P><P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/logfiles-oracle.htm" target="_self">Help:&nbsp;Log file tables in geodatabases in Oracle</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarquesBR_0-1617362738512.png" style="width: 785px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/9976i9AF4520626813772/image-dimensions/785x161?v=v2" width="785" height="161" role="button" title="MarceloMarquesBR_0-1617362738512.png" alt="MarceloMarquesBR_0-1617362738512.png" /></span></P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm" target="_self">Help:&nbsp;Create Database User</A></P><P>Creates a database user with privileges sufficient to create data in the database.</P> Fri, 02 Apr 2021 17:39:09 GMT MMBR 2021-04-02T17:39:09Z https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idi-p/1043330 <P>ArcMap 10.8.1, Pro 2.7.2 creates the "sde logfile tables as Oracle Global Temporary Tables GTT when make a selection that exceeds the selection threshold, for the "data owner", "editor" and "viewer" users.</P><P>We can also manually create the sde logfile tables as GTT, see the support article.<BR /><A href="https://support.esri.com/en/technical-article/000009061" target="_self">How To: Create log file tables in an enterprise geodatabase as global temporary tables in Oracle</A></P><P><STRONG>Notes:</STRONG></P><P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/logfiles-oracle.htm" target="_self">Help:&nbsp;Log file tables in geodatabases in Oracle</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarquesBR_0-1617362738512.png" style="width: 785px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/9976i9AF4520626813772/image-dimensions/785x161?v=v2" width="785" height="161" role="button" title="MarceloMarquesBR_0-1617362738512.png" alt="MarceloMarquesBR_0-1617362738512.png" /></span></P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm" target="_self">Help:&nbsp;Create Database User</A></P><P>Creates a database user with privileges sufficient to create data in the database.</P> Fri, 02 Apr 2021 17:39:09 GMT https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idi-p/1043330 MMBR 2021-04-02T17:39:09Z https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idc-p/1043452#M1731 <P>You can mark this idea as closed. ArcMap 10.8.1 and Pro 2.7.2 create the sde logfile tables as Oracle Global Temporary Tables by default now.</P> Fri, 02 Apr 2021 17:46:06 GMT https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idc-p/1043452#M1731 MMBR 2021-04-02T17:46:06Z https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idc-p/1043827#M1732 Mon, 05 Apr 2021 16:13:29 GMT https://community.esri.com/t5/data-management-ideas/sde-log-file-tables-as-oracle-global-temporary/idc-p/1043827#M1732 KoryKramer 2021-04-05T16:13:29Z