【Oracle导入导出】expdp(四)
. exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_CZ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_HA" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_LYG" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_NJ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_NT" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_PROVICE" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_SZ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_TZ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_WX" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_XZ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_YC" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_YZ" 0 KB 0 rows
. . exported "SYSTEM"."SERV_MSG":"P_ZJ" 0 KB 0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/oracle/product/10.2.0/db_1/rdbms/log/expdat.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 17:04:57
其他用户需要授权使用目录对象:
1.创建目录对象:
[plain]
[oracle@localhost ~]$ sqlplus system/lubinsu
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 1 17:07:28 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create directory dpump_dir01 as '/home/lubinsu/dpump';
Directory created.
2.授权:
[plain]
SQL> grant read,write on directory dpump_dir01 to lubinsu;
Grant succeeded.