There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve this issue. Copy the code in Text file and while in escape mode enter following command
:%s/,/,^M/g
Please note that to insert ^M you need to press Ctrl+V+M keys together.We are basically using the command to enter a line break after each comma.
