{"id":113,"date":"2013-07-25T17:29:19","date_gmt":"2013-07-25T15:29:19","guid":{"rendered":"https:\/\/www.carajandb.com\/2013\/07\/25\/toad-12-and-oracle-12\/"},"modified":"2018-02-09T14:44:13","modified_gmt":"2018-02-09T13:44:13","slug":"toad-12-and-oracle-12","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2013\/07\/25\/toad-12-and-oracle-12\/","title":{"rendered":"Toad 12 and Oracle 12"},"content":{"rendered":"

Is it by chance that within an interval of a few days both Oracle announced Oracle 12c and Dell Software announced Toad for Oracle v12?<\/p>\n

When I first saw Toad 12 (which was the first one), I was wondering about the features. As I generally don\u2019t like reading documents I tried myself and immediately found a new feature named \u201cJump\u201d. This helps a lot finding useful tools like the various compare options but is able to scan your directories and even the entire internet for additional information. So if you are new to Toad use it to find the tools; if you are an experiences Toad user\u00a0use it to find additional information.<\/p>\n

My main topic was of course checking if Toad is able to handle Oracle Database 12c (12.1.0.1). As a beta tester I had the chance to work with that release already for approximately one year \u2013 and was able to use Toad 11.6 with it (with some minor error messages while connecting as a DBA). But what about the new features in 12c?
\n
\nWhen connecting first with Toad 12 to Oracle 12c I encountered that there are no more error messages. And opening the Session Browser to wonder: there\u2019s a new tab called \u201cRedaction Policies\u201d. This brand new feature of Oracle 12c made it into the new Toad version.<\/p>\n

\"\"<\/p>\n

In this example I wanted to hide the first 12 digits of the credit card number (column KREDITKARTENID) and the entire information about the credit limit (KREDITWUERDIG) if the application (MODULE) is not Toad. – It worked perfect.<\/p>\n

Some other 12c features are quite useful and I was wondering why they didn\u2019t exist already for years, like the automatic sequence generation for a table named identity column. And of course in Toad 12, that feature is available as well.<\/p>\n

\"\"<\/p>\n

The above image is a nice dropdown box that allows you to select the identity feature, and you can change the values in the second step, as needed. As you can see in this picture the new feature \u201cinvisible column\u201d and \u201cDefault on Null\u201d are implemented as well.<\/p>\n

Maybe you are waiting for Toad support for Pluggable databases. Is there really a need for Toad to have features for PDBs? In principal a PDB should work like an ordinary database. So there, a connect is a connect and adding users, tablespaces or other objects to a PDB is not different from any other database. But in the past I had one favorite tool in Toad the Database Browser! I was using it especially to check the Top Sessions, or datafile I\/O, regardless of the database (so you can select multiple databases or all databases of one server to compare or rank the sessions, tablespace usage or datafile IO). Looking at the Database Browser for a 12c Container database I realized the additional tab named \u201cPluggable DBs\u201d.<\/p>\n

\"\"<\/p>\n

So here we go! Pluggable Databases are supported in Toad and you can list the sessions for your CDB and PDBs in one view. But here\u2019s room for improvement. If you look at Datafile I\/O, the columns are marked \u201cDatabase\u201d and \u201cService\u201d. If you mark both the CDB and the PDBs datafiles are shown twice. It might be better to show the relationship between each other.<\/p>\n

\"\"<\/p>\n

If you need more information just let me know and please visit ToadWorld <\/a>where you probably find some more interesting information as well as several blogs around Toad and Oracle.<\/p>\n","protected":false},"excerpt":{"rendered":"

Is it by chance that within an interval of a few days both Oracle announced Oracle 12c and Dell Software announced Toad for Oracle v12? When I first saw Toad 12 (which was the first one), I was wondering about the features. As I generally don\u2019t like reading documents I tried myself and immediately found a new feature named \u201cJump\u201d. This helps a lot finding useful tools like the various compare options but is able to scan your directories and even the entire internet for additional information. So if you are new to Toad use it to find the tools; […]<\/p>\n","protected":false},"author":3,"featured_media":495,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[],"tags":[109,110,26,41,27,21],"class_list":["post-113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-data-redaction","tag-identity-column","tag-multitenant-database","tag-oracle-12c","tag-pluggable-database","tag-toad"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_thumbnail_id":["495"],"_fgj2wp_old_id":["113"],"_yoast_wpseo_metadesc":["Oracle 12c und Toad 12"],"_yoast_wpseo_metakeywords":["Pluggable Database, Multitenant Database, Toad, Oracle 12c, Data Redaction, Identity Column"],"_fgj2wp_translation_association_key":["4d67040689b59e2b510df56b81686e5e"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1518184132:3"],"_edit_last":["3"],"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_yoast_wpseo_content_score":["30"],"layout_header":["light"],"_layout_header":["field_5a48111185e5f"],"layout_background":[""],"_layout_background":["field_5a481193c0995"],"layout_hide_services":["0"],"_layout_hide_services":["field_5a4811c5c0996"],"layout_show-categories-tags":["1"],"_layout_show-categories-tags":["field_5a64eee4c6491"],"blogpost_related-publications":[""],"_blogpost_related-publications":["field_5a480debdac62"],"blogpost_related-files":[""],"_blogpost_related-files":["field_5a480f377db29"],"_yoast_wpseo_primary_category":[""],"_wpml_location_migration_done":["1"],"_wpml_media_duplicate":["1"],"_wpml_media_featured":["1"],"rank_math_primary_category":[""],"rank_math_description":["Oracle 12c und Toad 12"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["0"],"wpil_links_inbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_internal_count":["0"],"wpil_links_outbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_external_count":["1"],"wpil_links_outbound_external_count_data":["eJxlkFtuAjEMRffiBQAZ+jRboO1PJT6jkERMRIijxKO0Quy9zpRWVP3z4\/pc2wYVngOuNm+o7hF2OUT9Qs5HvQ3pCKjWeK74iBAl1cHBposrrhGmEkGi4Q5hZM64XLbWFkzGNSrRLSyder+3qXIPBQb\/+k8IIbEvyQhuP8NlJM8jr5I8IJhkRypd\/IzwLoBdB8xE2dk4553ef+ocp0NIPxDhRrKGA6WulBMsiU+aNxlW14vaGGr2RdviDfvf85SSrao2E1OX3Za5GHsM6XDzjF4+kZui13\/Uw9VkNv7g7\/rl8gX9WHjP"],"wpil_sync_report2_time":["2024-08-27T11:47:30+00:00"],"astra_style_timestamp_css":["1773686821"],"rank_math_og_content_image":["a:2:{s:5:\"check\";s:32:\"1733b54a6779d35a5707482cf0617139\";s:6:\"images\";a:4:{i:0;i:495;i:1;i:496;i:2;i:497;i:3;i:498;}}"],"copied_media_ids":["a:4:{i:0;i:7209;i:1;i:7210;i:2;i:7211;i:3;i:7212;}"],"referenced_media_ids":["a:1:{i:0;i:495;}"],"_uag_css_file_name":["uag-css-113.css"]},"uagb_featured_image_src":{"full":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction.JPG",500,299,false],"thumbnail":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction-200x200.jpg",200,200,true],"medium":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction-450x269.jpg",450,269,true],"medium_large":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction.JPG",500,299,false],"large":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction.JPG",500,299,false],"1536x1536":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction.JPG",500,299,false],"2048x2048":["https:\/\/carajandb.com\/wp-content\/uploads\/2013\/07\/data_redaction.JPG",500,299,false]},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":0,"uagb_excerpt":"Is it by chance that within an interval of a few days both Oracle announced Oracle 12c and Dell Software announced Toad for Oracle v12? When I first saw Toad 12 (which was the first one), I was wondering about the features. As I generally don\u2019t like reading documents I tried myself and immediately found…","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":0,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media\/495"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}