环境是这样的
vmware server里装的CentOS5.5
oracle 11g r1新建了一个ighack用户,没有配额
一个表空间igtablespace 30m 最大300m 自动管理ighack的默认表空间是igtablespacecreate 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
可以导出导入
vmware server里装的CentOS5.5
oracle 11g r1新建了一个ighack用户,没有配额
一个表空间igtablespace 30m 最大300m 自动管理ighack的默认表空间是igtablespacecreate 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
可以导出导入
解决方案 »
- 动态表名的truncate,求指导
- 已连接到空闲例程
- 根据其他表更新一个表。求sql语句
- 求助ORACLE死锁问题
- 定义一个表记录:v_tb 'inet_pm.'||po_tables(j)||'%rowtype'但是po_tables是一个索引表,请问下这个表记录怎么定义。
- 求助:有一个日期格式的字段,如果为空就让他显示为另一个日期格式的字段,不为空就把这个日期显示出来
- 关于索引的疑惑
- 装了oracle10g后, 找不到Enterprise Manager Console了,是没安装完全还是其它什么问题?
- 关于oracle exp/imp的问题
- 为什么我定义过的函数在调用时说没定义呢?
- 数据导出的错误
- 紧急求助!怎么把dmp文件成功导入??
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
但是新的问题来了我在win7+oracle 11g r1里导出了5张表后然把这啊dmp文件传到centos5.5里
但是导入的时候有些表,表结构是导放了但是数据没有导入,有的表只导入了一条数据,有的表所有数据都导入了;;;
Import: Release 11.1.0.6.0 - Production on Thursday, 12 August, 2010 16:52:58Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "IGHACK"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "IGHACK"."SYS_IMPORT_TABLE_01": ighack/******** directory=dpump_dir dumpfile=EXPIGHACK.DMP tables=ighack.result_info logfile=import.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "IGHACK"."RESULT_INFO" 7.093 KB 38 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
ALTER TABLE "IGHACK"."RESULT_INFO" ADD CONSTRAINT "CO_NO_FK" FOREIGN KEY ("COURSE_NO") REFERENCES "IGHACK"."COURSE_INFO" ("COURSE_NO") ENABLE
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (IGHACK.SRE_STUID_FK) - parent keys not found
Failing sql is:
ALTER TABLE "IGHACK"."RESULT_INFO" ADD CONSTRAINT "SRE_STUID_FK" FOREIGN KEY ("STUDENT_ID") REFERENCES "IGHACK"."STUDENT_INFO" ("STUDENT_ID") ENABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "IGHACK"."SYS_IMPORT_TABLE_01" completed with 2 error(s) at 16:53:05
dumpfile=expfile.dmp ;Export: Release 10.1.0.2.0 - Production on 星期四, 12 8月, 2010 18:17Copyright (c) 2003, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-29283: 文件操作无效
ORA-06512: 在 "SYS.UTL_FILE", line 475
ORA-29283: 文件操作无效借该贴补发一个相关问题,谢谢!
数据泵导出出错!麻烦大家帮我看看是什么问题导致的异常信息。
提示以下错误Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "IGHACK"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "IGHACK"."SYS_IMPORT_TABLE_01": ighack/******** directory=dpump_dir dumpfile=EXPIGHACK.DMP tables=ighack.class_info logfile=import.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-02374: conversion error loading table "IGHACK"."CLASS_INFO"
ORA-12899: value too large for column CLASS_NAME (actual: 21, maximum: 20)ORA-02372: data for row: CLASS_NAME : 0X'BCC6CBE3BBFAD3A6D3C3303031B0E0'
ORA-02374: conversion error loading table "IGHACK"."CLASS_INFO"
ORA-12899: value too large for column CLASS_NAME (actual: 21, maximum: 20)ORA-02372: data for row: CLASS_NAME : 0X'BCC6CBE3BBFAD3A6D3C3303032B0E0'
ORA-02374: conversion error loading table "IGHACK"."CLASS_INFO"
ORA-12899: value too large for column CLASS_NAME (actual: 21, maximum: 20)ORA-02372: data for row: CLASS_NAME : 0X'BCC6CBE3BBFAD3A6D3C3303033B0E0'
ORA-02374: conversion error loading table "IGHACK"."CLASS_INFO"
ORA-12899: value too large for column CLASS_NAME (actual: 21, maximum: 20)ORA-02372: data for row: CLASS_NAME : 0X'BCC6CBE3BBFACDF8C2E7303131B0E0'
. . imported "IGHACK"."CLASS_INFO" 6.460 KB 1 out of 5 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "IGHACK"."SYS_IMPORT_TABLE_01" successfully completed at 17:14:57
第二:有没有授权给scott读写权限
我给scott用户grant read,write 了该directory的权限了的。
文件夹最后的"/"除掉试一下