Ora-27069 Using Autoextend Bigfile Temporary Tablespace
(Doc ID 444929.1)
Last updated on JANUARY 02, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
When a temporary tablespace (BIGFILE TEMP TABLESPACE) created with TEMPFILES on a NFS MOUNT and has been set with AUTOEXTEND, parallel SQLLOADER operations fail with ORA-27069 when the tempfile needs to be extended for any sort operations. The TEMP TABLESPACE will not have any problems if the files have been placed on the local file system.
1) Create a Temporary tablespace on a Local Disk and then run the load.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document