oracle11无法访问不同的表,如何使用django从oracle11g中的不同模式访问表？

缺乏、安全感 2023-01-18 15:24 35阅读 0赞

我在oracle 11g中有一个名为mi\_abc的用户。

用户在数据库中没有任何表，但可以访问另一个schema sch\_abc中的所有表。

当我从sqldeveloper对miu abc的sch\_abc模式运行一个普通的select查询时，它工作得非常好，但是当我使用django时，我总是得到错误：-在

django.db.utils.DatabaseError: ORA-00942: table or view does not exist

我试着设置db\_table=sch\_abc.表名同时也设置db\_table=tableName，但两者都给出了相同的错误。有什么线索可以解决吗？在

在跟踪：-在Traceback (most recent call last):

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\xxx\\xxxx\\lib\\site-packages\\django\\core\\handlers\\exception.py", line 41, in inner

response = get\_response(request)

File "C:\\xxx\\xxx\\xxxx\\xxxx\\xxxx\\Python\\Python37\\lib\\site-packages\\django\\utils\\deprecation.py", line 142, in \_\_call\_\_

response = self.process\_response(request, response)

File "C:\\xxxx\\xxxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\contrib\\sessions\\middleware.py", line 58, in process\_response

request.session.save()

File "C:\\xxx\\xxxx\\xxxx\\xxxx\\xxxxx\\Python\\Python37\\lib\\site-packages\\django\\contrib\\sessions\\backends\\db.py", line 81, in save

return self.create()

File "C:\\xxxx\\xxxxx\\xxxx\\xxxx\\xxxxx\\Python\\Python37\\lib\\site-packages\\django\\contrib\\sessions\\backends\\db.py", line 50, in create

self.\_session\_key = self.\_get\_new\_session\_key()

File "C:\\xxxx\\xxxxx\\xxxxx\\xxxxx\\xxxx\\Python\\Python37\\lib\\site-packages\\django\\contrib\\sessions\\backends\\base.py", line 164, in \_get\_new\_session\_key

if not self.exists(session\_key):

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\contrib\\sessions\\backends\\db.py", line 46, in exists

return self.model.objects.filter(session\_key=session\_key).exists()

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\models\\query.py", line 673, in exists

return self.query.has\_results(using=self.db)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\models\\sql\\query.py", line 517, in has\_results

return compiler.has\_results()

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\models\\sql\\compiler.py", line 858, in has\_results

return bool(self.execute\_sql(SINGLE))

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\models\\sql\\compiler.py", line 899, in execute\_sql

raise original\_exception

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\models\\sql\\compiler.py", line 889, in execute\_sql

cursor.execute(sql, params)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\backends\\utils.py", line 79, in execute

return super(CursorDebugWrapper, self).execute(sql, params)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\backends\\utils.py", line 64, in execute

return self.cursor.execute(sql, params)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\utils.py", line 94, in \_\_exit\_\_

six.reraise(dj\_exc\_type, dj\_exc\_value, traceback)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\utils\\six.py", line 685, in reraise

raise value.with\_traceback(tb)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\backends\\utils.py", line 64, in execute

return self.cursor.execute(sql, params)

File "C:\\xxx\\xxx\\xxx\\xxx\\xxx\\Python\\Python37\\lib\\site-packages\\django\\db\\backends\\oracle\\base.py", line 497, in execute

return self.cursor.execute(query, self.\_param\_generator(params))

django.db.utils.DatabaseError: ORA-00942: table or view does not exist

oracle11无法访问不同的表,如何使用django从oracle11g中的不同模式访问表？

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle11无法访问不同的表,如何使用django从oracle11g中的不同模式访问表？

相关 oracle不同用户访问不带前缀,oracle不同用户间访问表不添加用户名（模式）前缀...

相关 oracle如何查询虚拟列,Oracle 11G 表的虚拟列

相关 oracle11g跨网段无法访问,ORACLE11G设置IP访问限制，oracle11gip访问

相关 Oracle 11g 修改表的所属表空间

相关 Oracle11g中Exp空表的问题

相关 oracle 11g exp导出空表

相关 Oracle 11g表的碎片率诊断

相关 Oracle 11g ORA-14450: 试图访问已经在使用的事务处理临时表

相关 Oracle11g 临时表空间收缩