Robert, I've had unexplained problems with SqlWorksheet. Run your view creation scripts through good-old-sqlplus and you will have much less problems. HTH Tom -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Storey, Robert (DCSO) Sent: Monday, August 27, 2012 4:23 PM To: 'tim@xxxxxxxxx' Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: View creation puzzle Wired. In the sql worksheet I put the alias and the view did not create I edited my creation script with an alias and the view created. -- //www.freelists.org/webpage/oracle-l