Tablespace consumed by views I was in an SQL class where the instructor said "DBAs don't like it when users create views, because they will clobber tablespace."

Obviously, I understand that any schema object will consume some tablespace, but isn't it a huge exaggeration to say that views will eat up tablespace, since all you need to store is just a query (and privileges and some other metadata), and as such they won't take significantly more space than an ordinary row in an ordinary table?
Not true, unless they meant "materialised views"


ORAFAQ



  Permanent tablespaces are used to store user data and user created objects like tables, indexes and materialized views.