Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#29485 closed Uncategorized (duplicate)

Testing with Oracle in AWS RDS (oracle managed files)

Reported by: Vackar Afzal Owned by: nobody
Component: Testing framework Version: 2.0
Severity: Normal Keywords: oracle, testing, OMF, AWS, RDS
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


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:

               DATAFILE 'name_of_tbs_dev1.dbf' SIZE 50M

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?

Change History (3)

comment:1 Changed 5 years ago by Carlton Gibson

Resolution: needsinfo
Status: newclosed

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.

comment:2 Changed 5 years ago by 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

comment:3 Changed 5 years ago by Mariusz Felisiak

Resolution: needsinfoduplicate

Duplicate of #29788.

Note: See TracTickets for help on using tickets.
Back to Top