使用游标复制现有数据库 [英] replicate existing database using cursors

问题描述

如何使用pl / sql中的游标复制现有数据库？

How to replicate an existing database using cursors in pl/sql ?

推荐答案

对任何SQL使用游标都是浪费资源，所以你必须避免使用它您可以。复制数据库肯定你不能使用光标！

了解Oracle的复制方法，而不是使用正确的工具来完成正确的工作...

http://docs.oracle.com/cd/A58617_01/server.804/a58227/ch_repli.htm [ ^ ]

http://www.oracle.com/technetwork/articles/systems-hardware-architecture/o11-080-art-data-replication-487868.pdf [ ^ ]

http://www.oracle.com/technetwork/database/featu res / data-integration / index.html [ ^ ]

Using cursor for any SQL is a waste of resources, so you must avoid it if you can. To replicate a database for sure you can't use a cursor!
Learn about Oracle's replication method than use the right tool for the right job...
http://docs.oracle.com/cd/A58617_01/server.804/a58227/ch_repli.htm[^]
http://www.oracle.com/technetwork/articles/systems-hardware-architecture/o11-080-art-data-replication-487868.pdf[^]
http://www.oracle.com/technetwork/database/features/data-integration/index.html[^]

这篇关于使用游标复制现有数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！