I am a liquibase newbie and have just started trying out liquibase. I have installed the version 3.5.5 of liquibase and my database is Oracle 11GR2. The standard setup that we have for code is to put the objects in one schema OBJ$ and for code to go into APPS$ database accounts.
How can I achieve this using liquibase?
APPS$ would need to have private synonyms for all OBJ$ objects. Also we would need to be able to grant privileges to OBJ$ objects to APPS$ account.
Can these schema details be made generic? So that rather than hardcoding the APPS$ and OBJ$ schema details into my scripts, I can pass these as parameters?
All my changeSets are basically invoking sqlFile elements. What are the disadvantages of using this approach?
Thanks and Regards
Nand Kishore Sagi