exp/imp(8)之导出

导出的步骤很简单,主要注意下面红色的问题:

 

1)xmlschema-base columes只能用老exp导出

2)字符集问题

 

参考

http://silverw0396.javaeye.com/blog/90554

http://blog.csdn.net/annicybc/archive/2006/06/13/794965.aspx

 

 

1)

SQL> create or replace directory expdir as '/dump';
SQL> GRANT read,write ON DIRECTORY expdir TO public;

# chown -R oracle:oinstall /dump
# chmod -R 755 /dump

expdp system/open1sys full=y DIRECTORY=expdir DUMPFILE=df1.dmp LOGFILE=lf1.log

if you have xmlschema-base columes
Cause: Object has XMLSchema-based columns, which are
unsupported by Data Pump.

Action: Use the original exp and imp utilities to move this
object.

 

exp system/open1sys full=y file=/dump/dfdirect.dmp direct=y

 

if EXP-00091: Exporting questionable statistics happened.
Export terminated successfully with warnings.
NLS_LANG=_.

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8ISO8859P1
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.1.0

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1