special setup to create views in Oracle in default schema
DBA role alone is not enough.

CREATE VIEW


  The owner of the schema containing the view must have the privileges
  necessary to either select (READ or SELECT privilege), insert, update,
  or delete rows from all the tables or views on which the view is
  based. The owner must be granted these privileges directly, rather
  than through a role.