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 1gor7a-00054U-KO for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 14:45:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gor6b-0006zo-EY for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 14:44:45 +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 1gor6a-0006zh-Hs for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 14:44:45 +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 1gor6X-0002Ki-9f for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 14:44:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548859479; bh=nykD1bKtNgY4mG1twckjkCDAeMf2kLbHhFWLtSDqQ5g=; h=Date:From:Reply-To:To:Cc:Subject:References:From:Subject; b=iLctv63EYCo98S0wHc2tQ0EqMN1hRPehrDoKDknMA/JFmadc99LjD4HHlufO5vhdKTNQxzmve7yZX3KmQolVQjQK3QC79QGyMwvr/Eu9+Mp2JaFftwOlSJBR49KjxkDlbJTJJ+rDgI0R80KCfWlNWwwKb4mzGEVDozYuIwCwGLxg5MdQ8mpXlSHED39vV2lO5E9hSXmtctNtVWdtIbGYMGKSjMIkatOGz/SLkmwamt7Ly2KcLuBCqpFkUDrw453O5hh38EE9AoVwr2M2jdK7jCHZXqrqWIVH2zLnmhs9XbWu2q9Gbb8JVaPJODCpkCzCTYrU0EaJJvzel0v8Ffg1aQ== X-YMail-OSG: KZbE.ykVM1mGHP8CIBT1cB7XkxLxoJVeAxKAZ5iw52YUlgoOIE7MQs9tZ.354vu D3R6mOdPfcriljImWAI1k092X9.boV2UMDdv_0kAw4AXtzZ6lAzOHgFXOZnJEaLn4ufRzq.EIVSG vRVUMPldUxJXVLTaPQn.Y0.a5Uct.AgkN1XVMHFKYUSZu5dnik0ozvejvjExVaRMZ04xTfIUhGrV AGB7MM4V_elzjMQQ5T5a8bhpnFYLCqwA3ocFzkvrg9ne8Ir.LgxEsCh13P3KJh2psg_AGLTvuUXA 17LMOpKkj5tJtzFRSjZUKrJMcsN2BvjRcuDpP.BurKRbcwS7Dr_VHnb1jwF_fiDjR4BcTiX1FljL 6OfC.f_VsfFanEJAq1XTIXSAc9fLSczAJ6LiYmV96scbzjX56988L49UhlJETTlyaAi8hfjBgfpV VWoW7NlqSrSwQuALI.fir0DGKal3JbGfj2.C9oTjhcK34Au1BBAX6Gx_JevMuF1HvUQzdxJEUN6E EdZ1weO9kevS9OnFMEztSC.is0P8dFFnGxw7S5Y9IVLGGJ7MoSi3ye_bxkXBYc7pAdOlIyEnyTSn Td3Q9Rps86dMejNaS.y4vRdMWshfCwd51o1TDNx1g4LPa2ENKL9m33I7bBd.OmtqF6oNpjCYOxpZ 33Zun8PsbuZsbNQKt1Fk9klFbuCPGuNtC29ldV_6zeST9A5cutSGDjgOx4xR_VAvp1zD_6.3CBso qcl8xiFfpOk0z42eXS5k_GzEpUCFwt1nWJsE4UlSUrKRb6b6hC_5ifLCAwJLjspX3B1TC8GI_N6b 1J.oYv5vKTfPMkEmSitdMCfkA8oTzDqRHwDkECirPcfG745VPMMOVRmI_B4Nqj2SrLpqE5JDU2MP WBxa_ulZ1N7tNO5jzDr9LxDEC.akhPUKjgLVtZOgCXBVL1qXbaWoWGmDIuXGNGtBA3t7pGdNdnsE PR2J3CR4EWRFRjNMmcJ6OxmepLI.uRb6SPjmclAytQYP3Jus8J4mgFjTLete0oPYBJzPkRCSwC3i I.WXXCTrLQ0TqO8YiYmOc8mA.7XXfBH0ZFx5uioePNxDtcMNZ1iTgzTsUYZxOTUCMuSLtn3auNA- - Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Wed, 30 Jan 2019 14:44:39 +0000 Date: Wed, 30 Jan 2019 14:44:31 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <1983808530.189367.1548859471976@mail.yahoo.com> Subject: Re: ora2pg import MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_189366_893641429.1548859471974" References: <1983808530.189367.1548859471976.ref@mail.yahoo.com> X-Mailer: WebService/1.1.13027 YahooMailNeo Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 15566 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_189366_893641429.1548859471974 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable that's what I thought and I did create the schemas under CIDR db=C2=A0yeste= rday and I think I need to revise all the scripts export from Ora2pg with "= schema_name." in front=C2=A0of the function/trigger/table names scripts. thank you so much for the input. v/r,=C2=A0Bach-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=20 On Wednesday, January 30, 2019 1:11 AM, Shreeyansh Dba wrote: =20 In Addition, The oracle user name and schema have the same identity. In Po= stgreSQL user and schema differ and you need to create a schema explicitly.= Otherwise, it will go into default schema. Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Wed, Jan 30, 2019 at 11:02 AM Shreeyansh Dba = wrote: By default the Oracle schema is not exported into the PostgreSQL database a= nd all objects are created under the default Pgnamespace. Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Tue, Jan 29, 2019 at 10:40 PM Pepe TD Vo wrote: 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 =20 ------=_Part_189366_893641429.1548859471974 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
that's what I thought and= I did create the schemas under CIDR db yesterday and I think I need to revise all the scripts export from Ora2pg with "schema_name." in f= ront of the function/trigger/table names scripts.

thank you so much for the input.

v/= r,
 
<= /font>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 forgive more.<= /div>
To call him a dog h= ardly 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 to those who = knew him well, he was a perfect gentleman (Hermione Gingold)<= /font>

**Live simply **Love g= enerously **Care deeply **Speak kindly.
<= span class=3D"yiv3927877794sg" id=3D"yiv3927877794yui_3_13_0_rc_1_1_1381789= 421038_7865">*** Genuinely rich *** Faithful talent *** Sharing succe= ss


On Wednesday, January 30, 20= 19 1:11 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:


In Addition, The oracle user name and schema have the= same identity. In PostgreSQL user and schema differ and you need to create= a schema explicitly. Otherwise, it will go into default schema.

Thanks &am= p; Regards,
Shreeyansh DBA Team
= www.shreeyansh.com


On Wed, Jan 30, 2019 at 11:02 AM Shreeyansh Dba <shreeyansh2014@gmail.com> = wrote:
By default the Oracle schem= a is not exported into the PostgreSQL database and all objects are created = under the default Pgnamespace.

Thanks & Regard= s,
Shreeyansh DBA Team
www.shreeyansh.com
=


On Tue= , Jan 29, 2019 at 10:40 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Hello expert DBAs,
=
would you please show me how to import scripts from Ora2pg into postgr= es db using each schema?
From ora2pg, there's no export the whole database but one by one = schema.  
Do I need to create each schema on postgres db and how do I run the ex= port script per schema?  If I import them by postgres 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.
 
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 forgive more= .
To call him a dog = hardly seems to do him justice though in as much as he had four legs, a tai= l, and barked, I admit he was, to all outward appearances. But to those who= knew him well, he was a perfect gentleman (Hermione Gingold)=

**Live simply **Love generously **Care deepl= y **Speak kindly.
*** Gen= uinely rich *** Faithful talent *** Sharing success


=
------=_Part_189366_893641429.1548859471974--