DELETE

Use the DELETE statement to remove rows from:

• An unpartitioned or partitioned table

• The unpartitioned or partitioned base table of a view

• The unpartitioned or partitioned container table of a writable materialized view

• The unpartitioned or partitioned master table of an updatable materialized view

For you to delete rows from a table, the table must be in your own schema or you must have the DELETE object privilege on the table.

For you to delete rows from an updatable materialized view, the materialized view must be in your own schema or you must have the DELETE object privilege on the materialized view.

For you to delete rows from the base table of a view, the owner of the schema containing the view must have the DELETE object privilege on the base table. Also, if the view is in a schema other than your own, then you must have the DELETE object privilege on the view.

You can read the whole article here.