Skip to Content
0
Former Member
Sep 05, 2007 at 09:06 AM

ORA 2168: Create table with FREELISTS=000 and FREEGROUPS=00

54 Views

Hi All,

We are operating R/3 4.6C (SAPKB46C46), with HP-UX 11.23. Oracle

10.2.0.2. We started an upgrade (4.6C->6.0 sr2) on development system

(DR2). During the import phase (TOOLIMPD3) the Prepare was stopped with

Oracle error ORA 2168. The upgrade prepare wanted to create

QCM8PAT03_SDA table with FREELIST=000 and FREEGROUP=00, but it

couldn't. It seems the ASSM doesn't allow these values of the

parameters.

In SAP note 627246 is written that we should apply SAP Basis

packages.After point in time restore of beginning of the upgrade we

started to import 4.6C basis patches 47-52. During the phase

IMPORT_PROPER we got the same oracle error (invalid value of freelist)

when the package manager wanted to create different kind of indexes.

Kind Regards,

Ferenc