Running ctxload to Load Thesaurus fails with ORA-01031 Insufficient Privilege with a New User (Doc ID 1285865.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

On  Text 11.2.0.2 version when attempting to run ctxload this fails with the following error:

[oracle]$ ctxload -user THES/thes -trace -thes -name DY_THESAURUS_ANIMAL -file dyth.txt
Connecting...
ORA-01031: insufficient privileges

The issue can be reproduced at will with the following steps:

1. Create database user THES

CREATE USER THES IDENTIFIED BY thes DEFAULT TABLESPACE users TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK ;

GRANT CREATE session TO THES;
GRANT CONNECT TO THES;
grant create table to THES;

ALTER USER THES quota unlimited ON users;
GRANT CTXAPP TO THES;
GRANT EXECUTE ON CTXSYS.CTX_CLS TO THES;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO THES;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO THES;
GRANT EXECUTE ON CTXSYS.CTX_OUTPUT TO THES;
GRANT EXECUTE ON CTXSYS.CTX_QUERY TO THES;
GRANT EXECUTE ON CTXSYS.CTX_REPORT TO THES;
GRANT EXECUTE ON CTXSYS.CTX_THES TO THES;
grant execute on CTXSYS.CTX_ULEXER to THES;

2. ctxload -user THES/thes -trace -thes -name DY_THESAURUS_ANIMAL -file dyth.txt

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