ORA-01562 failed to extend rollback segment number stringCause: Failure occurred when trying to extend rollback segment.Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline. ORA-01650 unable to extend rollback segment string by string in tablespace stringCause: Failed to allocate an extent for rollback segment in tablespace.Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.ORA-27039 create file failed, file size limit reachedCause: An attempt was made to create a file that exceeds the process' file size limit, additional information indicates which function encountered the error.Action: Raise the file size limit.IMP-00028 partial import of previous table rolled back: number rows rolled backCause: Import encountered an Oracle error while trying to import a table. Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action. Then, if necessary, re-import the table.
1: exp system/manager inctype=complete file=c:\full_0913.dmp (9月13导入全备份)
2: exp system/manager inctype=incremental file=c:\full_0913.dmp (14日导出增量,该处不能写full_0914吗?)
两次的文件明也必须相同吗?
原来DMP是普通表存储的,新数据库使用了分区表IMP,建议从原系统中全部导出,再在新系统中重新导入。两次的文件名可以不相同
现在是从原系统中全部导出然后导入到新系统的:)如果两次文件名不同的话,那EXP是怎么确定上次导出了哪些,这次需要导出哪些呢,是把导出信息保存到了数据库中吗?还是在第二次EXP时检查上次导出的文件再和数据库现有数据比较呢?根据你的说法,那么第一次导出完全的DMP后,就可以把那个DMP转储后删除啦?
2、增加回滚段;
3、删除要倒入的用户;
4、重建要倒入用户;
5、IMP 刚做的备份;
COMMIT A value of Y specifies that Import should commit after
each array insert. By default, Import commits only after
loading each table, and Import performs a rollback
when an error occurs, before continuing with the next
object. Specifying COMMIT=Y prevents rollback
segments from growing inordinately large.
建议你做如下操作:
1、创建一个与你exp完全一样的实例(包括表空间等所有属性)
2、imp你的数据,然后再将相关的表分区等修改如果以上方法不行,再建议你增加如下两个参数导出时:
direct=y
recordlength=65535导入时:
commit=y indexes=n ignore=y
baffer=10485760(可自己调整)这样能极大的提高速度,可以试试
下次导时试试,我使用的还是笨方法,增加回滚段空间,导了14个小时才把整个库灌进去....
IMP里有些参数真还没有看过,有空真得研究一下啦,马上揭贴,谢谢诸位~