SQL*Loader Fails To Load Into Partitioned Table When Tablespaces Are Offline
(Doc ID 268726.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11 to 18.104.22.168 - Release: 8.1.7 to 9.2
Information in this document applies to any platform.
Use SQL*Loader to load data that you know would fall into a particular partition only. The tablespaces for the table partitions and local partitioned indexes, where the data is being loaded, are in READ WRITE mode. If the tablespaces of other table partitions and local index partitions are offline, then SQL*Loader fails with the following error:
ORA-376: file 2 cannot be read at this time
where file 2 is not at all related to the tablespace of the partition where the data is to be loaded.
But SQL*Loader works fine in the same scenario when there is no local index on the partitioned table. This is failing only for the direct path load and not conventional 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!