Hi fellows,
Facts: 11.1.0.6 Oracle Enterprise single instance
OS: Red hat 6
I need to change character set and we decided to use Csscan and Export/import method. this was already checked and we will do that.
in some part of documents on metalink they described:
"3c) Oracle database 11.2.0.2 and lower ( including 11gR1 and 10g)
DMU requires a serverside patch 9825461 for databases who are on a version lower than 11.2.0.3.
This means DMU can be used to change a database on a version / platform combination for which patch 9825461 is available.
Using Csscan and Csalter or Csscan and Export/import is the only way to go to AL32UTF8 for versions / platforms who are not supported by DMU.
Using Csscan and Csalter to go to AL32UTF8 is documented in Note 260192.1 Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) in 8i, 9i , 10g and 11g."
and check this url: http://askdba.org/weblog/2008/04/changing-database-characterset-with-exportimport-utilities/
So please, we only have one doubt.
In case we need to restore through impdp what would be steps:?
1.- setting export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
2.- restore with whicch parameters in import? impdp?
thank you