Skip to Content

How to partition PCL2 table

Hi experts,

the customer asked me to make a partition on the table PCL2.

Do you have any suggestion about it? There are specific criteria to partitioning on this table? Is there any documentation SAP?

There are specific indications for the HR tables?

Please help me.

Thank you very much.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 06, 2014 at 05:37 PM

    Hi

    Why does your Customer want to create partitions for that table ?

    There is a note on parition engine, but it is designed to be used to speed up archiving of data.

    Partitioning is native on BW but not on ERP.

    742243  - General table partitioning as of SAP_BASIS 46C

    722188  - FAQ: Oracle partitioning
    1333328  - Partitioning Engine for Oracle

    If performance is the reason there are other ways to improve it, table and index compression can be useful (even if it might not be that efficient for a table such as PCL2 that contains a LongRaw field)

    An other solution would be to migrate the LongRaw field to a  Securefile if your Oracle version is 11g.

    Securefiles are supposed to improve performance

    1426979  - Oracle 11g: SecureFiles - The new way to store LOB data

    Regards


    SecFile.jpg (42.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jose,

      thanks for your support.

      I would like to know about partitioning you did:

      Was it via Oracle or SAP (TCODE SE14)?

      What kind of partitioning option did you use?

      I suppose you used “RANGE” option on the first step and then “LIST” option,

      is this correct?

        Regards