--expdp导出:
1.创建数据泵路径:
SQL> create or replace directory imostdb as '/opt/oracle/imost';
---Directory created. //需确保/home/目录空间足够大(提前进行备份验证)
2.赋予导出用户“导入导出”的权限
grant connect to imostdb_cs;
grant dba to imostdb_cs;
grant exp_full_database to imostdb_cs;
grant imp_full_database to imostdb_cs;
grant resource to imostdb_cs;
3.导出数据:(dmp文件在数据泵路径下)
expdp userid=imostdb_cs/'%TGB6yhn' directory=imostdb dumpfile=Expdp_imost_20150318.dmp LOGFILE=Expdp_imost_20150318.log SCHEMAS=PROMOTION CONTENT=METADATA_ONLY;