EXP/IMP数据迁移

最近有个小数据库中某用户下的所有数据需要迁移到另外一个，现在先模拟下：

数据量并不是很大的情况下，这里使用exp导出该用户下的所有数据对象：

[sql]

[lubinsu@localhost orcl]$ exp lubinsu/lubinsu@orcl_03 file=/home/lubinsu/orcl/lubinsu.dmp log=/home/lubinsu/orcl/lubinsu.log owner=lubinsu compress=n

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining 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 LUBINSU

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user LUBINSU

About to export LUBINSU's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export LUBINSU's tables via Conventional Path ...

. . exporting table AREA_TM 33105 rows exported

. . exporting table BSS_PO_SPEC_D 26570 rows exported

. . exporting table CRM_BASE_BUSI_ORDER 10000 rows exported

. . exporting table DEPT 4 rows exported

. . exporting table EMP 14 rows exported

. . exporting table GRID_MSG 156588 rows exported

. . exporting table JOB_PARMS 0 rows exported

. . exporting table LATN_AREA_INFO 14 rows exported

. . exporting table MANAGER_TM 66140 rows exported

. . exporting table MANAGER_TM_T 65994 rows exported

. . exporting table PO_SPEC_CATE_TREE_RELA 578 rows exported

. . exporting table PROCEDURE_RESULT 15 rows exported

. . exporting table SERV_MSG

. . exporting partition P_PROVINCE 0 rows exported

. . exporting partition P_NJ 10008 rows exported

. . exporting partition P_WX 10008 rows exported

. . exporting partition P_ZJ 10008 rows exported

. . exporting partition P_SZ 10008 rows exported

. . exporting partition P_NT 10008 rows exported

. . exporting partition P_YZ 10008 rows exported

. . exporting partition P_YC 10008 rows exported

. . exporting partition P_XZ 10008 rows exported

. . exporting partition P_HA 10008 rows exported

. . exporting partition P_LYG 10008 rows exported

. . exporting partition P_CZ 10008 rows exported

. . exporting partition P_TZ 10008 rows exported

. . exporting partition P_SQ 10008 rows exported

. . exporting table STAT_PROCEDURE 163 rows exported

. . exporting table TEACHER_VPN_STAT_DAILY 2377 rows exported

. . exporting table TEACHER_VPN_STAT_DAILY_T 65 rows exported

. . exporting table TT4 49880 rows exported

. . exporting table T_SCN 18 rows exported

. . exporting table T_TEST 393800 rows exported

. . exporting table T_TEST_1 49894 rows exported

. . exporting table T_TEST_2 49895 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概念-数据库文件概述
下一个："oracle Universal Installer has detected that there are processes running解决

更多图片编程知识:

更多Unix/Linux疑问解答：: 路由原理介绍; 子网掩码快速算法; 改变网络接口的速度和协商方式的工具miitool和ethtool; Loopback口的作用汇总; OSPF的童话; 增强的ACL修改功能; 三层交换机和路由器的比较; 用三层交换机组建校园网; 4到7层交换识别内容; SPARC中如何安装Linux系统(2); SPARC中如何安装Linux系统(1); 用Swatch做Linux日志分析; 实战多种Linux操作系统共存; 浅析Linux系统帐户的管理和审计; Linux2.6对新型CPU的支持(2)