Yes I was trying to copy the structure of a table not a view. Anyway I put it into a fresh directory (firstly I moved it into a directory that was already there but used for something else) and it worked.

Thanks