Re: import tablespaces from oracle to postgres

Yes. you can create one tablespace in one directory location and if you
create a database with default_tablespaces with cidr_dba, cidr_lg, cidr_dg,
etc you need to a create directory for each thses tablespaces respectively.

Also, you can't a create multi-tablespaces in one database. However, you
can create multi-tablespaces in one cluster.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Tue, Jan 29, 2019 at 8:14 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

> Yes, sir/mam'm,
>
> I manually created those extra tablespaces and still get error above.
> Seems to me one tablespace for each directory? I can't have multiple
> tablespaces under /opt/postgres11/data/cidr right? currently the cidr
> datbase default tablespace is cidr_data. How can I create database with
> default_tablespaces with cidr_dba, cidr_lg, cidr_dg, etc...? can a
> database has multi-tablespaces?
>
> 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 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)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
> On Tuesday, January 29, 2019 9:37 AM, Shreeyansh Dba <
> shreeyansh2014(at)gmail(dot)com> wrote:
>
>
> Hi Pepe,
>
> Yes, you can create the tablespaces manually just by changing your
> tablespace name along with the location.
>
> Also, you can use the existing tablespace at the time of importing into
> the Postgres.
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Tue, Jan 29, 2019 at 7:37 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
> Hi experts,
>
> I am using Ora2pg to export cidr in oracle to postgres. When the export
> Tablespace.sql is done, I import into the Postgres, Cidr. I get ERROR 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,
> but PG_11_20109051 is belong to cidr_data tablespace, how can I create new
> tablespaces for cidr postgres db?
>
>
> $psql -U posgres -d CIDR
> $psql> create tablespace cidr_lg location 'opt/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. 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 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)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
>
>