How to use Liquibase with SQL using oracle DBLinks on mutiple DBs

General Discussion
1

Hi I have a SQL statement which uses DBLinks to get data from multiple DBs.
Example -
select usr_nam, max(login_tim) as last_login from
(select usr_nam, login_tim from user_log@t2uku
union
select usr_nam, login_tim from user_log@t3uki
union
select usr_nam, login_tim from user_log@t1uku
union
select usr_nam, login_tim from user_log@t4uku
)
group by usr_nam;

How do i used Liquibase with such SQLs with Oracle DBLinks ?

2

I’m not sure I fully understand the question.

A DBlink table behaves just like any local table in a query. Liquibase would not care about the DBlink.