【Oracle导入导出】expdp(五)
3.导出：
[plain]
[lubinsu@localhost oracle]$ expdp lubinsu/lubinsu DIRECTORY=dpump_dir01 dumpfile=lubinsu.dmp
Export: Release 10.2.0.1.0 - Production on Wednesday, 01 May, 2013 17:12:38
Copyright (c) 2003, 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
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
4.真实路径下的目录实际上并未创建，而oracle也不会自动创建该目录
创建真是目录并修改权限：
chmod 777 lubinsu
chmod 777 dpump
将lubinsu用户下的dpump开放给其他用户
重新执行刚才的操作：
[plain]
[lubinsu@localhost oracle]$ expdp lubinsu/lubinsu dumpfile=lubinsu.dmp directory=DPUMP_DIR05
Export: Release 10.2.0.1.0 - Production on Wednesday, 01 May, 2013 22:24:43
Copyright (c) 2003, 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
Starting "LUBINSU"."SYS_EXPORT_SCHEMA_01": lubinsu/******** dumpfile=lubinsu.dmp directory=DPUMP_DIR05
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128.6 MB
Processing object type SCHEMA_EXPORT/USER
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/DB_LINK
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "LUBINSU"."T_TEST" 36.69 MB 393800 rows
. . exported "LUBINSU"."GRID_MSG" 20.79 MB 156588 rows
. . exported "LUBINSU"."BSS_PO_SPEC_D" 6.229 MB 26570 rows
. . exported "LUBINSU"."MANAGER_TM" 3.885 MB 65099 rows
. . exported "LUBINSU"."MANAGER_TM_T" 3.937 MB 65994 rows
. . exported "LUBINSU"."AREA_TM" 1.786 MB 33105 rows
. . exported "LUBINSU"."SERV_MSG":"P_CZ" 2.055 MB 10008 rows
. . exported "LUBINSU"."SERV_MSG":"P_HA" 2.041 MB 10008 rows
. . exported "LUBINSU"."SERV_MSG":"P_LYG" 1.991 MB 10008 rows
. . exported "LUBINSU"."SERV_MSG":"P_NJ" 2.011 MB 10008 rows
. . exported "LUBINSU"."SERV_MSG":"P_NT" 2.197 MB 10008 rows
.