Monday, September 26, 2016

DATABASE VIEW NOTES


  •  

    Views

    DATABASE VIEW NOTES:
  • Owner - Owner of the view
  • View Name - Name of the view
  • Created - Date/time view was created
  • Status - Status of the view

    select  OWNER,
 OBJECT_NAME,
 to_char(CREATED,'MM/DD/YYYY HH24:MI:SS') created,
 status
from   dba_objects
where OWNER not in ('SYS','SYSTEM')
and OBJECT_TYPE='VIEW'
order by OWNER,OBJECT_NAME
    • By -
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    How To Fix Hive – Partition Table Query Failed When Stored As Parquet

    This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...