Description
snapshot table for snapshot HR.EMPLOYEES_MVMaterialized view properties
| name | value |
|---|
| name | HR.EMPLOYEES_MV
|
| container | EMPLOYEES_MV
|
| updatable | N
|
| rewrite enabled | N
|
| rewrite capability | GENERAL
|
| refresh mode | COMMIT
|
| refresh method | FAST
|
| build mode | IMMEDIATE
|
| fast refreshable | DML
|
| last refresh type | COMPLETE
|
| last refresh date | 11/19/2010 10:09:00 PM
|
| staleness | FRESH
|
| after fast refresh | NA
|
| unknown prebuilt | N
|
| unknown plsql func | N
|
| unknown external table | N
|
| unknown consider fresh | N
|
| unknown import | N
|
| unknown trusted fd | N
|
| compile state | VALID
|
| use no index | N
|
Columns
| name | type | length | nulls | description |
|---|
| EMPLOYEE_ID
| NUMBER
| 22
| N
|
|
| FIRST_NAME
| VARCHAR2
| 20
| Y
|
|
| LAST_NAME
| VARCHAR2
| 25
| N
|
|
| EMAIL
| VARCHAR2
| 25
| N
|
|
| PHONE_NUMBER
| VARCHAR2
| 20
| Y
|
|
| HIRE_DATE
| DATE
| 7
| N
|
|
| JOB_ID
| VARCHAR2
| 10
| N
|
|
| SALARY
| NUMBER
| 22
| Y
|
|
| COMMISSION_PCT
| NUMBER
| 22
| Y
|
|
| MANAGER_ID
| NUMBER
| 22
| Y
|
|
| DEPARTMENT_ID
| NUMBER
| 22
| Y
|
|
Refreshes
| master | last refresh |
|---|
| EMPLOYEES | 11/19/2010 10:08:59 PM
|
Dependency graph
Objects that HR.EMPLOYEES_MV depends on
Code
CREATE MATERIALIZED VIEW "HR"."EMPLOYEES_MV"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
BUILD IMMEDIATE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
REFRESH FAST ON COMMIT
WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE
AS SELECT "EMPLOYEES"."EMPLOYEE_ID" "EMPLOYEE_ID","EMPLOYEES"."FIRST_NAME" "FIRST_NAME","EMPLOYEES"."LAST_NAME" "LAST_NAME","EMPLOYEES"."EMAIL" "EMAIL","EMPLOYEES"."PHONE_NUMBER" "PHONE_NUMBER","EMPLOYEES"."HIRE_DATE" "HIRE_DATE","EMPLOYEES"."JOB_ID" "JOB_ID","EMPLOYEES"."SALARY" "SALARY","EMPLOYEES"."COMMISSION_PCT" "COMMISSION_PCT","EMPLOYEES"."MANAGER_ID" "MANAGER_ID","EMPLOYEES"."DEPARTMENT_ID" "DEPARTMENT_ID" FROM "HR"."EMPLOYEES" "EMPLOYEES"