1

I have a data frame which I wish to insert into a table in an Oracle database. When putting data into my personal schema I have no problems using

DBI::dbWriteTable(conn = con, name = "my_table", value = "my_data_frame",
 overwrite = TRUE, date = true)

However I've recently been granted SELECT, INSERT, UPDATE, and DELETE privileges on a table outside my personal schema. My goal is to insert new data from a data frame into this table.

Using basically the same syntax as above except for specifying the schema:

DBI::dbWriteTable(conn = con, name = "my_table", schema = "new_schema",
 value = "my_data_frame", overwrite = TRUE, date = true)

I run into the following error message:

Error in .oci.GetQuery(con, stmt) : ORA-01031: insufficient privileges

My assumption is that it is from dbWriteTable being structured around creating tables, which I don't have permission for. I haven't managed to find an alternative method however to accomplish what I want to do.

Any suggestions?

Note: Not sure what the applicability will be of using solutions outside the scope of DBI and ROracle, as I think I'm somewhat limited in what I can actually use within the work environment.

0

Browse other questions tagged or ask your own question.