Facing Error While Running Table_reorg (Doc ID 1668676.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Customer is on 7314 and running the table_reorg as:

begin table_reorg.check_reorg('T');end;

They get the below error while running the table_reorg.check_reorg('T') procedure. It runs for 45mins then gives the below message:

Error starting at line 1 in command:
begin table_reorg.check_reorg('T');end;
Error report:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "DEMANTRA_UF.TABLE_REORG", line 267
ORA-06512: at line 1
01422. 00000 - "exact fetch returns more than requested number of rows"
*Cause: The number specified in exact fetch is less than the rows returned.
*Action: Rewrite the query or change number of rows requested

OR

 

They are getting the following error

 DEMANTRA@DMTRDEV>exec table_reorg.reorg
('DEMANTRA','SALES_DATA','C',30,30) ;
BEGIN table_reorg.reorg('DEMANTRA','SALES_DATA','C',30,30) ; END;
*
ERROR at line 1:
ORA-02207: invalid INITRANS option value
ORA-06512: at "DEMANTRA.TABLE_REORG", line 1041
ORA-06512: at line 1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms