# How can I override databaseChangeLogLockTableName?

**URL:** <https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119>\
**Category:** General Discussion\
**Created:** [September 20, 2012, 2:58am UTC](https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119 "2012-09-20T02:58:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [September 20, 2012, 2:58am UTC](https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119/1 "2012-09-20T02:58:00Z")

</div>

Is it possible to use a common databasechangelog table for multiple schema in a db? currently it seems liquibase creates one table in each schema to track changes and that is making things difficult to track centrally.  
  
DB is oracle, so does liquibase support a public synonym for the change log table? or it only selects from user\_Tables ?

---

<div class="post-metadata">

**Author:** ![tommygeorge](https://avatars.discourse-cdn.com/v4/letter/t/9de053/32.png) [@tommygeorge](https://forum.liquibase.org/u/tommygeorge)\
**Post date:** [September 20, 2012, 2:58am UTC](https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119/2 "2012-09-20T02:58:00Z")

</div>

**Using liquibase 2.0.5 from the command line.&nbsp;**

I have an alternate set of migration/database information that I’d like to track separately from my primary migrations – basically, the same schema and tables, but I’d like to use slightly different settings for each, for rollback purposes, etc.&nbsp;

**Specifically** , I’d like to override the name of the table used by "

**Is it at all possible to override this parameter when using liquibase from the command line? How?**

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [September 20, 2012, 2:58am UTC](https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119/3 "2012-09-20T02:58:00Z")

</div>

I also failed to do that by the command line. But this is ok:  
  
java -Dliquibase.databaseChangeLogTableName=databasechangelog \<br\>&nbsp;&nbsp;&nbsp; -Dliquibase.databaseChangeLogLockTableName=databasechangeloglock \<br\>&nbsp;&nbsp;&nbsp; -jar /root/liquibase3.0.0/liquibase.jar \<br\>&nbsp;&nbsp;&nbsp; --driver=xxxx \<br\>&nbsp;&nbsp;&nbsp; --classpath= xxxx \<br\>&nbsp;&nbsp;&nbsp; --changeLogFile=xxx \<br\>&nbsp;&nbsp;&nbsp; --url=“xxx” \<br\>&nbsp;&nbsp;&nbsp; --username=admin \<br\>&nbsp;&nbsp;&nbsp; --password=admin \<br\>&nbsp;&nbsp;&nbsp; --logLevel=debug \<br\>&nbsp;&nbsp;&nbsp; “–currentDateTimeFunction=now()” \<br\>&nbsp;&nbsp;&nbsp; migrate

---

<div class="post-metadata">

**Author:** ![tommygeorge](https://avatars.discourse-cdn.com/v4/letter/t/9de053/32.png) [@tommygeorge](https://forum.liquibase.org/u/tommygeorge)\
**Post date:** [September 20, 2012, 2:58am UTC](https://forum.liquibase.org/t/how-can-i-override-databasechangeloglocktablename/2119/4 "2012-09-20T02:58:00Z")

</div>

This absolutely worked in our case! Thanks so much! Would be awesome if the documentation pointed out this seeming inconsistency.&nbsp;