search

cybertec-postgresql / cybertec_migrator

CYBERTEC Migrator 🗄🔀🗄
MIT License
22 stars 7 forks source link

Partition Error querying meta-data #38

Open delattresylvain opened 1 month ago

delattresylvain commented 1 month ago

📝 Description

I'm trying to migrate an oracle 10gR2 with trial/standard edition.

On the Analyze step i'm having the following error, it's seem this column doesn't exist before oracle 11g.

Is it possible to disable the partition check as it's not available on cybertec migrator trial/standard ?

error querying meta-data for partition(partition): ORA-00904: "T"."INTERVAL" : identificateur non valide executed query on Oracle: SELECT REPLACE(t.owner, CHR(0), '') "schemaName", REPLACE(t.table_name, CHR(0), '') "tableName", REPLACE(p.partition_name, CHR(0), '') "partitionName", p.partition_position "partitionPosition", REPLACE(c.column_name, CHR(0), '') "columnName", c.column_position "columnPosition", t.partitioning_type "partitionType", CASE WHEN t.subpartitioning_type = 'NONE' THEN NULL ELSE t.subpartitioning_type END "subPartitionType", t.interval "partitionInterval",

        -- Range and List partitions
        p.high_value "highValue",

        -- Hash partitions
        t.partition_count "modulo",
        (p.partition_position - 1) "remainder"
   FROM dba_part_tables t
   JOIN dba_part_key_columns c
        ON t.owner = c.owner
        AND t.table_name = c.NAME
   JOIN dba_tab_partitions p
        ON p.table_owner = t.owner
        AND p.table_name = t.table_name
  WHERE t.owner IN ('ADABAAA')
  ORDER BY t.owner, t.table_name, c.column_position, p.partition_position

📜 Steps to reproduce

Create a migration with an Oracle 10gR2 as a source database Go to step 4 "analyze"

🙁 Actual behavior

Unable to go to the next step

🙂 Expected behavior

Support for oracle 10gR2 dba_part_tables structure or a check box to disable partitionning feature ?

Migrator version

3.18.4

In which environment are you operating?

What browser are you using

Chrome

Other

No response

KieranKaelin commented 4 weeks ago

Bonjour @delattresylvain !

Thanks for trying out our Migrator and reporting this bug. Our automated testing setup currently only covers Oracle 11 and upwards, as we never had a customer migrating from Oracle 10 before.

I've quickly tested against a local Oracle 10 XE running in docker, patching out all the incorrect system catalog queries done by the Migrator. \ If you want to try it out, you can download it from our download server. To upgrade your installation, please follow the instructions of the offline upgrade.

I've taken on the ticket for proper Oracle 10 support onto our roadmap, although I can't give any time-frame its resolution, as we're currently working on other feature requests for our customers.

Cordialement, Kieran

delattresylvain commented 3 weeks ago

Hi @KieranKaelin ,

I'm still facing an error

Screenshot and migrator logs in attachments if it can help.

Regards, Sylvain

migrator-core-2024-10-31-153612.log.gz

image