Yes, it's a quesion of rights. My system administrator just confirme that.
And I also try with a small Oracle client, and same as R, no permission to read
tables.
On R with RODBC I could list the tables but no permission to read or import
tables.
But I get confused because I was using the same
On Tue, 17 Jul 2007, Marc Schwartz wrote:
Try the sqlQuery() syntax with a semi-colon at the end of it:
sqlQuery(essai, select * from S_TYP_COLLEGES;)
Oracle requires the semi-colon at the end of the SQL statement.
Over ODBC? I've never heard of that, and others have used RODBC to
Oracle
On Wed, 2007-07-18 at 08:04 +0100, Prof Brian Ripley wrote:
On Tue, 17 Jul 2007, Marc Schwartz wrote:
Try the sqlQuery() syntax with a semi-colon at the end of it:
sqlQuery(essai, select * from S_TYP_COLLEGES;)
Oracle requires the semi-colon at the end of the SQL statement.
Over
I believe I have seen that error message from
Oracle when I tried to query a table for which I
did not have select privileges (and when I knew
for certain that the table existed). Ask your
database administrator about the table, and make
sure that you do have that privilege.
What I am
I think that you are on to something there Don.
I just tried accessing a table from our Oracle server, which I do know
exists, but for which I do not have access permissions.
Using the following query in the Oracle Instant Client:
select table_name from all_tables;
I can get a list of all
essai - odbcConnect(ORESTE_prod, uid=osis_r, pwd=12miss15
,case=oracle)
sqlTables(essai)$ORESTE
...
1315 NA ORESTE S_PROFESSIONS_OLDTABLENA
1316 NA ORESTE S_PROVENANCESTABLENA
1317 NA ORESTE
Try the sqlQuery() syntax with a semi-colon at the end of it:
sqlQuery(essai, select * from S_TYP_COLLEGES;)
Oracle requires the semi-colon at the end of the SQL statement.
If that does not help, try these queries using the Oracle Instant Client
command line application outside of R and see