Opened 6 years ago
Closed 6 years ago
#29788 closed New feature (fixed)
Add support for Oracle Managed File (OMF) Tablespaces
Reported by: | Vackar Afzal | Owned by: | Mariusz Felisiak |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 2.1 |
Severity: | Normal | Keywords: | oracle, OMF |
Cc: | Triage Stage: | Accepted | |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description (last modified by )
Oracle has 2 means of creating tablespaces:
- Oracle managed files (OMF)
- User managed files (UMF)
Currently Django only supports UMF, and not OMF.
To add support for OMF just need to omit the 'name' of the datafile - very simple changed.
Could add a flag to the 'OPTIONS' key in the database settings to specify which should be used:
"default": { "ENGINE": "django.db.backends.oracle", "OPTIONS": { "threaded": True, "oracle_managed_files": True # <--------------- This is the new addition: default=False }, "NAME": "my_sid", "USER": "my_user", "PASSWORD": "my_pass", "HOST": "localhost", "PORT": "1521" },
This is required if you are working with an Oracle instance that only supports OMF i.e.AmazonRDS
Change History (8)
comment:1 by , 6 years ago
Component: | Uncategorized → Migrations |
---|---|
Description: | modified (diff) |
Easy pickings: | set |
Keywords: | oracle OMF added |
comment:2 by , 6 years ago
Description: | modified (diff) |
---|
comment:4 by , 6 years ago
Yes should have been clearer, yes this relates to testing, and now that you have mentioned it, would make more sense to add the special Key to the 'TEST' key in the DB config. i.e.
"default": { "ENGINE": "django.db.backends.oracle", "OPTIONS": { "threaded": True, }, "TEST": { "oracle_managed_files": True # <--------------- This is the new addition: default=False } "NAME": "my_sid", "USER": "my_user", "PASSWORD": "my_pass", "HOST": "localhost", "PORT": "1521" },
comment:5 by , 6 years ago
Component: | Migrations → Database layer (models, ORM) |
---|---|
Easy pickings: | unset |
Summary: | Support for Oracle Managed File (OMF) Tablespaces → Add support for Oracle Managed File (OMF) Tablespaces |
Triage Stage: | Unreviewed → Accepted |
Type: | Uncategorized → New feature |
comment:6 by , 6 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
Seems to be related to #29485.
Django does create datafiles only on testing.
Django in normal operation doesn't create datafiles nor tablespaces.