Writing table into non-default schema using ROracle

General
1

Hi,

I am interfacing Oracle SQL database from R using ROracle package. I am having a problem with writing/appending table to different schema/owner than my own.

conn = dbConnect(dbDriver("Oracle"),
                 ...)
table_id = Id(schema = "schema_name", 
              table = "table_name")

dbWriteTable(conn, name = table_id, value = table_to_write, append = T)
# returns ORA-01741: illegal zero-length identifier

dbAppendTable(anal_db, name = table_id, value = marcinko_tbl)
# returns ORA-00911: invalid character

Thanks!

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.