My Oracle Support Banner

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.


Symptoms

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.

 

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 Example:

1) Create a Temporary tablespace on a Local Disk and then run the load. 

Cause

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.