Loading Tables in a Certain Schema Always Raises LDR-485

(Doc ID 743937.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

You try to load tables in a certain schema using SQL*Loader. Independent of loaded table, you always receive the error:

SQL*Loader-485: table <table name> may not be loaded using a subtype

The specified table <table name> doesn't contain any object columns based on types or subtypes.

The next example that demonstrates this:

-- create the table
create table tab001
(
   id   number,
   text varchar2(10)
);

-- write SQL*Loader control file ldr.ctl
load data
infile *
truncate
into table tab001
fields terminated by ';'
trailing nullcols
(
   id,
   text
)
begindata
1;Text 1
2;Text 2

-- start SQL*Loader in conventional path
#> sqlldr test/passwd control=ldr.ctl

or using direct path:

#> sqlldr test/passwd control=ldr.ctl direct=true

This ends with:

SQL*Loader: Release 11.1.0.7.0 - Production on Fri Oct 17 15:57:40 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-485: table TAB001 may not be loaded using a subtype

Cause

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