469,082 Members | 1,108 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

SQL Loader into another user's table

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
2 4527

Yes, just code:

INTO OTHERUSR.HIS_TABLE

or, create synonym.

--
Posted via http://dbforums.com
Jul 19 '05 #2
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.

Similar topics

reply views Thread by gaikwadrachit | last post: by
reply views Thread by amitabh.mehra | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.