Characterset change

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Wed, 16 Jan 2019 20:11:39 +0000
Message-ID: <MWHPR10MB1551E8D2AC4965B08DE01DB9D8820_at_MWHPR10MB1551.namprd10.prod.outlook.com>

Hello Oracle Experts -

Environment: Redhat 6.7, EE 12.1
DB size: 4TB

We have been looking into switching the Characterset of a DB from "WE8ISO8859P15" to "AL16UTF8". This is a standalone Enterprise Edition database (non-RAC, No Data Guard).

We have looked at DB Migration Assistant and DataPump as possible options. Both involves quite a bit of downtime, wondering if there is a better way to perform this activity? Would Transportable tablespace be an option?

Thanks much in advance
-Upendra

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 16 2019 - 21:11:39 CET

This message: [ Message body ]
Next message: Rich J: "Re: Characterset change"
Previous message: Jeff Smith: "RE: No Hotsos conference this year, any recommendations for a substitute?"
Next in thread: Rich J: "Re: Characterset change"
Reply: Rich J: "Re: Characterset change"
Reply: Reen, Elizabeth : "RE: Characterset change"
Reply: Tiwari, Yogesh: "RE: Characterset change"
Reply: Willy Klotz: "AW: Characterset change"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message