oracle expose from 11.2.0.1, import to 11.2.0.3

grant DBA to gsuser with admin option;
oracle 11.2.0.1
exp gsuser/gsuserpwd@orcl buffer=12800000 statistics=none consistent=y full=y file=./GS_342_INIT_TBS.dmp log=./exp_GS_342_INIT_TBS.log

oracle 11.2.0.3
imp gsuser/gsuserpwd@orcl buffer=12800000 statistics=none fromuser=gsuser touser=gsuser FULL IGNORE=y file=GS_342_INIT_TBS.dmp log=exp_GS_342_INIT_TBS.log

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@orcl ebao]$ echo $LANG
en_US.UTF-8
[oracle@orcl ebao]$ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8
[oracle@orcl ebao]$

當有些table無法exp出來時, 該table可能是延遲建立 另外可以用下面的指令來避免table無法export的問題

select 'alter table '||table_name||' allocate extent;' from user_tables where SEGMENT_CREATED='NO';

打開/關閉 deferred segment creation

set deferred_segment_creation = [TRUE | FALSE]