Oracle SQL - Replacing and Dropping Views


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.

Related Topic