Hello Experts ;
Advised to start new thread
11034256
In Materialized view, any difference between MASTER TABLE Vs LOCAL BASE TABLE ?
- I know this is very very basic question but getting confused when referring some oracle blogs.
********************************
SQL>CREATE MATERIALIZED VIEW TEST_QUERY
REFRESH ON COMMIT
AS SELECT COLUMN_1 , COLUMN_2 FROM emp;
Here , emp is BASE TABLE ... A query containing from clause it is master table.
So i think master table is another name of local base table / base table. but some links saying some thing different.
please clarify ..
Thanks in advance ..