Oracle SQL offers an ALTER VIEW command to recompile views that became invalid.
A view could become invalid because of an alter command on the underlying table.
You can drop a view definition only, with the DROP VIEW command.
drop view <view_name>;
Alternatively, you can replace the definition of an existing view with the CREATE OR REPLACE VIEW command.