SQL Loader into another user's table

[Anus]

Can the SQL Loader utility load data into another user's table?

note:
this USER has select,update insert and delete privileges on the other
user's tables

[LKBrwn_DBA]

Yes, just code:

INTO OTHERUSR.HIS_TABLE

or, create synonym.

--
Posted via http://dbforums.com

[Mark D Powell]

Anus <an**@anus.anus> wrote in message news:<6g********************************@4ax.com>. ..

Can the SQL Loader utility load data into another user's table?

note:
this USER has select,update insert and delete privileges on the other
user's tables

Yes, as long as the userid used to run the load has insert then just
prefix the table_name with the owner in the ctl file: into table
owner.table_name

HTH -- Mark D Powell --