I installed ROracle (following the directions in the package) and successfully connected to our Oracle database.
I can run queries, using
> dbGetQuery(con, "select count(*) from table_name")
> dbReadTable(con, "table_name")
Error in .oci.GetQuery(con, qry) :
ORA-00942: table or view does not exist
In both cases, they work for me if I specify a
schema argument, i.e.
dbListTables(con, schema = "my_schema") dbReadTable(con,"table_name",schema = "my_schema")
Additionally, it appears from reading
?dbListTables that it has
full arguments that control whether to look in all schemas, and whether to return the full schema name or just the table name.