Latest Answer : A materialized view (MV) is similar to a view but the data is actually stored on disk (view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system. A ...
Latest Answer : V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE' shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also helps a dba to monitor datafile which are in backup mode. ...
Latest Answer : Snapshot and materialized view are almost same same but with one difference.You can say that materialized view =snapshot + query rewrite functionalityquery rewrite functionality:In materialized view you can enable or disable query rewrite option. ...
Latest Answer : When you try to execute procedure from procedure just write procedure name. If you are executing from SQL*Plus them write EXEC Thanks, Shailu ...
A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?