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

我在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