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 1goU36-0007Fl-WA for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 14:07:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goU34-0006Qe-Ic for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 14:07:34 +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 1goU34-0006Q8-1J for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 14:07:34 +0000 Received: from sonic306-3.consmr.mail.bf2.yahoo.com ([74.6.132.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goU31-00044Z-4W for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 14:07:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548770849; bh=wCGXmPfY9ediysmXdOvMLcNHnVWiYIN2jzYUN8EDvws=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=SUI/NCDiIY2+5MDl1YfNm4W+CrBXc6g+2x3WJp0lC2MRLCs5JiWgF0KTXitmVcLabb/EN2x2AaCd8rb/qzwraFNeUgH0pJvZRV3n3jpUmUrJH+NsUGSzCLoH6/t0pk6JYbkGlNnEpa29z5QOLi3szJ6XBMgwjvwF4FXXk0Bw6TUkN85C5kbUi4qDWDpwSAF5F8kGVn2uauXuJBy2Bg0lZq0OcagOAqFDsNBbJONWN9YOHqRTaCCcHgRUqV2hLtE2m0Y3do1FoYKY6XhODFsixcoHe2eCe58jKQiCD3ptYP4hL8c2KKIlcp+HN1frA29iAN3UFD6I5fPziNqJ6nmnig== X-YMail-OSG: r_.0HjQVM1nbMVCWXgh_VMMCle28e0GuP1KstFto3hBNqyKlwSkH1nOmMGiv3NI 6J_TyjLunPqMnl4dkUCCsPxoBb6C7ow.9ToWqX1xORMC8WkbcqOeMk6l4.jnBu7k9ny77SXUDSWr ztZojfTUKvisqgVZqEqofcZNVHM8uS2z.Kv_q1GDRY_.K0bADLaqDrSmWmPSNvZ1xxaneYILK1Ru Tw5.o1zDTjLTEAvLgjoVPQ9kGE0m.qGSa4DIRjM8e1ojyjE1IrE7Z8Grzvl2dEjPnu152kyWWeQa npGEOp_xIpcYMeVST6OuL0gEZPOJGRKY9tWb7q.wKv0qsH8dGzvGU0RSBmQtG5G.codL3bGZFWKp y0_fp7OFZlEKZYyCiMMntQwgroFlzeRglc_.ztJOD7JdOxZLy0ilYnE.1pLZ7p.JF0VgEa1MT4uk _8.CpwpD5hxjjPEFiJ3QALRl55ds3XXxhoJTqVTWX.2ag8gsNulmv62vc4Jr_yMaviq58C5H0hw1 _HZyPgaYoBg.1RBo5I05RZBIQ6fIJV1OXRI0YvB1hahforDB9hyTvTC5hvQl3_28hrdHsRDwAXLh 5qe1.MP1LIs3bOnbQAv7U3X5Odc_AdCiOnptTQtftj9eZQ9LrClmmk.LLl7zfp.mPMvXzd0MVuwZ z0moxrZpzgskHL9q2FdjmYNcvwl06kplPZMocDYaCTzcl.8TIuFyWHTjK76PB5rxz27lWC_I9ljk EV5ATSIc22QRmvC26hUXt3FNJ.JnDkSVUmJnebjbJq1aNC_keofzxVdwyvNvqF1iKsyhujXEktng wIqe55qAobrF7l58Opfia4j15.PbZBoW8DMuWxm62Az8aMrO7SkHQDCA_HL5_UoM._cLbca7DeV7 r1ysEMOV0EiSR8Quwm5CMpGzudzTJGteGciL2hAMIeYroSgnz7ppSPgov_Y6mPbC5A.n.kdHgy4i dj9YZTrZ8p32uIipzWUO3CEQ6VGqQ_ta.GFkBX98Zp1Hhzpb7VJ4tIzhI2yJmpmeK9JhXyyWnA90 VOhkhDvgNE5onjQzvxrR9f0D_qosbU6vRfAx3mN2cDZW_XI9XZ5atro.9tA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.bf2.yahoo.com with HTTP; Tue, 29 Jan 2019 14:07:29 +0000 Date: Tue, 29 Jan 2019 14:07:26 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <583336373.3022264.1548770846372@mail.yahoo.com> Subject: import tablespaces from oracle to postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3022263_129937763.1548770846370" References: <583336373.3022264.1548770846372.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: 12585 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3022263_129937763.1548770846370 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi experts, I am using Ora2pg to export cidr in oracle to postgres.=C2=A0 When the expo= rt Tablespace.sql is done, I import into the Postgres, Cidr.=C2=A0 I get ER= ROR below $psql -U posgres -d CIDR < TABLESPACE_cidrdba.sql SET CREATE TABLESPACE ERROR: directory"/opt/postgres11/data/cidr/PG_11_201809051" already in use = as a tablespace. even trying to create tablespace manually still said it's already in use, b= ut PG_11_20109051 is belong to cidr_data tablespace, how can I create new t= ablespaces for cidr postgres db? $psql -U posgres -d CIDR=C2=A0$psql> create tablespace cidr_lg location 'op= t/postgres11/data/cidr'; SET CREATE TABLESPACE ERROR: directory"/opt/postgres11/data/cidr/PG_11_201809051" already in use = as a tablespace. $psql> create tablespace cidr_dg location 'opt/postgres11/data/cidr';SET CREATE TABLESPACE ERROR: directory"/opt/postgres11/data/cidr/PG_11_201809051" already in use = as a tablespace. how can I create new tablespaces for cidr postgres db? v/r, Bach-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_3022263_129937763.1548770846370 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi experts,

I am using Ora2pg to export cidr in oracle to postgre= s.  When the export Tablespace.sql is done, I import into the Postgres= , Cidr.  I get ERROR below

$psql -U posgres -d CIDR < TABLESPACE_cidrdba.sq= l
SET
CREATE TABLESPACE
ERROR: directory"/opt/postgres11/data/ci= dr/PG_11_201809051" already in use as a tablespace.

even trying to create table= space manually still said it's already in use, but PG_11_20109051 is belong= to cidr_data tablespace, how can I create new tablespaces for cidr postgre= s db?

<= /div>
$psql -U posgres -= d CIDR 
$psql> create tablespace cidr_lg location 'opt/postgres11/data/cidr';<= /span>
SET
CREATE TABLESPACE
ERROR: directory"/opt/postgre= s11/data/cidr/PG_11_201809051" already in use as a tablespace.
=

<= span style=3D"color: rgb(36, 41, 46); font-family: -apple-system, BlinkMacS= ystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple = Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol";= font-size: 14px;" id=3D"yui_3_16_0_ym19_1_1548767629811_71484">$psql> c= reate tablespace cidr_dg location 'opt/postgres11/data/cidr';SET
CR= EATE TABLESPACE
ERROR: directory"/opt/postgres11/data/cidr/PG_11_20= 1809051" already in use as a tablespace.

how can I create new tablespaces f= or cidr postgres db?
v/r,

Bach-Nga

No one in this world is pure and perfec= t.  If you avoid people for their mistakes you will be alone. So judge= less, love and forgive more.
To call him a dog ha= rdly 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 k= new him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Ca= re deeply **Speak kindly.
*** Genuinely rich *** Faithful ta= lent *** Sharing success
------=_Part_3022263_129937763.1548770846370--