Re: SQL Loader into another user's table
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Jul 2003 13:03:11 -0700
Message-ID: <2687bb95.0307301203.51eb466b_at_posting.google.com>
Date: 30 Jul 2003 13:03:11 -0700
Message-ID: <2687bb95.0307301203.51eb466b_at_posting.google.com>
Anus <anus_at_anus.anus> wrote in message news:<6gcfivss5m7jqeb79f41i0jnmb81n2q6u1_at_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 -- Received on Wed Jul 30 2003 - 22:03:11 CEST