{"id":15014,"date":"2023-12-05T09:53:16","date_gmt":"2023-12-05T12:53:16","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=15014"},"modified":"2023-12-05T09:53:16","modified_gmt":"2023-12-05T12:53:16","slug":"how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/","title":{"rendered":"How to check the code of the most important Oracle internal objects without having a database"},"content":{"rendered":"<p>Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA.<\/p>\n<p>Let&#8217;s say, for example, that I need to get the view SQL code for DBA_USERS we had back in 12.2.0.1 with April 2022 patch applied. Or if I need to get all the Package Specs for DBMS_STATS on 19c to check what is new compared with 18c? To achieve that, you would first need to install that release, apply the desired patch, and finally connect to the database to get the code using DBMS_METADATA.<\/p>\n<p>Did you know that it is possible to get all that information without even having to download or install an Oracle Database? Check the short 2-minute video below to get this quick tip.<\/p>\n<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/ws7I4gyIwrg?si=uMzzszDewBaAfurj\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>As ORAdiff has more than 500 hundred different version levels, you can get the contents of a very specific release in an easy way.<\/p>\n<p>Try it out and let me know your input!<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-15014 jlk' href='javascript:void(0)' data-task='like' data-post_id='15014' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-15014 lc'>+1<\/span><\/a><\/div><\/div> <div class='status-15014 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let&#8217;s say, for example, that I need to get the view SQL code for DBA_USERS we had &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[60],"tags":[],"class_list":["post-15014","post","type-post","status-publish","format-standard","hentry","category-oradiff","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to check the code of the most important Oracle internal objects without having a database - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"With ORAdiff, it is possible to get the definition of any Oracle internal object without even having to download or install a Database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"How to check the code of the most important Oracle internal objects without having a database\",\"datePublished\":\"2023-12-05T12:53:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/\"},\"wordCount\":200,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"ORAdiff\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/\",\"name\":\"How to check the code of the most important Oracle internal objects without having a database - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2023-12-05T12:53:16+00:00\",\"description\":\"With ORAdiff, it is possible to get the definition of any Oracle internal object without even having to download or install a Database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2023\\\/12\\\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to check the code of the most important Oracle internal objects without having a database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to check the code of the most important Oracle internal objects without having a database - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"With ORAdiff, it is possible to get the definition of any Oracle internal object without even having to download or install a Database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"How to check the code of the most important Oracle internal objects without having a database","datePublished":"2023-12-05T12:53:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/"},"wordCount":200,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["ORAdiff"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/","url":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/","name":"How to check the code of the most important Oracle internal objects without having a database - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2023-12-05T12:53:16+00:00","description":"With ORAdiff, it is possible to get the definition of any Oracle internal object without even having to download or install a Database.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2023\/12\/how-get-the-contents-of-the-most-important-oracle-internal-views-without-having-a-database-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"How to check the code of the most important Oracle internal objects without having a database"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/15014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=15014"}],"version-history":[{"count":1,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/15014\/revisions"}],"predecessor-version":[{"id":15015,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/15014\/revisions\/15015"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=15014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=15014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=15014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}