Hello,
While running some code in ORE (nothing out of the ordinary and nothing involving external packages), I ran across this error:
ORA-01536: space quota exceeded for tablespace 'RQ'
After ore.drop()-ing any tables I created during this session and ending my session (via ore.disconnect() and by closing my R editor), I asked one of our database administrators to look into the issue. He indicated that there are numerous objects in my tablespace labeled in the following format:
ORE$###### (where # are numbers)
that appear to be user created (select * shows us that they they look like objects I was creating) - but for some reason they are persisting in the temporary table space past my session.
While we can manually delete these objects, we are concerned that they may cause instability for ORE (and it's generally a pain to have to clean up this mess manually).
Is this a known issue and/or is there something we can do to fix this issue?
Thanks.