I'm trying to run the following dbmlsync command line:
dbmlsync -c uid=dba;pwd=sql -x
When I run it dbmlsync displays its help screen with a message that says,
Error in command near "c:\my\offline\log\directory"
What did I do wrong?
The problem here is that the command line is ambiguous.
The -x option can be followed by a size (for example -x 1024) or it can be specified on its own which is equivalent to -x 0.
Dbmlsync assumes that if the thing following a -x does not start with a - or a / then it is the size. This is the correct assumption unless the -x comes immediately before the offline log directory which is the only command line option that does not start with a - or a /.
So in the case above dbmlsync is trying to treat c:\my\offline\log directory as the size parameter for the -x option. It cannot convert this value to an integer so it reports an error.
There are 2 ways to work around this:
Try dbmlsync -c uid=dba;pwd=sql -x 0 c:myofflinelogdirectory
answered 11 May '11, 14:27