Skip to Main Content

Feature Details

Buttons

Feature Details Container

Unrestricted Direct Loads

Database Overall → Core Database

Prior to this feature, after a direct load and prior to a commit, queries and additional DMLs were not allowed on the same table for the same session or for other database sessions. This enhancement allows the loading session to query and perform DML on the same table that was loaded. Rollback to a savepoint is also supported.

Business Benefit: This feature removes the restrictions that you may have encountered when loading and querying data. Potentially improving the performance of your applications in areas such as Data Warehousing and complex batch processing.

Release Availability
11.2
12.1
12.2
18c
19c
21c
26ai
Available On
All Offerings
Initial Release
26ai