{"id":2897,"date":"2022-05-27T15:27:53","date_gmt":"2022-05-27T13:27:53","guid":{"rendered":"https:\/\/devbloomppm.wpengine.com\/?p=2897"},"modified":"2022-05-31T17:27:02","modified_gmt":"2022-05-31T15:27:02","slug":"oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware","status":"publish","type":"post","link":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/","title":{"rendered":"Oracle : impact de l&rsquo;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2897\" class=\"elementor elementor-2897\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-725e085 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"725e085\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-78dadd8\" data-id=\"78dadd8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7a06bdb\" data-id=\"7a06bdb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6c83ad elementor-widget elementor-widget-heading\" data-id=\"b6c83ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Oracle : impact de l'obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-22f5647 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22f5647\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-4706b90\" data-id=\"4706b90\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d8a3fd1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"d8a3fd1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c858b96 elementor-widget elementor-widget-heading\" data-id=\"c858b96\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Sommaire<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c52820 elementor-align-start elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7c52820\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title1\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Description<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title2\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Obsolescence du type LONG<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title3\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Impact sur le produit planisware<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title4\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Strat\u00e9gies de migration<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-e69c542\" data-id=\"e69c542\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2c4aed elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b2c4aed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb764c9 elementor-widget elementor-widget-heading\" data-id=\"fb764c9\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title1\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Description<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c1997c elementor-widget elementor-widget-text-editor\" data-id=\"7c1997c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le type de donn\u00e9es LONG est un type obsol\u00e8te pour les bases de donn\u00e9es ORACLE. Il est encore pr\u00e9sent dans les versions r\u00e9centes d\u2019Oracle pour des raisons \u00e9videntes de compatibilit\u00e9 mais il n\u2019\u00e9volue plus et est destin\u00e9 \u00e0 dispara\u00eetre \u00e0 terme. Il est remplac\u00e9 progressivement par les types CLOB et NCLOB. Cet article pr\u00e9sente les impacts de l\u2019obsolescence de ce type LONG sur le produit Planisware ainsi que des strat\u00e9gies possibles de migration.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0956d7 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b0956d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74cdd93 elementor-widget elementor-widget-heading\" data-id=\"74cdd93\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title2\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Obsolescence du type LONG<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c78c4d9 elementor-widget elementor-widget-text-editor\" data-id=\"c78c4d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Depuis la version 8i, <span style=\"color: #003333;\"><strong>Oracle recommande d\u2019utiliser les types CLOB et NLOB \u00e0 la place du type LONG<\/strong><\/span>. Sur son site<strong><span style=\"color: #003333;\"> Oracle pr\u00e9cise que ce type ne doit plus \u00eatre utilis\u00e9 et qu\u2019il est encore pr\u00e9sent pour des raisons de compatibilit\u00e9.<\/span><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7845c04 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-center elementor-widget elementor-widget-divider\" data-id=\"7845c04\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e8e3de elementor-widget elementor-widget-heading\" data-id=\"7e8e3de\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title3\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Impact sur le produit Planisware<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e82b3da elementor-widget elementor-widget-text-editor\" data-id=\"e82b3da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le type LONG est utilis\u00e9 historiquement dans le mod\u00e8le de donn\u00e9es Planisware pour un certain nombre de champs (ex. le champ HOLIDAYS de la table CALENDAR).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c05256a elementor-widget elementor-widget-image\" data-id=\"c05256a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"662\" height=\"401\" src=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_1.jpg\" class=\"attachment-large size-large wp-image-2898\" alt=\"Calendrier 1\" srcset=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_1.jpg 662w, https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_1-300x182.jpg 300w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e3d7f5 elementor-widget elementor-widget-text-editor\" data-id=\"3e3d7f5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Champs de la table CALENDAR en P5 SP1<\/p><p>La requ\u00eate SQL suivante ex\u00e9cut\u00e9e sur le sch\u00e9ma applicatif Plansiware permet de lister les champs de type LONG :<\/p><p><span style=\"color: #993366;\">select OWNER,TABLE_NAME,COLUMN_NAME from ALL_TAB_COLUMNS<\/span><br \/><span style=\"color: #993366;\">WHERE OWNER=\u2019BASE_DEV1\u2019 AND DATA_TYPE = \u2019LONG\u2019;<\/span><\/p><p>avec BASE_DEV1 le nom du sch\u00e9ma de base de donn\u00e9es<\/p><p>Ce qui donne par exemple sur le mod\u00e8le de donn\u00e9es de P5 SP1 :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a79242d elementor-widget elementor-widget-image\" data-id=\"a79242d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"362\" height=\"217\" src=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/LONG_TYPE_FIELDS.jpg\" class=\"attachment-large size-large wp-image-2900\" alt=\"Champs Long\" srcset=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/LONG_TYPE_FIELDS.jpg 362w, https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/LONG_TYPE_FIELDS-300x180.jpg 300w\" sizes=\"(max-width: 362px) 100vw, 362px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9b36d2 elementor-widget elementor-widget-text-editor\" data-id=\"e9b36d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Champs de type LONG en P5 SP1<\/p><p>\u00a0<\/p><p>Tous les champs de type LONG ont \u00e9t\u00e9 modifi\u00e9s en SP3. Ils sont maintenant de type CLOB comme on peut le constater dans l\u2019exemple suivant qui d\u00e9crit la table CALENDAR en SP3 :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be8c222 elementor-widget elementor-widget-image\" data-id=\"be8c222\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"660\" height=\"400\" src=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_3.jpg\" class=\"attachment-large size-large wp-image-2902\" alt=\"Calendrier 3\" srcset=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_3.jpg 660w, https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/CALENDAR_SP_3-300x182.jpg 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-62f0e51 elementor-widget elementor-widget-text-editor\" data-id=\"62f0e51\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Champs de la table CALENDAR en P5 SP3<\/p><p>\u00a0<\/p><p>Ainsi depuis la P5 SP3 lorsque le client lourd v\u00e9rifie le mod\u00e8le donn\u00e9es sur une base vierge, les champs historiquement cr\u00e9\u00e9s en type LONG sont maintenant cr\u00e9\u00e9s en type CLOB.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0ae946 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-center elementor-widget elementor-widget-divider\" data-id=\"e0ae946\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b39abad elementor-widget elementor-widget-heading\" data-id=\"b39abad\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title4\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Strat\u00e9gies de migration<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-18673e3 elementor-widget elementor-widget-text-editor\" data-id=\"18673e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Lors de la migration d\u2019une base de donn\u00e9es existante (de SP1 vers SP3) la modification du mod\u00e8le de donn\u00e9es via le client lourd ne modifiera pas le type de donn\u00e9es des champs d\u00e9j\u00e0 pr\u00e9sents en base. Pour assurer la migration de ces champs 2 strat\u00e9gies peuvent \u00eatre envisag\u00e9es :<\/p><p style=\"padding-left: 40px;\"><span style=\"color: #003333;\">\u2192 <strong>Migration des donn\u00e9es directement en base (\u00e0 l\u2019aide de la fonction TO_LOB)<\/strong><\/span><br \/><strong><span style=\"color: #003333;\">\u2192 Migration des donn\u00e9es via un import\/export de dpx :<\/span><\/strong><\/p><p style=\"padding-left: 80px;\"><strong><span style=\"color: #003333;\">\u2192 export de la base (contenant des champs de type LONG) sous forme de dpx<\/span><\/strong><br \/><strong><span style=\"color: #003333;\">\u2192 suppression des tables P5 du sch\u00e9ma de la BDD Oracle (car sinon les tables ne sont pas recr\u00e9\u00e9es et les champs de type LONG pas mis \u00e0 jour)<\/span><\/strong><br \/><strong><span style=\"color: #003333;\">\u2192 recr\u00e9ation des tables P5 via le client lourd P5 SP3 (lors la v\u00e9rification du mod\u00e8le physique)<\/span><\/strong><br \/><strong><span style=\"color: #003333;\">\u2192 import du dpx via le client lourd dans le sch\u00e9ma ainsi mis \u00e0 jour<\/span><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Oracle : impact de l&rsquo;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware Sommaire Description Obsolescence du type LONG Impact sur le produit planisware Strat\u00e9gies de migration Description Le type de donn\u00e9es LONG est un type obsol\u00e8te pour les bases de donn\u00e9es ORACLE. Il est encore pr\u00e9sent dans les versions r\u00e9centes d\u2019Oracle pour des&hellip;&nbsp;<a href=\"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/\" rel=\"bookmark\">Lire la suite &raquo;<span class=\"screen-reader-text\">Oracle : impact de l&rsquo;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware<\/span><\/a><\/p>\n","protected":false},"author":5,"featured_media":2900,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"left","neve_meta_author_avatar":"","neve_post_elements_order":"[\"meta\",\"thumbnail\",\"content\",\"tags\",\"comments\"]","neve_meta_disable_header":"off","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"cybocfi_hide_featured_image":"yes","footnotes":""},"categories":[9],"tags":[],"class_list":["post-2897","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classifiee"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v27.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle : impact de l&#039;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware - BLOOM PPM<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/\"},\"author\":{\"name\":\"Antoine Hirschenhahn\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/beb0bf75e386466a086d6a396e9112b7\"},\"headline\":\"Oracle : impact de l&rsquo;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware\",\"datePublished\":\"2022-05-27T13:27:53+00:00\",\"dateModified\":\"2022-05-31T15:27:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/\"},\"wordCount\":532,\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/LONG_TYPE_FIELDS.jpg\",\"articleSection\":[\"Non classifi\u00e9(e)\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/\",\"name\":\"Oracle : impact de l'obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware - BLOOM PPM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/LONG_TYPE_FIELDS.jpg\",\"datePublished\":\"2022-05-27T13:27:53+00:00\",\"dateModified\":\"2022-05-31T15:27:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle : impact de l&#8217;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"name\":\"BLOOM PPM\",\"description\":\"We make your projects grow\",\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\",\"name\":\"Bloom PPM\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"contentUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"width\":602,\"height\":204,\"caption\":\"Bloom PPM\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bloomppm\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/beb0bf75e386466a086d6a396e9112b7\",\"name\":\"Antoine Hirschenhahn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"caption\":\"Antoine Hirschenhahn\"},\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/author\\\/antoine-hirschenhahnbloomppm-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle : impact de l'obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware - BLOOM PPM","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:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#article","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/"},"author":{"name":"Antoine Hirschenhahn","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/beb0bf75e386466a086d6a396e9112b7"},"headline":"Oracle : impact de l&rsquo;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware","datePublished":"2022-05-27T13:27:53+00:00","dateModified":"2022-05-31T15:27:02+00:00","mainEntityOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/"},"wordCount":532,"publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/LONG_TYPE_FIELDS.jpg","articleSection":["Non classifi\u00e9(e)"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/","url":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/","name":"Oracle : impact de l'obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware - BLOOM PPM","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#primaryimage"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/LONG_TYPE_FIELDS.jpg","datePublished":"2022-05-27T13:27:53+00:00","dateModified":"2022-05-31T15:27:02+00:00","breadcrumb":{"@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bloomppm.com\/fr\/oracle-impact-de-lobsolescence-du-type-long-sur-le-modele-de-donnees-planisware\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bloomppm.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Oracle : impact de l&#8217;obsolescence du type LONG sur le mod\u00e8le de donn\u00e9es Planisware"}]},{"@type":"WebSite","@id":"https:\/\/bloomppm.com\/fr\/#website","url":"https:\/\/bloomppm.com\/fr\/","name":"BLOOM PPM","description":"We make your projects grow","publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bloomppm.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/bloomppm.com\/fr\/#organization","name":"Bloom PPM","url":"https:\/\/bloomppm.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","contentUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","width":602,"height":204,"caption":"Bloom PPM"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/bloomppm\/"]},{"@type":"Person","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/beb0bf75e386466a086d6a396e9112b7","name":"Antoine Hirschenhahn","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","caption":"Antoine Hirschenhahn"},"url":"https:\/\/bloomppm.com\/fr\/author\/antoine-hirschenhahnbloomppm-com\/"}]}},"_links":{"self":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/comments?post=2897"}],"version-history":[{"count":0,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2897\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media\/2900"}],"wp:attachment":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media?parent=2897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/categories?post=2897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/tags?post=2897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}