We can easily destroy old or unneeded objects as need be using the DROP
statements.
SQL> drop view cell_view;
View dropped.
SQL> select * from address_book;
ID NAME HOME_NUM CELL_NUM
---------- ------------------------------ ------------ ------------
LOCATION
----------------------------------------
1 Ben Rockwood 510-555-1234 650-555-2345
Menlo Park, CA
2 Tamarah Rockwood 510-555-4443
Menlo Park, CA
3 Nova Rockwood
Menlo Park, CA
SQL> drop table address_book;
Table dropped.
SQL>
