the idea here is to use multiple schemas instead of databases to reduce redundancy,
the basic catalyst create model doesn't seem to handle non default schemas, so I created one with the default schema,
oops, I found the option after working through the loader documentation and making my own script. it is odd because I don't see where the selection shows up in the source files.
much later:
I still have not found where it is identifying the schema used. I tried some different experiments though and it is distinguishing between the two versions of the same table/view. My current guess is that since it is inaccessible from one of the roles that it is skipping it. It would be nice though if it was explicitly stated somewhere.
Thursday, January 13, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment