RE: Character Set Migration Questions
Date: Tue, 14 Feb 2017 13:47:43 +0000
Message-ID: <6dac021f393d4b7db4fe089f47b45542_at_ex04mail01b.ad.rit.edu>
Actually, I was able to do it using an alter database command (alter database character set we8iso8859p15), since there is no data in it yet.
Scott Canaan '88 (srcdco_at_rit.edu)
(585) 475-7886 - work (585) 339-8659 - cell
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
-----Original Message-----
From: Herald ten Dam [mailto:Herald.ten.Dam_at_superconsult.nl]
Sent: Tuesday, February 14, 2017 8:46 AM
To: Scott Canaan; oracle-l_at_freelists.org
Subject: RE: Character Set Migration Questions
The other way is full export and import then. DMU is only for Unicode
Full export from database1 and then import into database2 where character set is the new 1. So you need 2 instances.
Herald ten Dam
Superconsult.nl
Van: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] namens Scott Canaan [srcdco_at_rit.edu] Verzonden: donderdag 9 februari 2017 16:07 Aan: oracle-l_at_freelists.org
Onderwerp: Character Set Migration Questions
I have an Oracle 12.1.0.2 database that is US7ASCII and needs to be converted to WE8ISO8859P15. I tried using the DMU, but I can't figure out how to choose the characterset that I want. It only gives me the option of going to either AL32UTF8 or UTF8.
The other option I've come across is using the older CSSCAN utility, but that isn't installed with 12c and I can't figure out where to find it. I don't want to have to go back and build the database from scratch. Is there any other way to do this?
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 14 2017 - 14:47:43 CET