search

rsim / oracle-enhanced

Oracle enhaced adapter for ActiveRecord
MIT License
546 stars 308 forks source link

specify multiple parameters in config/database.yml(schema: parameter) #2294

Closed abhitiwari1322 closed 2 years ago

abhitiwari1322 commented 2 years ago

For oracle 21c, application is having multiple schema/users (abc_001, abd_001, mcd_001) Need to setup the schema search path. In database.yml: _development: adapter: oracle_enhanced database: xe username: user password: secret schema: tableowner__

How can we specify multiple tableowner for schema parameter above? For a single schema we can specify: schema: '"abc_001"'. how can we specify multiple tableowner here like: schema: abc_001 OR abd_001 OR mcd_001?

System configuration

Rails version: 5.2

Oracle enhanced adapter version: 5.2.0

Ruby version: 2.5.1

Oracle Database version: oracle 21C

yahonda commented 2 years ago

Thanks for opening an issue. There is no multi schema support in Oracle enhanced adapter and have no plan to support it.

yahonda commented 2 years ago

Closing this issue because I have no plan to support it. Thanks again for opening this issue.