Skip to content
Advertisement

ORA-00942 with cx_Oracle

I’m trying to run any command on an autonomous database from oracle cloud after establishing connection but they don’t seem to work.

gives me the following error

I don’t understand where this error is coming from as I can run the same command in the browser sql developper and it works, also haven’t been able to find any real solution online

The problem might come from me not being on the correct schema but I actually changed it with this :

Thanks in advance for any leads !

(I am connected as ADMIN through python)

@GMB from the sql dev online I get 2 lines 1 – SH; 2 – ADMIN; and from python I get [(‘SH’,)]

@AnthonyTuininga

I’m using the db wallet

Advertisement

Answer

Recreated the table and now it works

Thanks all for your comments !

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement