How to get information about key columns in materialized view ?
Use below statement to find information regarding source for columns in mv.
select *
from dba_mview_keys
where mview_name=<mview name>
| Column Name | ID | Data Type | Null? |
| OWNER | 1 | VARCHAR2 (30 Byte) | N |
| MVIEW_NAME | 2 | VARCHAR2 (30 Byte) | N |
| POSITION_IN_SELECT | 3 | NUMBER | N |
| CONTAINER_COLUMN | 4 | VARCHAR2 (30 Byte) | N |
| DETAILOBJ_OWNER | 5 | VARCHAR2 (30 Byte) | N |
| DETAILOBJ_NAME | 6 | VARCHAR2 (30 Byte) | N |
| DETAILOBJ_ALIAS | 7 | VARCHAR2 (30 Byte) | Y |
| DETAILOBJ_TYPE | 8 | VARCHAR2 (5 Byte) | Y |
| DETAILOBJ_COLUMN | 9 | VARCHAR2 (30 Byte) | N |
No comments :
Post a Comment