Advertisement
Guest User

Untitled

a guest
Jan 5th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. --liquibase formatted sql
  2.  
  3. --preconditions onFail:MARK_RAN onError:MARK_RAN
  4. --precondition-sql-check expectedResult:0 select COUNT(*) C from dba_tables where UPPER(table_name) = 'PERSON' and upper(owner) = 'INT'
  5.  
  6. --changeset nvoxland:3
  7. create table int.person (
  8. id int not null primary key,
  9. firstname varchar(80),
  10. lastname varchar(80) not null,
  11. state varchar(2)
  12. );
  13.  
  14. C:ProjectToolsliquibase-3.5.3-bin>liquibase --driver=oracle.jdbc.driver.Oracl
  15. eDriver --changeLogFile=C:ProjectToolsMigrationsliquibasemaster.xml --url="
  16. jdbc:oracle:thin:@database:1521:name" --username=user --password=dpass migrate
  17. Unexpected error running Liquibase: ORA-00955: name is already used by an existi
  18. ng object
  19. [Failed SQL: create table tds_int.person (
  20. id int not null primary key,
  21. firstname varchar(80),
  22. lastname varchar(80) not null,
  23. state varchar(2)
  24. )]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement