#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 |
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 (3)
comment:1 by , 6 years ago
Resolution: | → needsinfo |
---|---|
Status: | new → closed |
comment:2 by , 6 years ago
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.
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.