Thanks Guys, It's working.

To use Truncate option in SQLLDR we need
drop any table system privilege

and

insert,select object privileges on that table.

I dropped the user re-created him, And i granted a regular
application user role to him. Then i granted him
drop any table
privilege and then i connected as schema owner and then i granted select,insert privileges on the table to user. Then i connected a user and truncated the the other user table.

If he wants to use delete from sqlplus or use REPLACE option then he need delete privilege on that table.

the other way to use replace option in sqlldr then he need
delete any table system privilege.

In future other DBA's can share this information. That's why i am writing the whole process. Thanks

[Edited by sree_sri on 08-30-2001 at 05:30 PM]