\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

iView<\/th>\n	Description<\/th>\n<\/tr>\n<\/thead>\n
`DBA_TABLES<\/code><\/p>\nALL_TABLES<\/code><\/p>\n USER_TABLES<\/code><\/p>\n<\/td>\n`	`DBA<\/code>\u00a0view describes all relational tables in the database.\u00a0ALL<\/code>\u00a0view describes all tables accessible to the user.\u00a0USER<\/code>\u00a0view is restricted to tables owned by the user. Some columns in these views contain statistics that are generated by the\u00a0DBMS_STATS<\/code>\u00a0package or\u00a0ANALYZE<\/code>\u00a0statement.<\/td>\n<\/tr>\n`
`DBA_TAB_COLUMNS<\/code><\/p>\nALL_TAB_COLUMNS<\/code><\/p>\n USER_TAB_COLUMNS<\/code><\/p>\n<\/td>\n`	These views describe the columns of tables, views, and clusters in the database. Some columns in these views contain statistics that are generated by the\u00a0`DBMS_STATS<\/code>\u00a0package or\u00a0ANALYZE<\/code>\u00a0statement.<\/td>\n<\/tr>\n`
`DBA_ALL_TABLES<\/code><\/p>\nALL_ALL_TABLES<\/code><\/p>\n USER_ALL_TABLES<\/code><\/p>\n<\/td>\n`	These views describe all relational and object tables in the database. Object tables are not specifically discussed in this book.<\/td>\n<\/tr>\n
`DBA_TAB_COMMENTS<\/code><\/p>\nALL_TAB_COMMENTS<\/code><\/p>\n USER_TAB_COMMENTS<\/code><\/p>\n<\/td>\n`	These views display comments for tables and views. Comments are entered using the\u00a0`COMMENT<\/code><\/a>\u00a0statement.<\/td>\n<\/tr>\n`
`DBA_COL_COMMENTS<\/code><\/p>\nALL_COL_COMMENTS<\/code><\/p>\n USER_COL_COMMENTS<\/code><\/p>\n<\/td>\n`	These views display comments for table and view columns. Comments are entered using the\u00a0`COMMENT<\/code>\u00a0statement.<\/td>\n<\/tr>\n`
`DBA_EXTERNAL_TABLES<\/code><\/p>\nALL_EXTERNAL_TABLES<\/code><\/p>\n USER_EXTERNAL_TABLES<\/code><\/p>\n<\/td>\n`	These views list the specific attributes of external tables in the database.<\/td>\n<\/tr>\n
`DBA_EXTERNAL_LOCATIONS<\/code><\/p>\nALL_EXTERNAL_LOCATIONS<\/code><\/p>\n USER_EXTERNAL_LOCATIONS<\/code><\/p>\n<\/td>\n`	These views list the data sources for external tables.<\/td>\n<\/tr>\n
`DBA_TAB_HISTOGRAMS<\/code><\/p>\nALL_TAB_HISTOGRAMS<\/code><\/p>\n USER_TAB_HISTOGRAMS<\/code><\/p>\n<\/td>\n`	These views describe histograms on tables and views.<\/td>\n<\/tr>\n
`DBA_TAB_STATISTICS<\/code><\/p>\nALL_TAB_STATISTICS<\/code><\/p>\n USER_TAB_STATISTICS<\/code><\/p>\n<\/td>\n`	These views contain optimizer statistics for tables.<\/td>\n<\/tr>\n
`DBA_TAB_COL_STATISTICS<\/code><\/p>\nALL_TAB_COL_STATISTICS<\/code><\/p>\n USER_TAB_COL_STATISTICS<\/code><\/p>\n<\/td>\n`	These views provide column statistics and histogram information extracted from the related\u00a0`TAB_COLUMNS<\/code>\u00a0views.<\/td>\n<\/tr>\n`
`DBA_TAB_MODIFICATIONS<\/code><\/p>\nALL_TAB_MODIFICATIONS<\/code><\/p>\n USER_TAB_MODIFICATIONS<\/code><\/p>\n<\/td>\n`	These views describe tables that have been modified since the last time table statistics were gathered on them. They are not populated immediately, but after a time lapse (usually 3 hours).<\/td>\n<\/tr>\n
`DBA_ENCRYPTED_COLUMNS<\/code><\/p>\nUSER_ENCRYPTED_COLUMNS<\/code><\/p>\n ALL_ENCRYPTED_COLUMNS<\/code><\/p>\n<\/td>\n`	These views list table columns that are encrypted, and for each column, lists the encryption algorithm in use.<\/td>\n<\/tr>\n
`DBA_UNUSED_COL_TABS<\/code><\/p>\nALL_UNUSED_COL_TABS<\/code><\/p>\n USER_UNUSED_COL_TABS<\/code><\/p>\n<\/td>\n`	These views list tables with unused columns, as marked by the\u00a0`ALTER TABLE ... SET UNUSED<\/code>\u00a0statement.<\/td>\n<\/tr>\n`
`DBA_PARTIAL_DROP_TABS<\/code><\/p>\nALL_PARTIAL_DROP_TABS<\/code><\/p>\n USER_PARTIAL_DROP_TABS<\/code><\/p>\n<\/td>\n`	These views list tables that have partially completed\u00a0DROP COLUMN<\/code>\u00a0operations. These operations could be incomplete because the operation was interrupted by the user or a system failure.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":" Informa\u00e7\u00f5es sobre tabelas Oracle.\u00a0 Oracle (DD) Dicion\u00e1rio de dados. Exemplo de informa\u00e7\u00f5es sobre colunas: SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, LAST_ANALYZED FROM DBA_TAB_COLUMNS WHERE OWNER =… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,126,110],"tags":[],"class_list":["post-7659","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-database","category-developer-tools","category-estudo-e-pesquisa"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/7659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7659"}],"version-history":[{"count":2,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/7659\/revisions"}],"predecessor-version":[{"id":7661,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/7659\/revisions\/7661"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}