Showing posts with label vim. Show all posts
Showing posts with label vim. Show all posts

Friday, 13 June 2014

Fun with parameter file and VIM

Here small anecdote rather than something dealing with technical problems.
I had created a parameter file in VIM (which is important) with a QUERY parameter specified. Nothing fancy. I opened ready file in one VIM and copied to another
dumpfile=REQ_N2521_01.DMP 
logfile=REQ_N2521_01.log 
 
tables= 
[some tables]
 
query= 
[some limits]
~                                                                               
~                                                                               
~         
I've run it and got:
ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified.
and started to look for error. And did it for some time. Initially without success - it is simple, right?

The reason was the addition of tilda characters at the end of file - because this way are represented non existent lines in the VIM if the file content is shorter than the terminal, I did not spot it at once, while had copied them beforehand unintentionally to the new file - thus it seemed perfectly normal.