exp/imp中如何實(shí)現(xiàn)遠(yuǎn)程導(dǎo)出操作

153次閱讀

共計(jì) 2402 個(gè)字符，預(yù)計(jì)需要花費(fèi) 7 分鐘才能閱讀完成。

這篇文章將為大家詳細(xì)講解有關(guān) exp/imp 中如何實(shí)現(xiàn)遠(yuǎn)程導(dǎo)出操作，丸趣 TV 小編覺(jué)得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

實(shí)驗(yàn)：
源庫(kù)：:192.168.56.20 hostname:slient
目標(biāo)庫(kù)：:192.168.56.12 hostname:wang

說(shuō)明：
tns:20，為對(duì)源庫(kù)的連接字符串、owner 指的是源庫(kù)的 schema, 生成的 dmp 文件是在目標(biāo)庫(kù)

[oracle@wang dpdump]$ exp system/oracle@20 owner=scott file=partition.dmp log=partition.log

Export: Release 11.2.0.4.0 – Production on Sun Aug 6 01:31:09 2017

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users …
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT s tables via Conventional Path …
. . exporting table ADSFDSFDSF 13 rows exported
. . exporting table BONUS 0 rows exported
. . exporting table DBXL 13 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table SALGRADE 5 rows exported
. . exporting table TEST
. . exporting partition P1 0 rows exported
. . exporting partition P2 0 rows exported
. . exporting partition P3 0 rows exported
. . exporting partition P4 0 rows exported
. . exporting table TEST123 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@wang dpdump]$
– 驗(yàn)證：
[oracle@wang dpdump]$ ls
bill_B_FILE_PACKAGE.dmp bill_B_PACKAGE_STATE_TRANS.dmp dp.log import.log partition.dmp partition.log
[oracle@wang dpdump]$

=== 補(bǔ)充 =========

問(wèn)題的現(xiàn)象：

EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

備份文件會(huì)生成但是沒(méi)有內(nèi)容。

這個(gè)問(wèn)題主要是 exp 的時(shí)候里面參數(shù)發(fā)生了沖突。

比較常見(jiàn)的：

1. 同時(shí)指定了 owner 和 tables

2. 同時(shí)指定了 FULL 和 tables

3. 同時(shí)指定了多個(gè) owner 和 full

owner 表示導(dǎo)出整個(gè)用戶或者多個(gè)用戶而 tables 表示只導(dǎo)出其中的表。

要么只導(dǎo)出其中的表要么導(dǎo)出整個(gè)用戶。不然就會(huì)沖突了、

關(guān)于“exp/imp 中如何實(shí)現(xiàn)遠(yuǎn)程導(dǎo)出操作”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，使各位可以學(xué)到更多知識(shí)，如果覺(jué)得文章不錯(cuò)，請(qǐng)把它分享出去讓更多的人看到。

正文完