Friday, July 19, 2019

ORA-01704: string literal too long; String to Clob

Use

insert into .. values (to_clob('...') || to_clob('...')..)  or 

update table ..values(to_clob('...') || to_clob('...'))

Wednesday, July 17, 2019

Reset FishAdmin Password; JIRA




https://confluence.atlassian.com/fisheye/how-to-reset-the-administration-page-password-in-fisheye-or-crucible-960155804.html

Update Admin password in config.xml


Wednesday, July 10, 2019

Extract range of lines from file in linux;

Below gets last n lines from log
  • tail -3610000 nohup.out|less > file2.txt&



Below gets range of lines 
  • awk 'NR>=111000 && NR<=151000' file2.txt > file3.txt&