Specifying which Oracle schema to use with ActiveRecord


#1

We use Oracle in my company.

I have access to 2 schemas (or tablespaces?) :

1.SAL
2.SALDATA

I use tables from both schemas. How do i tell active record which
schema to look in for the table i
want???

I’ve just managed to convince the boss to switch from Java to Rails so
this would be a arse if i couldnt use both schemas.

Any help would be GREATELY appreciated!

Thanks,
Chris


#2

so for example i might have table SAL.customers and table
SALDATA.accounts. How do i tell active record which table to use?


#3

Andy wrote:

so for example i might have table SAL.customers and table
SALDATA.accounts. How do i tell active record which table to use?

Use #set_table_name (or #table_name=) and include the schema name. So,
something like:

class Account < ActiveRecord::Base
set_table_name “saldata.accounts”

end