7.3.4 to 8.1.7 migration, problem with Sqlldr

[toshito]

Hi,

We are currently doing some testing after migrating from Oracle 7.3.4 to 8.1.7 on an AIX 4.3.3 server.

I have a loader that was working fine before the migration, and now it returns this error:

SQL*Loader-908: Unable to lock table "INTG1661"."TB_WKRASE" due to ORACLE error 1031

The table I want to load is in my own schema.

I have tried to drop and recreate the table, but it doesn't change anything.

Thanks!

[Naeem]

Hi
Try granting "lock any table" to the role or user.

Although direct path loads minimize the necessity of database processing, a few fast calls to Oracle are made at the beginning and end of the load. Tables are locked and released at the end. Hence the "LOCK ANY TABLE" privilege is required for the user to successfully run the load.

Naeem

[toshito]

It worked! Thanks!