Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ora2Pg: Default subpartition migration error #1568

Closed
elexus opened this issue Dec 12, 2022 · 1 comment
Closed

Ora2Pg: Default subpartition migration error #1568

elexus opened this issue Dec 12, 2022 · 1 comment

Comments

@elexus
Copy link

elexus commented Dec 12, 2022

Hi, Darold.
You said, that you fixed our problem, but it's still there:
The problem not is in naming of partitions and subpartitions, but in referencing on parent table.
For example:
"DEF" is partition of "ABC"
and we create subpartitions "DEF_1", "DEF_2" and "DEF_3" of "DEF"
And when we create default subpartition "DEF_default" it references not "DEF", but "ABC"!!

As the result, we expected to see a lot of partitions, each of them had subpartitions including default, however we got a lot of default partitions of main table, what caused an error.

Previous Issue:
#1562

Here is the code-source and migrated code:

image

migrated to

image

@darold
Copy link
Owner

darold commented May 12, 2023

Hi, if you want me to solve such issue, I need to be able to reproduce and screenshot doesn't really help. What I need is a copy/paste DDL to be able to create the objects in Oracle quickly, if I have to write a use case by myself there is chance that I will never do that. As you see with the response delay time is a huge problem for me. Thanks for your understanding.

@darold darold closed this as completed Jun 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants