Home >Database >Mysql Tutorial >ORA-01281: SCN range specified is invalid错误
ORA-01281: SCN range specified is invalid错误
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 17:03:571545browse
在配置Streams，如果先配置streams的进程，还不存在需要的传输数据的用户容易出现ORA-01281: SCN range specified is invalid
在配置Streams，如果先配置streams的进程，还不存在需要的传输数据的用户容易出现ORA-01281: SCN range specified is invalid
select * from dba_capture
可以看到
ORA-01281: SCN range specified is invalid
这是因为先配置了数据库双向传输streams的进程，还没有创建数据库传输的用户。都是报scn不在范围之内。
可以把两端的数据库的Streams进程删除，，重新配置可解决上面的问题。
exec dbms_capture_adm.drop_capture('CAPTURE_STREAM')
exec dbms_propagation_adm.drop_propagation('SOURCE_TO_TARGET')
exec dbms_apply_adm.drop_apply('TARGET_APPLY_STREAM')
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MongoDB之DBref(关联插入,查询,删除) 实例深入Next article：RMAN恢复－system表空间恢复