Path Loader to a different Schema.

[Hugh.Jones]

I need to load data into a separate schema from the one i am logged in as - using the path loader.

I have qualified the TableName correctly with the Table Owner (OWNER.TABLE) but when I call the Prepare() method of the Loader I get an 'insufficient Privileges' message.

The code works fine with or without the Owner in the Tablename, provided I am connected as the Owner-user.

Could you suggest please what Privileges I might need to look out for to get this to work ?

 

[Marco Kalter]

Your oracle user needs insert privileges on the table in the other schema.