'Script causes this error, Import database from Oracle 19c to Postgres 12
Good day everyone! I'm trying to migrate from Oracle to Postgres according to the instructions https://habr.com/en/post/598313/, but I ran into a problem... I managed to upload it, but importing into the Postgres database didn't work.
[root@localhost client]# ./import_all.sh start -d client -o postgres -U postgres
ERROR: you must give a PostgreSQL database name (see -d option).
-a import data only -b filename SQL script to execute just after table creation to fix database schema -d dbname database name for import -D enable debug mode, will only show what will be done -e encoding database encoding to use at creation (default: UTF8) -f force no check of user and database existing and do not try to create them -h hostname hostname of the PostgreSQL server (default: unix socket) -i only load indexes, constraints and triggers -I do not try to load indexes, constraints and triggers -j cores number of connection to use to import data or indexes into PostgreSQL -n schema comma separated list of schema to create -o username owner of the database to create -p port listening port of the PostgreSQL server (default: 5432) -P cores number of tables to process at same time for data import -s import schema only, do not try to import data -t export comma separated list of export type to import (same as ora2pg) -U username username to connect to PostgreSQL (default: peer username) -x import indexes and constraints after data -y reply Yes to all questions for automatic import
Maybe I'm typing the wrong command...
I would be very grateful for help
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
