SQL*Loader Fails To Load Into Partitioned Table When Tablespaces Are Offline
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 22.214.171.124 - 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms