Liquibase Spring batch xml for Oracle RDBMS

  [code] <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd"> <changeSet id="1.0.0_SPRING_BATCH_INFRASTRUCTURE" author="a243229"> <createSequence sequenceName="BATCH_STEP_EXECUTION_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createSequence sequenceName="BATCH_JOB_EXECUTION_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createSequence sequenceName="BATCH_JOB_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createTable tableName="BATCH_JOB_INSTANCE"> <column name="JOB_INSTANCE_ID" type="BIGINT"> <constraints primaryKey="true" nullable="false" /> </column> <column name="VERSION" type="BIGINT" /> <column name="JOB_NAME" type="VARCHAR(100)"> <constraints nullable="false" /> </column>

Running sql queries in Liquibase

Make sure the user that you’ll use to issue this command will have privileges. In this query I create a user on Oracle DB [code] <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd"> <changeSet id="1.0.0_RBACK_USER" author="a243229"> <!– TO BE ABLE TO RUN THIS SCRIPT, MAKE SURE YOUR NON-SYS USER HAS SUCH PRIVILEGES OTHERWISE RUN THE

Useful Oracle DB Hints

Importing data imp userid=baldo_test/baldotest1@localbaldo file=c:\oracle\temp\localbaldo.dmp log=c:\oracle\temp\imp.log   Export data exp  userid=baldo_test/baldotest1@localbaldo file=user1.dmp Dropping a user [code]DROP USER USERNAME CASCADE;[/code] Creating a user [code] CREATE USER USERNAME IDENTIFIED BY "PASSWORD" ACCOUNT UNLOCK; [/code] Truncate Table PL/SQL http://stackoverflow.com/a/11030009 [code] BEGIN FOR c IN (SELECT table_name, constraint_name FROM user_constraints WHERE constraint_type = ‘R’) LOOP EXECUTE IMMEDIATE (‘alter table ‘