oracle-graph

Backup oracle graph


We are using PG views for the graph. Currently is looking for the easiest way to backup or transfer data.

How can we backup existing graph or anyways to transfer/duplicate to another server?

Any solution would be appreciated. Thank you.


Solution

  • Since PG views are composed of regular database tables, you can apply all existing methods for export/import, such as Oracle Data Pump (expdp/impdp). Please note you need to include or re-create the metadata tables.

    Metadata Tables for PG Views: https://docs.oracle.com/en/database/oracle/property-graph/22.1/spgdg/property-graph-views-oracle-database-tables.html