Testing with Oracle in AWS RDS (oracle managed files)

[Vackar Afzal]

I am trying to run y test suite against an oracle server running on amazon web services under RDS.

It fails when executing this statement:

CREATE TABLESPACE NAME_OF_TBS
               DATAFILE 'name_of_tbs_dev1.dbf' SIZE 50M
               REUSE AUTOEXTEND ON NEXT 25M MAXSIZE 500M

Error message is:

ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any named identifiers
ORA-06512: at "RDSADMIN.RDSADMIN", line 211
ORA-06512: at line 2)

What is the best way to add support for oracle managed files i.e.

• Additional param in django settings?
• Catch this exception and generate an OMF compatible SQL statement?

[Carlton Gibson]

As it stands this is a usage question, which needs to be referred to an appropriate channel (Django Users, StackOverflow, etc).

It's not clear how this is an issue for Django. What's the Django code that causes the offending SQL to be generated? If you can give us that then we can assess whether there's something that needs to be addressed here.

[Vackar Afzal]

My current approach is to Monkey patch the default statements to read as follows:

statements = [
     """CREATE TABLESPACE %(tblspace)s""",
     """CREATE TEMPORARY TABLESPACE %(tblspace_temp)s""",
]

Works for the time being, but would be nice to have it integrated back into django

[Mariusz Felisiak]

Duplicate of #29788.