OS:AIX5.3 DB:ORA10GR2 Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_43": system/******** schemas=symbols directory=MYDIR dumpfile=UDBPROD_SYMBOLS_expdp_2008070104 03.dmp logfile=UDBPROD_SYMBOLS_expdp_200807010403.log parallel=10 Estimat...
大家好，我想备份数据库的一个表空间，想问下在expdp时用tablespace=XXX指定还是用schemas=XXX，他们两个有什么区别吗？谢谢
我在10的WEB控制台用HR模式export 出表REGIONS，然后在chenyijia模式下import这个表，出现下面错误： Import Submit Failed Errors: ORA-31627: API call succeeded but more information is available ORA-31655: no data or metadata objects selected for job ORA-39154: Objects from foreign schemas have been removed from import Exception : ORA-31627: API call succeeded but more information is available ORA-0651...
此脚本的目的是使用expdp工具对数据库的admin用户的所有数据进行备份,该脚本以oracle身份每周三 ,六 凌晨2点执行 0 2 * * 3,6 /home/oracle/scripts/dbbackup.sh cron日志:/var/spool/cron记录该脚本已经按时执行 Apr 4 02:00:01 ridb crond[5985]: (oracle) CMD (/home/oracle/scripts/dbbackup.sh) 但实际第二天并没有生成相应的备份文件 但以oracle 用户 手动执行该脚本可正常生成备份文件.有人遇到过类似问题吗? oracle@r...
