Description
📝 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?
- Linux
- macOS
- Windows
- Other
What browser are you using
Chrome
Other
No response