0 Replies Latest reply: Feb 25, 2014 2:10 AM by petra-K RSS

    Recreate Db to a new Charset

      Hi All,

       

      11.2.0.1

       

      Can I convert my database from one char-set to another by recreating database and controlfile?

      Using the following:

       

      STARTUP NOMOUNT

      CREATE CONTROLFILE SET DATABASE "DG9A" RESETLOGS FORCE LOGGING NOARCHIVELOG

        MAXLOGFILES 50

        MAXLOGMEMBERS 5

        MAXDATAFILES 100

        MAXINSTANCES 1

        MAXLOGHISTORY 453

      LOGFILE

        GROUP 1 '/u03/oradata/dg9a/redo01.log' SIZE 100M,

        GROUP 2 '/u03/oradata/dg9a/redo02.log' SIZE 100M,

        GROUP 3 '/u03/oradata/dg9a/redo03.log' SIZE 100M

      DATAFILE

        '/u03/oradata/dg9a/system01.dbf',

        '/u03/oradata/dg9a/undotbs01.dbf',

        '/u03/oradata/dg9a/cwmlite01.dbf',

        '/u03/oradata/dg9a/drsys01.dbf',

        '/u03/oradata/dg9a/example01.dbf',

        '/u03/oradata/dg9a/indx01.dbf',

        '/u03/oradata/dg9a/odm01.dbf',

        '/u03/oradata/dg9a/tools01.dbf',

        '/u03/oradata/dg9a/users01.dbf',

        '/u03/oradata/dg9a/xdb01.dbf',

        '/u03/oradata/dg9a/andy01.dbf',

        '/u03/oradata/dg9a/psstats01.dbf',

        '/u03/oradata/dg9a/planner01.dbf'

      CHARACTER SET WE8ISO8859P1;

       

      ALTER DATABASE OPEN RESETLOGS;

       

      ALTER TABLESPACE TEMP ADD TEMPFILE '/u03/oradata/dg9a/temp01.dbf'

        SIZE 104857600 REUSE AUTOEXTEND OFF;

       

       

      Thanks,

      pK