本文主要是介绍存储过程定位问题，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
定位问题:
select * from dba_recoverable_script;
SELECT * FROM DBA_RECOVERABLE_SCRIPT_BLOCKS WHERE BLOCK_NUM=19
BEGIN
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
schema_names => ‘ning’,
source_directory_object => ‘DIR_SOURCE’,
5 destination_directory_object => ‘DIR_DEST’,
6 source_database => ‘ning.test’,
7 destination_database => ‘dest.test’,
8 perform_actions => true,
9 dump_file_name => ‘export_ning.dmp’,
10 capture_queue_table => ‘rep_capture_queue_table’,
11 capture_queue_name => ‘rep_capture_queue’,
12 capture_queue_user => NULL,
13 apply_queue_table => ‘rep_dest_queue_table’,
14 apply_queue_name => ‘rep_dest_queue’,
15 apply_queue_user => NULL,
16 capture_name => ‘capture_ning’,
17 propagation_name => ‘prop_ning’,
18 apply_name => ‘apply_ning’,
19 log_file => ‘export_ning.clg’,
20 bi_directional => false,
21 include_ddl => true,
22 instantiation => DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA);
23 END;
24 /
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
schema_names => ‘ning’,
source_directory_object => ‘DIR_SOURCE’,
5 destination_directory_object => ‘DIR_DEST’,
6 source_database => ‘ning.test’,
7 destination_database => ‘dest.test’,
8 perform_actions => true,
9 dump_file_name => ‘export_ning.dmp’,
10 capture_queue_table => ‘rep_capture_queue_table’,
11 capture_queue_name => ‘rep_capture_queue’,
12 capture_queue_user => NULL,
13 apply_queue_table => ‘rep_dest_queue_table’,
14 apply_queue_name => ‘rep_dest_queue’,
15 apply_queue_user => NULL,
16 capture_name => ‘capture_ning’,
17 propagation_name => ‘prop_ning’,
18 apply_name => ‘apply_ning’,
19 log_file => ‘export_ning.clg’,
20 bi_directional => false,
21 include_ddl => true,
22 instantiation => DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA);
23 END;
24 /
这篇关于存储过程定位问题的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
