>Bill, thank you so much for trying to help me with this problem. FYI, the problem was that, although the view was being created locally the, the index was being created on the server with the same name. This is what the "file in use error was". One of the replie's I got from the UT was to use the SYS(2015) function. This created the problem.
>
>Once, again thanks for replying when I was reaching out for help!!!

No prob. Glad you got it solved, which is the main thing. Wish I could have saved you some time and provided the answer immediately. :-)