How to delete content of a table using ROracle?

4121390

I have created a connection from R to my Oracle Database using ROracle.

I can do query and write table from R.

Now I have a case where I have to write to a table, but the permission doesn't allow me to overwrite the table when using dbWriteTable function.

So, I have to first clear the content of the table using "delete from" query, then use dbWriteTable and append to write to the table.

I can query the "delete from" using Toad, but I need to do it from R because I need to automate the process.

The problem is, the query "delete from" never finished when done from R.

I have tried using dbGetQuery and dbSendQuery.

I have tried the solution from this as well (using dbExecute and dbSendStatement), but the same problem occurs

Updating/deleting rows using ROracle does not complete

Anybody can help suggesting a solution?

Thank you very much

Sherry Lamonica-Oracle

What is the permissions error you receive when trying to use dbWriteTable and dbExecute?

Thanks,

Sherry

4121390

Hi Sherry,

when using dbWriteTable and using overwrite = T, the error said "insufficient privilege".

The error didn't occur when using append = T instead of overwrite = T.

when using dbExecute to "delete from", there was no error, it just never finished.

Thanks a lot!

Sherry Lamonica-Oracle

Does your DB user have the create table privilege?

Sherry