0

I need to drop one table, but before I need to move all the data that is in that table to another table with xml liquibase. I tried with update but it is giving ORA-00936: missing expression. Can someone help please ? What is the syntax / correct way to migrate one table to another row by row ?

Than k you.

sticky_elbows
  • 1,344
  • 1
  • 16
  • 30

1 Answers1

0

What about sqlChange with insert from source table? Here is the fiddle to test. Note it could take a lot of time if table is too big.

<changeSet id="id" author="you">
    <sql>insert into target_table select * from source_table</sql>
</changeSet>
bilak
  • 4,526
  • 3
  • 35
  • 75