>
> From the 1.5 release notes:
>
> (1.5) RECREATE VIEW
> Exactly the same as CREATE VIEW if the view does not already exist. If
> it does exist, RECREATE VIEW
> will try to drop it and create a completely new object. RECREATE VIEW
> will fail if the object is in use.
> Uses the same syntax as CREATE VIEW.
>
> I guess that's what you are looking for
>

Thomas,

Do you know if recreate view works if you have other views that
reference your view. eg

v_MaleEmployees = select name from employee where gender = 'M'
v_TallMaleEmployees = select name from v_MaleEmployees where height > 180

If you try and recreate v_MaleEmployees does it allow you to without
dropping v_TallMaleEmployees.

Adam