id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
21775	No facility to specify the datafile of a django test Oracle tablespace	jarshwah	alvaro@…	"There is no way to customise the name of the datafile for the Oracle test database. This is required for RAC installations which use shared storage. I propose a new option to the DATABASES dict:

{{{
        'TEST_TBLSPACE_DATAFILE': '',
        'TEST_TBLSPACE_TMP_DATAFILE': '',
}}}

Without these options, it is impossible to test against RAC, so I'm classifying it as a bug rather than a new feature.

And the existing code that creates the tablespaces:

{{{
# django/db/backends/oracle/creation.py
    def _execute_test_db_creation(self, cursor, parameters, verbosity):
        if verbosity >= 2:
            print(""_create_test_db(): dbname = %s"" % parameters['dbname'])
        statements = [
            """"""CREATE TABLESPACE %(tblspace)s
               DATAFILE '%(tblspace)s.dbf' SIZE 20M
               REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 200M
            """""",
            """"""CREATE TEMPORARY TABLESPACE %(tblspace_temp)s
               TEMPFILE '%(tblspace_temp)s.dbf' SIZE 20M
               REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 100M
            """""",
        ]
        self._execute_statements(cursor, statements, parameters, verbosity)
}}}

Since not many people have access to an Oracle RAC installation, I'll throw together a patch in the near future."	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	oracle	Shai Berger alvaro@…	Accepted	1	1	0	0	0	0