求助~~~~~~~~~~导出问题(在线等待)

[复制链接]
查看11 | 回复7 | 2011-8-6 00:48:09 | 显示全部楼层 |阅读模式
Use consistent =y while exporting & check whether you are getting the error or not.
Export extracts data by issuing a series of SELECT statements and the snapshot
time of each table's data corresponds to when the SELECT statement was issued
for that table. If there is no database activity, then this is not an issue.
However, it is possible to manipulate the table after the export has started
in which case the snapshot of the data may be a factor. Export does not get
an exclusive lock on any table.
There is an option called CONSISTENT=Y. When this is enabled, EXPORT first
issues a SET TRANSACTION READ ONLY command before doing the export. There is a
risk of running out of rollback segment space and getting an "ORA-1555 snapshot
too old (rollback segment too small)" error when doing a long running export.
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
then what do u want to talk about?
how to avoid the "ORA-1555 " error?
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
导入数据时出现快照过旧,oracle的回答是如上
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
导出时最好把数据库置为只读模式?
CONSISTENT=Y只是检查是否将数据库置为了只读模式,否则可能回引起ORA-1555 错误?
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
但是之前即使业务没停,导入导出也没出现这样的错误,
小弟是菜鸟,请教高手在导如导出时应注意什么
一个表的数据量已经达到5g多,blob字段,导入时总出错
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
抬起来
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
这个错误一般是回滚段被重用时发生,可以通过增加回滚段来缓解。如果不是必须在导出是不要加consistent =y就不会报错了
回复

使用道具 举报

千问 | 2011-8-6 00:48:09 | 显示全部楼层
。。。。。。。。。。。。。。。。。。。。。。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行