日期:2014-05-17  浏览次数:20843 次

expdp导出错误
环境是这样的
vmware server里装的CentOS5.5
oracle 11g r1

新建了一个ighack用户,没有配额
一个表空间igtablespace 30m 最大300m 自动管理

ighack的默认表空间是igtablespace

create or replace directory dpump_dir as '/oracle/backup';
grant read,write on directory dpump_dir to ighack;

expdp ighack/***** directory=dpump_dir dumpfile=expig.dmp tables=ighack.user_info 
logfile=export.log

提示如下错误
ORA-31626: job does not exist
ORA-31633: unable to create master table "IGHACK.SYS_EXPORT_TABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 978
ORA-01536: space quota exceeded for tablespace 'IGTABLESPACE'

但在win7+oracle11g r1环境差不多
就是ighack 默认的是system
可以导出导入

------解决方案--------------------




ORA-31633: unable to create master table "string.string" 
Cause: Job creation failed because a Master Table and its indexes could not be created, most commonly due to the pre-existance of a table with the same name (job name) in the user schema. Refer to any following error messages for clarification.
 
Action: Select a different job name, DROP the existing table, or eliminate any problems indicated by the following error messages.
 
把expdp 语句改成下面试试:

expdp ighack/***** directory=dpump_dir dumpfile=expig.dmp tables=user_info logfile=export.log



------------------------------------------ 
Blog: http://blog.csdn.net/tianlesoftware 
网上资源: http://tianlesoftware.download.csdn.net 
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:63306533; 聊天 群:40132017
------解决方案--------------------
ORA-01536: space quota exceeded for tablespace 'IGTABLESPACE'

从这里看看原因