Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goezF-0003F8-Dt for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 01:48:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goezE-0008Fd-10 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 01:48:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goezD-00089M-D6 for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 01:48:19 +0000 Received: from mail-oln040092003022.outbound.protection.outlook.com ([40.92.3.22] helo=NAM02-BL2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goez9-0003Ig-FA for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 01:48:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=DUtsbF+bHFGH1gAskjKXUNN08T9mf6AnuYq0zqN1Uqk=; b=rqv2NbtU2c53GvxXopF25/iqUWPgPdQgTLtPyTJoJgQBt78WVKKIiurWvI+cP3H++jK8quERpGxdTYQrxsWM6x3CDbomAtLQ9MoShQwuwONxeoZ215m4xIAyctaF9MNC3h54hQdNB3vjObkDzvT/S7Un9QZ6cJSn/nChrLyIJQdZf5XQtMoONH/Zn9UXkM97rTVNMKNzepbNZgQUFw8EFKyWZs052hP/CqHIxcgzEJTF7zMfqYcexDpASIFuIrbU6kUp8xDiuUbto6ZDeuOcmfrXuxq1HVgYAmH9NUKJm0/KRrj+N38zJe9ylxVn2AtbWr6R2xcg51yBu5x9URPiiA== Received: from CY1NAM02FT026.eop-nam02.prod.protection.outlook.com (10.152.74.56) by CY1NAM02HT207.eop-nam02.prod.protection.outlook.com (10.152.75.201) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1580.10; Wed, 30 Jan 2019 01:48:13 +0000 Received: from SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM (10.152.74.54) by CY1NAM02FT026.mail.protection.outlook.com (10.152.75.157) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.1580.10 via Frontend Transport; Wed, 30 Jan 2019 01:48:13 +0000 Received: from SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM ([fe80::1ca1:beec:530c:2a03]) by SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM ([fe80::1ca1:beec:530c:2a03%2]) with mapi id 15.20.1558.023; Wed, 30 Jan 2019 01:48:13 +0000 From: Ricardo Martin Gomez To: Pgsql-admin , Pepe TD Vo Subject: Re: ora2pg import Thread-Topic: ora2pg import Thread-Index: AQHUt/WBHotDnnGrm0urhjUpJi5cfqXHC80q Date: Wed, 30 Jan 2019 01:48:13 +0000 Message-ID: References: <2010028052.3165566.1548781793713.ref@mail.yahoo.com>,<2010028052.3165566.1548781793713@mail.yahoo.com> In-Reply-To: <2010028052.3165566.1548781793713@mail.yahoo.com> Accept-Language: es-AR, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:C952D93C159BDDA25D6ABF715EB8CC416CEAE975DAAC28B6EDA05EB3D68AFD5F;UpperCasedChecksum:5026F8345C7F3825A6FD079703684BCC7593A7BAE2D8AF4C4032FF96AC900DBE;SizeAsReceived:7064;Count:46 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [K4RHbkvrDDs1xHLB2y4EZzA4KrhCAa9z] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;CY1NAM02HT207;6:8/zXXLyICOLJV171Tk4DaN7GXXvPaCHVeztKPJAi5ISE6/o3wbl9u8f/yUJiWHyj/mIQZ8HT6zNXrdcQym8fNv6Tp4eRyI20IgS6a+nttC0DLU12DpExkNeF3Lb3tKEDyiv/6sq+qrBNAabTofcTkOrJRH/ncoA9CmMuqO0Addbg7+H17UFzwK9aFWxx1CdVYGDM8NxJjFxfAceS4H7oXRR1edFGZk8KSnXr9gdhNiBrG2x41nYHh20w9vgHBKhbJEvX35ztUqNH636J7gHhKn4KpMoTmYDPWrxg6meyKOS5fNiQJj68H1P7XmKbn6G/4h1Z8QQQ7huQOXuSO6idPTux2rxrwDk+UL405H2Mkt8koVbhVTF4vbU/duB/Pt3NgrsgD5rtMayt5Uy6D/zhrWNbHqdCyPn150GN4pV4yZzYc0+5SUL3r3S7/rWAPMscKBxE51Drc4hRJVWpcp1L8g==;5:D7ylZudd/0tijldoqrsul/LmqTkA3CtB3ScSwGgrf1+CmEbnakVW6lxTq3fZ6IvVgdi3blgftGZxKU9KF0ctDB7uo/62BdWakinvPhrtfhyi//tc6NSxUGjix4DY8hIHBiT9zP6AdSa1JM2p7+f8tuNBCT07RE0iPrY7Kk+wFMqQbzjdedFo46oh154d3Em2ICuTakZ6LBIQVIAd++NLxg==;7:VJan0SGxZWzChnyFdIrjndXfkwzGMAFKab7lJsA9c5ZVM4htjwcMYMUHQ8F5ukGbJKEuNyhvvBTNgooj3SKauIT/ce37baCR7cmKFaf1oT/0koVMCETafBy/s7DsNSGGwnJ0lsRjBq3006Pp/pkEEA== x-incomingheadercount: 46 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031323274)(2017031324274)(2017031322404)(1601125500)(1603101475)(1701031045);SRVR:CY1NAM02HT207; x-ms-traffictypediagnostic: CY1NAM02HT207: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(4566010)(82015058);SRVR:CY1NAM02HT207;BCL:0;PCL:0;RULEID:;SRVR:CY1NAM02HT207; x-microsoft-antispam-message-info: +cPAF8f2kxy2nODDl1hOcJLyK7juMDDfDJ77SAVZ+yXEmsTQGE4RXbZuKI5QgS4s Content-Type: multipart/alternative; boundary="_000_SC1P15201MB230456ED900C2C19B66CC691A3900SC1P15201MB2304_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-Network-Message-Id: a0c1a906-3691-4bfd-dde3-08d68654ff0b X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Jan 2019 01:48:13.2625 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1NAM02HT207 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_SC1P15201MB230456ED900C2C19B66CC691A3900SC1P15201MB2304_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Pepe, First, you have to understand some differences between PostgreSQL and Oracl= e. In Oracle: schema =3D user. All objects there are inside the schema. In PostgreSQL: schema does not exists. Database !=3D user. All objects ther= e are inside the database. Obtener Outlook para Android ________________________________ From: Pepe TD Vo 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?