--------------不要以sysdba来调用expdp,为什么呢?还没搞清楚!!
Note: Do not invoke Export as SYSDBA, except at the request of
Oracle technical support. SYSDBA is used internally and has
specialized functions; its behavior is not the same as for general
users.
--------------不支持XML Schema and XML schema-based tables.
ORA-39139: Data Pump does not support XMLSchema objects. TABLE_DATA:"OE"."PURCHASEORDER" will be skipped.
----------
Expdp有5种导出模式:
1.Full Export Mode
参数名:FULL
2.Schema Mode
参数名: SCHEMAS
3.Table Mode
参数名: TABLES
4.Tablespace Mode
参数名: TABLESPACES
5.Transportable Tablespace Mode
参数名: TRANSPORT_TABLESPACES
---------------
parfile参数的妙用:
实例:当要导出的schemas很多,在命令行写不下时,可以把时schemas都写到parfile文件中,然后调用。
-----test.par文件内容----
directory=EXPDP_DMP dumpfile=ccctest.dmp logfile=EXPDP_DMP:ccctest.log schemas=APP_CALFEED,APP_CONTENT,APP_KLICK,APP_OBIETL_READ_CAN,APP_OBIETL_READ_CORE,APP_OBIONLINE_ETL_CAN,APP_OBIONLINE_ETL_CORE,APP_OBIONLINE_RPT_CAN,APP_OBIONLINE_RPT_CORE,APP_OI,APP_OLAP_TIBCOWORKAREA,APP_OLIF,APP_OLTP_TIBCOWORKAREA,APP_PRICE,APP_SIDEWINDER_DV,APP_STORE,APP_TAXWARE8,APP_TAXWARERPT8,APP_TAXWARE_DV,APP_TIBCOWORKAREA,APP_TIBCOWORKAREA_OMS,APP_VENDOR,ATGADMIN,ATGADMIN_DV,ATGCATALOGA,ATGCATALOGA_DV,ATGCATALOGB,ATGCATALOGB_DV,ATGCSCADM,ATGCSCADM_DV,ATGCSCAGT,ATGCSCAGT_DV,ATGCUST,ATGCUST_DV,ATGORDER,ATGORDER_DV,ATGPRICE,ATGPRICE_DV,ATGSEARCH,ATGSEARCH_DV
-----test.par文件内容----
expdp system/oracle parfile=test.par