{"id":583,"date":"2023-11-21T22:05:13","date_gmt":"2023-11-21T22:05:13","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=583"},"modified":"2023-11-21T22:05:20","modified_gmt":"2023-11-21T22:05:20","slug":"csscan","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/","title":{"rendered":"CSSCAN"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ordba.net\/rdbmsimages\/4.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">CSSCAN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(Character Set Scanner)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Introduced in Oracle 8iR2<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Metalink Doc Id 123670.1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features: 1) convertibility check of existing data and potential issues. The Scanner checks all character data in the database including the data dictionary and tests for the effects and problems of changing the character set encoding (characterset). At the end of the scan, it generates a summary and exception report of the database scan. 2) from csscan V1.1 onwards it allows you also to do a check if there is no data in the database that is incorrectly stored.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is used in [NOTE: 225938.1] Database Character Set Health check This note gives an example on how the output of the csscan tool looks like and some live examples of how to convert the characterset.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please use the following note: [NOTE: 225912.1]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Changing the Database Character Set<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8211; an Overview as a complete guide to plan the change of the database character set.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Installation and setup<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">==============<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before you install<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IMPORTANT: Check for the latest version on TechNet of the csscan tool for your platform and version and install\/use this. Csscan downloads are available from: http:\/\/technet.oracle.com\/software\/tech\/globalization\/content.html<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You cannot mix csscan versions with between database versions; there is a separate csscan version for each database\/platform combination.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please see the following note csscan compatibility to find out which version is best for you:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:179843.1]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Versioning of the Character Set Scanner<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you receive errors about the version of the migrate utility schema then also please see the mentioned note.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There is one know problem with the characterset scanner for 817: see [BUG: 3043474]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To install the Character Set Scanner, you must have DBA privileges on the Oracle database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you encounter &#8220;CSS-0xxxx&#8221; type errors, first look in the &#8220;Character Set Scanner Error Messages &#8221; section of these documentation sets:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle9i Database Globalization Support Guide Release 2 (9.2), Part Number A96529-01<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">http:\/\/otn.oracle.com\/pls\/db92\/db92.docindex? remark=homepage<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle8i Documentation Addendum,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Release 3 (8.1.7), Part Number A85455-01<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Chapter 3 contains the Character Set Scanner documentation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">http:\/\/otn.oracle.com\/documentation\/oracle8i.html<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">click on &#8221; View Library&#8221; for &#8220;Oracle8i On-Line Generic Documentation Release 3 (8.1.7)&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Installing Csscan<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run csminst.sql to create the needed user and tables, You can modify the default tablespace for CSMIG by editing the csminst.sql script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Modify the following statement in csminst.sql to assign your preferred tablespace to CSMIG as follows:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ALTER USER csmig DEFAULT TABLESPACE tablespace_name;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then run csminst.sql using these commands and SQL statements:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">cd $ORACLE_HOME\/rdbms\/admin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">set oracle_sid=<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">sqlplus &#8220;sys as sysdba&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;set TERMOUT ON<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;set ECHO ON<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt;spool csminst.log<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL&gt; START csminst.sql<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">check the csminst.log for errors.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE: 232242.1]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Character set migration utility schema not installed in 9i<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORA-942 during csminst.sql<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can run the scanner against this database, for example C:&gt;csscan help=y gives the help screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The usage and results of a csscan run are different depending on the version of csscan you use, therefore please see the relevant note for your version:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:279068.1]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Usage of Character Set Scanner Utility (csscan) version 1.1 Further Reading ===============<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:179843.1] Versioning of the Character Set Scanner<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:279068.1] Usage of Character Set Scanner Utility (csscan) version 1.1 [NOTE:225912.1] Changing the Database Character Set &#8211; a Short Overview<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:66320.1] Changing the Database Character Set or the Database National Character Set<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:15095.1] Export\/Import and NLS Considerations<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:119119.1] UTF8 Database Character Set Implications<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:232242.1] Character set migration utility schema not installed in 9i ORA-942 during csminst.sql<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[NOTE:289844.1] csscan receives error &#8220;kgrdec2r not located in orageneric8.dll&#8221; [BUG:1611255] CHARACTER SET SCANNER GETS SEGMENTATION FAULT WHEN ARRAY AND PROCESS ARE LARGE<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DBV (DBVERIFY)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">NID (DBNEWID) Introduced in Oracle 9i<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Enterprise Manager<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">RMAN (Recovery Manager)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CSSCAN (Character Set Scanner) Introduced in Oracle 8iR2 Metalink Doc Id 123670.1 Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features: 1) convertibility check of existing data and potential &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\"> <span class=\"screen-reader-text\">CSSCAN<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":567,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","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":"","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":"","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-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-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-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-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-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-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CSSCAN - Ordba<\/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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CSSCAN - Ordba\" \/>\n<meta property=\"og:description\" content=\"CSSCAN (Character Set Scanner) Introduced in Oracle 8iR2 Metalink Doc Id 123670.1 Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features: 1) convertibility check of existing data and potential &hellip; CSSCAN Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T22:05:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T22:05:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\",\"name\":\"CSSCAN - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-21T22:05:13+00:00\",\"dateModified\":\"2023-11-21T22:05:20+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CSSCAN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CSSCAN - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/","og_locale":"en_US","og_type":"article","og_title":"CSSCAN - Ordba","og_description":"CSSCAN (Character Set Scanner) Introduced in Oracle 8iR2 Metalink Doc Id 123670.1 Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features: 1) convertibility check of existing data and potential &hellip; CSSCAN Read More &raquo;","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/","og_site_name":"Ordba","article_published_time":"2023-11-21T22:05:13+00:00","article_modified_time":"2023-11-21T22:05:20+00:00","og_image":[{"width":499,"height":400,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/","name":"CSSCAN - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-21T22:05:13+00:00","dateModified":"2023-11-21T22:05:20+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/csscan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"CSSCAN"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=583"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/583\/revisions"}],"predecessor-version":[{"id":584,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/583\/revisions\/584"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/567"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}