300 Gのoracleデータベースを復元

                300G    
    ：  Virtual box     windos 2003           oracle11g

1.        virtual box vdi     400G，300G        1T       vdi     
    Oracle VM VirtualBox    ：D:\Program Files\Oracle\VirtualBox，
VBoxManage list hdds，  ，            UUID，
    ：VBoxManage modifyhd be05c3ee-3f64-4564-a3e5-7a00bfc4e233 --resize 102400，102400            M。
  ，       ，          ，                      
VBoxManage modifyhd 4264aafa-a33c-4d25-9a97-f3ca24e8f72b --resize 2048576

2.        ，
       vdi  oralcle     select userenv('language') from dual;   simplified chinese_china.al32utf8        MERICAN _ AMERICA. ZHS16GBK
ORA-12899: value too large for column"JRGAZX"."DTLMB"."CC" (actual: 66,maximum: 50)
          ，   UTF-8  3   ，ZHS16GBK  2   ,  dmp      ZHS16GBK      ，
            UFT-8   。
         ：ZHS16GBK
  ：
sqlplus /nolog
SQL>conn / as sysdba;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*ERROR at line 1:
ORA-12712: new character set must be a superset ofold character set
       ，   INTERNAL_USE             ：
               
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP
   imp  ，      。

 
  
 
  
 
  
 
  
 
  
         ：
cmd     sqlplus / as sysdba
1.      
CREATE TABLESPACE NNC_DATA01 DATAFILE 'C:\oraapp\oradata\orcl
nc_data01.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE TABLESPACE NNC_INDEX01 DATAFILE 'C:\oraapp\oradata\orcl
nc_index01.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE TABLESPACE NNC_DATA02 DATAFILE 'C:\oraapp\oradata\orcl
nc_data02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE TABLESPACE NNC_INDEX02 DATAFILE 'C:\oraapp\oradata\orcl
nc_index02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE TABLESPACE NNC_DATA03 DATAFILE 'C:\oraapp\oradata\orcl
nc_data03.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
CREATE TABLESPACE NNC_INDEX03 DATAFILE 'C:\oraapp\oradata\orcl
nc_index03.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
2.     
CREATE USER HCM IDENTIFIED BY HCM DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;
GRANT connect, dba to HCM;
3.          
Create directory ncdir1 as 'C:\Temp';
Grant read,write on directory ncdir1 to HCM;
4.   ，       
impdp HCM/HCM DIRECTORY=ncdir1 DUMPFILE=CTGHR20160711PATCH.DMP  FULL=y;
alter user WATERNCDB identified by 1;
                 
impdp HCM/HCM@orcl directory=ncdir1 dumpfile=CTGHR201608031628.DMP  REMAP_SCHEMA=CTGHR:HCM