Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • ora2pg

    Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

  • It seems that Oracle customers started using the Auto Index feature. I can see that when they migrate to YugabyteDB. YugabyteDB Voyager is a tool to ease the migration of schema and data. As YugabyteDB is PostgreSQL compatible, ora2pg is used when the source is Oracle. It extracts the schema and data. Some customers moving from Oracle ATP managed service (Autonomous Transaction Processing) reported that a few indexes were not extracted: the ones that have been created automatically by the Automatic Indexing feature of Oracle 19c.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Pgdsat – Postgres database security assessment tool for CIS benchmarks

    1 project | news.ycombinator.com | 4 May 2024
  • I don't want to fill out your contact form

    1 project | news.ycombinator.com | 4 May 2024
  • Desert greening is transforming dust and sand into farmable soil (2023)

    1 project | news.ycombinator.com | 2 May 2024
  • 87.7% of entrepreneurs struggle with at least one mental health issue

    1 project | news.ycombinator.com | 2 May 2024
  • Alice's Adventures in a Differentiable Wonderland

    1 project | news.ycombinator.com | 30 Apr 2024