Opened 13 days ago

Closed 4 days ago

Last modified 3 days ago

#29485 closed Uncategorized (needsinfo)

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

Description

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?

Change History (2)

comment:1 Changed 4 days 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 3 days 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

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