From: Ricardo Martin Gomez <rimartingomez@hotmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
To: Pepe TD Vo <pepevo@yahoo.com>
Subject: Re: ora2pg import
Date: Wed, 30 Jan 2019 01:48:13 +0000
Message-ID: <SC1P15201MB230456ED900C2C19B66CC691A3900@SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <2010028052.3165566.1548781793713@mail.yahoo.com>
References: <2010028052.3165566.1548781793713.ref@mail.yahoo.com>
<2010028052.3165566.1548781793713@mail.yahoo.com>
Hi Pepe,
First, you have to understand some differences between PostgreSQL and Oracle.
In Oracle: schema = user. All objects there are inside the schema.
In PostgreSQL: schema does not exists. Database != user. All objects there are inside the database.
Obtener Outlook para Android<https://aka.ms/ghei36;
________________________________
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: Tuesday, January 29, 2019 2:09:53 PM
To: Pgsql-admin
Subject: ora2pg import
Hello expert DBAs,
would you please show me how to import scripts from Ora2pg into postgres db using each schema?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rimartingomez@hotmail.com, pgsql-admin@lists.postgresql.org, pepevo@yahoo.com
Subject: Re: ora2pg import
In-Reply-To: <SC1P15201MB230456ED900C2C19B66CC691A3900@SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox