Closed mihan-22 closed 11 months ago
Why do you want to avoid exporting partitions, they will be missing in the export? Actually this is a known problem, enable RENAME_PARTITION in ora2pg.conf and Orap2Pg will take care for you of duplicate partition name.
Hello, what we describe may not be the same thing, you can use this RENAME_PARTITION parameter when exporting partition tables. However, when we create a table, when querying the information in the Oracle database, if the table name and index name with the same name appear, then there must be two records in the DBA__PART_KEY_COLUMNS table. After a natural connection to the DBA_PARTTABLES, there are still two records (in the Oracle database). When we look for the partition key through the fetch function, we will query two identical values together as the partition key. As shown in the following `figure.
_`
Oracle allows the same table name and index name, so two records may appear in the query DBA__PART_KEY_COLUMNS, DBA_SUBPART_KEY_COLUMNS and DBA__PART_KEY_COLUMNS, object_type table and index. Causes functions such as _get_partitions, _get_subpartitions, _get_partitioned_table, and so on to log two results, and eventually, two identical partition keys exist for a table