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]

Re: SQL Loader into another user's table


Yes, just code:

INTO OTHERUSR.HIS_TA BLE

or, create synonym.

--
Posted via http://dbforums.com

[Mark D Powell]

Re: SQL Loader into another user's table

Anus <anus@anus.anus wrote in message news:<6gcfivss5 m7jqeb79f41i0jn mb81n2q6u1@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_nam e

HTH -- Mark D Powell --