Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2007 at 04:53 AM

    Hi,

    Please check the following note from service marketplace.

    It shows some code changes in one of the ABAP report.

    Try to change that report.

    Note 627246 - Error when you create new objects. ORA-02168

    Regards,

    Payal

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      If you applied the notes <b>after</b> getting the error you will not solve the problem.

      The statements to create the table/indexes are already generated and stored on the table DDSTORAGE. You should check this table with SE16 and modify all entries with FREELISTS or FREEGROUPS

  • Posted on Sep 08, 2007 at 06:54 PM

    Hi Ferenc,

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

    No that is not correct. If you are using LMTs with ASSM - it is valid to use the freelist/freegroup parameter, but they are ignored by oracle.

    How do you migrate? With sapinst (and automatic migration monitor) or manual with migration monitor or distribution monitor?

    Maybe the table is included in some <TABART>.SQL files ... so you can modify the syntax.

    If i have a look at your first posting the syntax for freelists / freelist groups is wrong. For the right syntax have a look here:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/clauses009.htm

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.