oracle expdp与exp一些问题说明-EXP-00113

1、远程exp导出的时候遇到问题 EXP-00113: EXP-00113: Feature New Composite Partitioning Method is unsupported. Table user.tab could not be exported。11G引入了INTERVAL分区，但是INTERVAL分区却不支持EXP导出，只支持DATA PUMP的导出。我们一些表使用了分区新特性，并且是复合分区$ oerr exp 113
00113, 00000, "Feature %s is unsupported. %s %s.%s could not be exported"
// *Cause: Export does not contain the required support for this feature.
// *Action: Use Oracle Data Pump Utility
2、使用dblink可以实现远程expdp
[p=17, null, left][font=Verdana,]01.创建TNS字符串FHACDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.101)(PORT = 1523)) ) (CONNECT_DATA = (SERVICE_NAME = fhacdb) ) )[p=17, null, left][font=Verdana,]02.创建DIRECTORY并授权SQL> create directory imp as '/home/oracle';Directory created.SQL> grant read,write on directory imp to storage;
Grant succeeded.[p=17, null, left][font=Verdana,]03.创建DB_LINKSQL> create public database link l_storage connect to storage identified by storage using 'fhacdb';
Database link created.[p=17, null, left][font=Verdana,]04.使用IMPDP的NETWORK_LINK进行迁移操作[oracle@fhacdb admin]$ impdp storage/storage directory=imp network_link=l_storage