linux上导入导出oracle数据

imp cxxbcenter/cxxbcenter fromuser=center touser=cmmbcenter commit=y buffer=48000000 log=/home/oracle/center.log file=/data/center1.dmp;

exp bjtv/bjtv full=y file=bjtv.dmp log=/usr1/backup/log/cmmboss2.log;

oracle11g

导入导出用户名相同
impdp \'/ as sysdba\' directory=DATA_PUMP_DIR  dumpfile=tianweim20140325.dmp logfile=tianweim20140325.dmp.log schemas=tianweim
导入导出用户名不同
[oracle@ORACLE dpdump]$ impdp \'/ as sysdba\' directory=DATA_PUMP_DIR  dumpfile=pms_20140328.dmp  REMAP_SCHEMA= pms:pms_b04c
--现网导过来的数据库名为pms 自己创建的是pms_b04c
--将dmp文件放到DATA_PUMP_DIR目录下具体位置可以通过 select * from dba_directories;查询
--给dmp文件修改权限使oracle用户有相应的操作权限如 chmod 777 pms_20140328.dmp
从root用户切换到oracle用户
执行：

[oracle@ORACLE dpdump]$ impdp \'/ as sysdba\' directory=DATA_PUMP_DIR  dumpfile=pms_20140328.dmp  REMAP_SCHEMA= pms:pms_b04c

Import: Release 11.1.0.7.0 - 64bit Production on Friday, 28 March, 2014 15:07:07

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  "/******** AS SYSDBA" directory=DATA_PUMP_DIR dumpfile=pms_20140328.dmp REMAP_SCHEMA= pms:pms_b04c
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"PMS_B04C" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "PMS_B04C"."T_MESSAGESYNC_HIS"              1.938 MB    6505 rows
. . imported "PMS_B04C"."T_IEPG_ASSET_FILE"              6.671 MB  207103 rows
. . imported "PMS_B04C"."T_IEPG_ASSET"                   8.019 MB   52285 rows
. . imported "PMS_B04C"."T_RESOURCE_POSTER"              3.475 MB  113360 rows

-- Create the user
create user PORTALMS_B091
identified by PORTALMS_B091
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to PORTALMS_B091;
grant ctxapp to PORTALMS_B091;
grant dba to PORTALMS_B091;
grant resource to PORTALMS_B091;
-- Grant/Revoke system privileges
grant create public synonym to PORTALMS_B091;
grant create synonym to PORTALMS_B091;
grant create view to PORTALMS_B091;
grant select any table to PORTALMS_B091;
grant unlimited tablespace to PORTALMS_B091;

impdp PORTALMS_B091/PORTALMS_B091  dumpfile=pms_20140619.dmp remap_schema=pms:PORTALMS_B091 remap_tablespace=PMS_DATA:USERS remap_tablespace=PMS_IDX:USERS

pms_20140619.dmp文件放到dumpfile目录下

[root@ORACLE ~]# su -l oracle
[oracle@ORACLE ~]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 12 11:04:26 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> conn /as sysdba;
Connected.
SQL>  select * from dba_directories;

OWNER                   DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                   DATA_EXPDP_DIR_MSCP
/home/oracle

SYS                   LLY1
/u01/lly/

SYS                   LLY
/u01/lly/


OWNER                   DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS                   DUMPDIR
/nieminjie

SYS                   DATA_EXPDP_DIR
/dba/oracle/admin/orcl/dpdump/

SYS                   DATA_PUMP_DIR
/dba/oracle/admin/orcl/dpdump/

[oracle@ORACLE ~]$ impdp PORTALMS_B091/PORTALMS_B091  dumpfile=pms_20140619.dmp remap_schema=pms:PORTALMS_B091 remap_tablespace=PMS_DATA:USERS remap_tablespace=PMS_IDX:USERS

Import: Release 11.1.0.7.0 - 64bit Production on Saturday, 12 July, 2014 11:07:33

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "PORTALMS_B091"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "PORTALMS_B091"."SYS_IMPORT_FULL_01":  PORTALMS_B091/******** dumpfile=pms_20140619.dmp remap_schema=pms:PORTALMS_B091 remap_tablespace=PMS_DATA:USERS remap_tablespace=PMS_IDX:USERS
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"PORTALMS_B091" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "PORTALMS_B091"."T_MESSAGESYNC_HIS"         4.010 MB   14304 rows
. . imported "PORTALMS_B091"."T_IEPG_ASSET_FILE"         7.509 MB  227931 rows
. . imported "PORTALMS_B091"."T_IEPG_ASSET"              9.069 MB   57539 rows
. . imported "PORTALMS_B091"."T_RESOURCE_POSTER"         3.692 MB  120432 rows
. . imported "PORTALMS_B091"."T_PO_RESOURCE"             1.084 MB   63190 rows
. . imported "PORTALMS_B091"."T_RES_CLOUMN_MAP"          476.4 KB   48342 rows
. . imported "PORTALMS_B091"."T_RES_COLUMN_RESULT"       482.8 KB   80881 rows
. . imported "PORTALMS_B091"."T_SYS_LOG"                 281.3 KB    6929 rows
. . imported "PORTALMS_B091"."T_IEPG_ASSET_MAP_ASSETTYPE"  140.9 KB   47558 rows
. . imported "PORTALMS_B091"."T_COLUMN"                  85.67 KB    2314 rows
. . imported "PORTALMS_B091"."T_RESOURCE_PKG_MAP"        57.76 KB   13258 rows
. . imported "PORTALMS_B091"."T_IEPG_CHANNEL"            11.06 KB     168 rows
. . imported "PORTALMS_B091"."T_IEPG_CHANNEL_TYPE_RELATION"  5.664 KB     168 rows
. . imported "PORTALMS_B091"."T_IEPG_GOODS"              17.15 KB     347 rows
. . imported "PORTALMS_B091"."T_PRODOFFERING"            12.95 KB     399 rows
. . imported "PORTALMS_B091"."T_BUSINESSDATA_TYPE"       5.148 KB       1 rows
. . imported "PORTALMS_B091"."T_BUSINESSDATA_TYPE_ADMIN"  5.734 KB      16 rows
. . imported "PORTALMS_B091"."T_BUSINESSDATA_TYPE_ROLE"  4.812 KB       1 rows
. . imported "PORTALMS_B091"."T_CITY"                    4.984 KB       1 rows
. . imported "PORTALMS_B091"."T_COLUMN_IMAGE"            5.429 KB       4 rows
. . imported "PORTALMS_B091"."T_COLUMN_PO"               5.359 KB      15 rows
. . imported "PORTALMS_B091"."T_IEPG_ASSET_TYPE"         6.625 KB     162 rows
. . imported "PORTALMS_B091"."T_IEPG_CHANNEL_TYPE"       5.187 KB      14 rows
. . imported "PORTALMS_B091"."T_IEPG_GROUP"              5.453 KB       3 rows
. . imported "PORTALMS_B091"."T_IEPG_PROVIDER"           5.601 KB      12 rows
. . imported "PORTALMS_B091"."T_IEPG_SITE"               5.656 KB       2 rows
. . imported "PORTALMS_B091"."T_LOCATION"                5.015 KB       1 rows
. . imported "PORTALMS_B091"."T_NODE"                    5.257 KB       4 rows
. . imported "PORTALMS_B091"."T_RECOMMEND"               7.218 KB     198 rows
. . imported "PORTALMS_B091"."T_REGION_FREQ"             5.460 KB       2 rows
. . imported "PORTALMS_B091"."T_SEVICE_PARAM"            6.031 KB       9 rows
. . imported "PORTALMS_B091"."T_SYS_ADMINISTRATORS"      6.945 KB      54 rows
. . imported "PORTALMS_B091"."T_SYS_ASSGIN_ROLE"         4.992 KB      48 rows
. . imported "PORTALMS_B091"."T_SYS_RIGHT"               9.117 KB     168 rows
. . imported "PORTALMS_B091"."T_SYS_ROLE"                5.242 KB       7 rows
. . imported "PORTALMS_B091"."T_SYS_ROLE_RIGHT"          5.562 KB     369 rows
. . imported "PORTALMS_B091"."T_TEMPLATE"                5.679 KB       4 rows
. . imported "PORTALMS_B091"."T_TERMINAL"                5.898 KB       4 rows
. . imported "PORTALMS_B091"."T_WEATHERINFO"             5.398 KB       1 rows
. . imported "PORTALMS_B091"."T_ZONE"                    4.984 KB       1 rows
. . imported "PORTALMS_B091"."T_APPLICATION"                 0 KB       0 rows
. . imported "PORTALMS_B091"."T_APPLICATION_R"               0 KB       0 rows
. . imported "PORTALMS_B091"."T_AUTH_PRODUCT"                0 KB       0 rows
. . imported "PORTALMS_B091"."T_BUSINESS_RECOMMEND"          0 KB       0 rows
. . imported "PORTALMS_B091"."T_CONTROL_MAP"                 0 KB       0 rows
. . imported "PORTALMS_B091"."T_EMERGENCY_PUBLISH_CODE"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_GREETING"                    0 KB       0 rows
. . imported "PORTALMS_B091"."T_HOTEL"                       0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_APPLICATION"            0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_APP_FILE"               0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_AUDIT"                  0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_CHANNEL_IMAGES"         0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_CHANNEL_RELATION"       0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_GOODS_PRO_POLICY"       0 KB       0 rows
. . imported "PORTALMS_B091"."T_IEPG_RESOURCE_SPEC_TYPE"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_MARQUEE"                     0 KB       0 rows
. . imported "PORTALMS_B091"."T_MARQUEE_R"                   0 KB       0 rows
. . imported "PORTALMS_B091"."T_MESSAGESYNC"                 0 KB       0 rows
. . imported "PORTALMS_B091"."T_NODE_APPLICATION"            0 KB       0 rows
. . imported "PORTALMS_B091"."T_NODE_MARQUEE"                0 KB       0 rows
. . imported "PORTALMS_B091"."T_NODE_RECOMMEND"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_PACKET_TASK"                 0 KB       0 rows
. . imported "PORTALMS_B091"."T_PACKET_TASK_LOG"             0 KB       0 rows
. . imported "PORTALMS_B091"."T_PORTAL_FAILURE_RECORD"       0 KB       0 rows
. . imported "PORTALMS_B091"."T_PORTAL_USER_GROUP"           0 KB       0 rows
. . imported "PORTALMS_B091"."T_PORTAL_VERSION"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_POSITION_RELATE_IMAGE"       0 KB       0 rows
. . imported "PORTALMS_B091"."T_POSITION_RELATE_IMAGE_R"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_DOMAIN"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_DOMAIN_MAP_GROUP"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_GROUP"               0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_GROUP_MAP_TASK"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_PACKET"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_PUBLISH_TASK"                0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_CONTENT"           0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_IMAGE"             0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_INFO"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_POSITION"          0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_POSITION_R"        0 KB       0 rows
. . imported "PORTALMS_B091"."T_RECOMMEND_SCHEDULE"          0 KB       0 rows
. . imported "PORTALMS_B091"."T_REDIRECT"                    0 KB       0 rows
. . imported "PORTALMS_B091"."T_RES_CLOUMN_ONLINE_TASK"      0 KB       0 rows
. . imported "PORTALMS_B091"."T_RULE_COLUMN"                 0 KB       0 rows
. . imported "PORTALMS_B091"."T_SCHEDULE"                    0 KB       0 rows
. . imported "PORTALMS_B091"."T_UP_RULE"                     0 KB       0 rows
. . imported "PORTALMS_B091"."T_USERINFO"                    0 KB       0 rows
. . imported "PORTALMS_B091"."T_VIRTUALNETWORK"              0 KB       0 rows
. . imported "PORTALMS_B091"."T_WEATHER"                     0 KB       0 rows
. . imported "PORTALMS_B091"."T_WEATHER_IMAGE"               0 KB       0 rows
. . imported "PORTALMS_B091"."T_WEATHER_IMAGE_TEMP"          0 KB       0 rows
. . imported "PORTALMS_B091"."T_WEATHER_TEMP"                0 KB       0 rows
. . imported "PORTALMS_B091"."T_WIDGET"                      0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT