diff options
| author | Mariusz Felisiak <mariusz.felisiak@mga.com.pl> | 2015-09-15 22:01:31 +0200 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2015-09-18 09:50:35 -0400 |
| commit | a0ce708c1cfa29c13d7334bb27d9c91f570307e8 (patch) | |
| tree | b8bdada4b1eb886dac891040b9b2e4f69efed44d /docs/ref/databases.txt | |
| parent | eb0bbb8f3a31eb46eb97771cd9c1eccaf01be119 (diff) | |
[1.8.x] Made assorted improvements to the Oracle documentation.
Backport of 6f1b09bb5c1bafe4633514cbff37f9a7ed7a63ae from master
Diffstat (limited to 'docs/ref/databases.txt')
| -rw-r--r-- | docs/ref/databases.txt | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index a9308a76a0..bad0a06b98 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -762,13 +762,15 @@ for Django's own test suite. All of these privileges are included in the DBA role, which is appropriate for use on a private developer's database. -The Oracle database backend uses the ``SYS.DBMS_LOB`` package, so your user -will require execute permissions on it. It's normally accessible to all users -by default, but in case it is not, you'll need to grant permissions like so: +The Oracle database backend uses the ``SYS.DBMS_LOB`` and ``SYS.DBMS_RANDOM`` +packages, so your user will require execute permissions on it. It's normally +accessible to all users by default, but in case it is not, you'll need to grant +permissions like so: .. code-block:: sql GRANT EXECUTE ON SYS.DBMS_LOB TO user; + GRANT EXECUTE ON SYS.DBMS_RANDOM TO user; Connecting to the database -------------------------- @@ -892,10 +894,10 @@ some limitations on the usage of such LOB columns in general: * LOB columns may not be used in a ``SELECT DISTINCT`` list. This means that attempting to use the ``QuerySet.distinct`` method on a model that - includes ``TextField`` columns will result in an error when run against - Oracle. As a workaround, use the ``QuerySet.defer`` method in conjunction - with ``distinct()`` to prevent ``TextField`` columns from being included in - the ``SELECT DISTINCT`` list. + includes ``TextField`` columns will result in an ``ORA-00932`` error when + run against Oracle. As a workaround, use the ``QuerySet.defer`` method in + conjunction with ``distinct()`` to prevent ``TextField`` columns from being + included in the ``SELECT DISTINCT`` list. .. _third-party-notes: |
