My Oracle Support Banner

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

Last updated on JANUARY 10, 2020

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


On  Text 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
ORA-01031: insufficient privileges

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

1. Create database user THES

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


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

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