My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.