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'
从这里看看原因