Views in a Siebel database
Can somebody explain this to me?
Every day I query for newly created objects in the SIEBEL db thru dba_objects view in Oracle EE 10.2.0.3.0. This is what I come up with:
OWNER OBJECT_NAME OBJECT_TYPE STATUS Created Timestamp Last DDL Time
--------------- ------------------------------ ------------------- ------- -------------------- -------------------- --------------------
SIEBEL S2_ADDR_ORG VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_DOCK_STATUS VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_CONTACT VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_DOC_QUOTE VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_PARTY_PER VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_POSTN VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
Every day I query for newly created objects in the SIEBEL db thru dba_objects view in Oracle EE 10.2.0.3.0. This is what I come up with:
OWNER OBJECT_NAME OBJECT_TYPE STATUS Created Timestamp Last DDL Time
--------------- ------------------------------ ------------------- ------- -------------------- -------------------- --------------------
SIEBEL S2_ADDR_ORG VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_DOCK_STATUS VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_CONTACT VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_DOC_QUOTE VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_PARTY_PER VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
SIEBEL S2_POSTN VIEW VALID 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05 07-MAR-2013 16:04:05
0