Shulou(Shulou.com)05/31 Report--

Oracle stored procedure execution error ORA-12828 how to do, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Today, a developer colleague called to say that his stored procedure executed an error ORA-12828 in Longyan City, saying that the code exited when it reached the following code block:

EXECUTE IMMEDIATE 'ALTER TABLE FACT_COSTS TRUNCATE PARTITION matching facts costing' | | PRM_MONTH | | 'update global indexes'

Check the oracle online documentation for an explanation of ORA-12828:

[oracle@se31 ~] $oerr ora 12828

12828, 00000, "Can't start parallel transaction at a remote site"

/ / * Cause: PDML transaction cannot be started because we are not in the

/ / coordinator site of the distributed transaction.

/ / * Action: Do not use PDML at remote sites.

[oracle@se31 ~] $

Query the oracle support knowledge base, there is a document (ID 1535660.1) related to ORA-12828

Information in this document applies to any platform.SYMPTOMS

The remote parallel index rebuild runs serial even if enabling parallel replication propagation at the database link level. For example if a database link is created for a particular destination database, and enabling parallel propagation for a database link, then Oracle uses multiple parallel slave processes to replicate to the corresponding destination. But it doesn't work while parallel index rebuild remotely through a procedure. In detail:CAUSEAs the Bug 14684769 states, this works as expected and it is not supported to parallelize the index by using the dblink.SOLUTION

The dblink is not supported to parallelize the rebuild index.

As per the fix for Bug 2166879, create index will not be compiled for parallel execution if it is being executed in a distributed txn.

BUG:2166879-ORA-12828 WHEN INDEX CREATED IN PARALLEL MODE THROUGH REMOTE PROCEDURE

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.