Below are the steps to fix the issue:
[oracle@db servers config]$ more /xxxxx/vardir_30001/temp/xxxxx.cfg
432: TEST.TESTACCOUNT TEST.TESTACCOUNT !TESTaccount_b_scheme
Error --> Source is defined in line 428 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once
433: TEST.TESTACCOUNTUSER TEST.TESTACCOUNTUSER !TESTaccountuser_b_scheme
Error --> Source is defined in line 431 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once
1. comment the lines 432 and 433
2. login to splex30001
3. col ROUTE for a60
4. set pages 100 lines 250
5. SQL> select PARTITION_SCHEME,ROUTE from SHAREPLEX_PARTITION;
6. you can see 2 lines for TEST.TESTACCOUNT and 2 lines for TEST.TESTACCOUNTUSER
7. please update the route in the below format with same partition_schema name
8. update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccount_scheme' ;
9. update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccountuser_scheme' ; commit;
10. This should fix the issue and you will be able to activate the config file.
11. for the below error the table in 257th line should be repeating. so please comment the line 257 also.
12. Error --> Source is defined in line 257 to same target
let me know if you have any questions.
[oracle@db servers config]$ more /xxxxx/vardir_30001/temp/xxxxx.cfg
432: TEST.TESTACCOUNT TEST.TESTACCOUNT !TESTaccount_b_scheme
Error --> Source is defined in line 428 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once
433: TEST.TESTACCOUNTUSER TEST.TESTACCOUNTUSER !TESTaccountuser_b_scheme
Error --> Source is defined in line 431 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once
1. comment the lines 432 and 433
2. login to splex30001
3. col ROUTE for a60
4. set pages 100 lines 250
5. SQL> select PARTITION_SCHEME,ROUTE from SHAREPLEX_PARTITION;
6. you can see 2 lines for TEST.TESTACCOUNT and 2 lines for TEST.TESTACCOUNTUSER
7. please update the route in the below format with same partition_schema name
8. update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccount_scheme' ;
9. update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccountuser_scheme' ; commit;
10. This should fix the issue and you will be able to activate the config file.
11. for the below error the table in 257th line should be repeating. so please comment the line 257 also.
12. Error --> Source is defined in line 257 to same target
let me know if you have any questions.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/223555/viewspace-691194/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/223555/viewspace-691194/