One of my user is trying to load data through sql loader with truncate option.
If table in his schema then it's loading, But when he try to load
data in other schema table then it's giving this error.
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table "oraman"."TEST_SREE"
ORA-01031: insufficient privileges
All ready i issued delete any table,select any table privilege to this user. What other privileges he need?
Click Here to Expand Forum to Full Width