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

SAP HANA - Why partitioning is not allowed if tables is referenced

Hello Experts,

HANA issues error if i try to partition the table which is referenced by other table. Is it not possible to partition table which is referenced(foreign key) by other table?

At the same time if i add foreign key after the table is partitioned, it works fine. Is there any issues creating foreign key after table is partitioned?

Thanks,

Suren.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 17, 2014 at 10:27 AM

    Hey Suren,

    please post your code, table definitions and the error message.

    With a SP8 HANA instance I had no issues partitioning a table that has been referenced by a foreign key.

    - Lars

    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.