By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

SQL Loader into another user's table

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Yes, just code:

INTO OTHERUSR.HIS_TABLE

or, create synonym.

--
Posted via http://dbforums.com
Jul 19 '05 #2

P: n/a
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 --
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.