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 1goWtj-00007Z-R3 for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 17:10:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goWti-0004vT-ER for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 17:10:06 +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 1goWth-0004tR-ON for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 17:10:06 +0000 Received: from sonic303-3.consmr.mail.bf2.yahoo.com ([74.6.131.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goWta-0008J1-3j for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 17:10:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548781795; bh=h6tifaNfmFtNRzABWJ8IaXJAa0bgfa96GCXt1tI+g+8=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=UHqEPt8lxkymuxT7KIXCkimhnI+2tgHYUY6qt6J49fyTWJ0qCMQOSPCmnj60xf3s8gpey8IX4Dkdu/XHloLI2X+puC1QgQVDCCqpV34WB+eSX0B5tUq1af1qt2lNBUoZCmcs8LvARpaorbzeAh0wKYXV4IPWvocfV8sOQm6LeWYmVjkeFMuRXZ4lfWOUqV5Y886WKXdM2ckLdGGJ1XI7d7kIsE2Pscrs28UL+8QgSMgwK/WLKh/SAbpYwto3AIuvIdCFkZa7HEzpIR/FZJphDHTAIzBnFcp/RNag5i3t9asNZ5s9EsC5xSEbjBJ+p2lV+yWNioS94H8nUy/qfvmfJg== X-YMail-OSG: BfCGmaMVM1mc6jCjmi.HSa.a5OnmyvrepGBqAcH61Z6cpjDDe0Qjubl.RzEkY.i bZR6nsdM.DjSOT0hNZK5zo_bu9NxWZ5sgIqA_EX88sE5hUaXrV_JncNi.mW8N8xpvxo6YNdV23ol VfIVfUxXz67UFlG_0EHh1MpndQ0._JBGw53BSlSDzH8Pe4qzP5QGL94QOeiTTiUZtW3ShmQNER6k IzkrbtgArDIkVcVtxStmv4hoViu9yRAhdEXFCdL4YnBTk0f07UP_fW27yLJ1izyPj1wjVqmpEdR7 my.yjga_hXmjDUFLt_vZFLYqoH.eWpKv1LAsAMlW9caXliFd6Ba2ama17OeMbJvN0p06r4Jwfz3h D8sXURbinOb9f45yxRE7pMTmb1n5EQJKUXQxeTUV6tnZyhiMnPqks5BiHUy.e1VC5b27U7h0jaId RsNhmgsLxVi8.uuf2cMT81OKPAhaF4L51mIWmE48q1jpuShWEaZE7uma9tujXjF9BCb4WsvEHpUn 9CyCD2Ro3jhyWtNQLfgt9aHkuwsQ9t3UKKs4Lzv0bQ6iXFUYxwt9a7XTI8iQ1GThG4aEY_oSjL1A q_Y2ooDQFHdHJPPx6edcim4h8iEBnVSA32fMrGk9wtocFugQD.VkAJ01eJ5QUkOjY7ojij7uAcMu zRGuDVt8.MxWR1RqKd8jrSBZBlgR71S_uNCy3tZTgFoVrsjF940DO6DSgdot8_ZdRXZHLfxESL85 iuG9TK1fonauhAujWUpWqJaHhUoMvnm491HxVvWV2mpxSaRltdUi8krcvI8WU0YjnFxghpPRSlQ6 LtPNocPkLoH2bisYxoZVV4aoCcCwiG2eJvBymXKykfKyL1svQ.uaDC2IfH.Jdp4cY9WFdZA.3BQe YT7lh_BPnXj4aJKQom.ALik963sshyWxG9gxIfE5EnvPSLfrdSm2Wfpf7D5F940vu0p9fSK9y_we 86srkuGmtnJfQ_Utzt.lHlmQBZRTteVlSgsUsT4FDwpwFIkkGYSu.Owf5.gcqzCXcNIuNJ1RYIva rXxQ1Og.zsxa1HdhzN5Dv6EJn3fasiu31.NcyZ8CEfmvS.Gtb_06sPB67sQ-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Tue, 29 Jan 2019 17:09:55 +0000 Date: Tue, 29 Jan 2019 17:09:53 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <2010028052.3165566.1548781793713@mail.yahoo.com> Subject: ora2pg import MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3165565_667810051.1548781793710" References: <2010028052.3165566.1548781793713.ref@mail.yahoo.com> X-Mailer: WebService/1.1.13027 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 4499 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3165565_667810051.1548781793710 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello expert DBAs, would you please show me how to import scripts from Ora2pg into postgres db= using each schema?From ora2pg, there's no export the whole database but on= e by one schema.=C2=A0=C2=A0Do I need to create each schema on postgres db = and how do I run the export script per schema?=C2=A0 If I import them by po= stgres all the tables, index, etc... will be under postgres user right? what I need to do for this import from sources of Oracle?thank you.=C2=A0Ba= ch-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success ------=_Part_3165565_667810051.1548781793710 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello expert DBAs,

would you please show me how to import scri= pts from Ora2pg into postgres db using each schema?
From ora2pg, there's no export= the whole database but one by one schema.  
Do I need to create each sc= hema on postgres db and how do I run the export script per schema?  If= I import them by postgres all the tables, index, etc... will be under post= gres user right?

what I need to do for this import from sources of Oracle?
thank you.
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid = people for their mistakes you will be alone. So judge less, love and forgiv= e more.
To call him a dog hardly seems to do hi= m justice though in as much as he had four legs, a tail, and barked, I admi= t he was, to all outward appearances. But to those who knew him well, he wa= s a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak k= indly.
*** Genuinely rich *** Faithful talent *** Sharing = success
------=_Part_3165565_667810051.1548781793710--