Re: is the oracle client supposed to be owned by postgres or root?

From: Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net>
To: Henry Ashu <henry(dot)ashu(at)dat(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: is the oracle client supposed to be owned by postgres or root?
Date: 2024-09-13 04:45:16
Message-ID: CAHYHq4XdkH8aJ7vBbrpPjSzruWv1==4opfoC+UJ2VtmutXSRaQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Oracle Binaries and Oracle Database file should by own by oracle user and
oinstall group.

First you have to migrate objects from oracle to postgresql, In which you
can use ora2pg tool.and then migrate data.

On Thu, 12 Sept 2024 at 22:08, Henry Ashu <henry(dot)ashu(at)dat(dot)com> wrote:

> Please I want to migrate my Oracle database to Postgres, should the Oracle
> client be own by the postgres user or root user?
>
> Thank you
>
> *Henry Ashu*
>
> Database Administrator
> *o:* 503.672.5114 | *f:* 800.551.8821 | DAT.com
> [image: DAT Solutions] <https://www.dat.com/> [image: Like us on
> Facebook] <https://www.facebook.com/loadboards> [image: Follow us on
> Twitter] <https://twitter.com/loadboards> [image: Connect with us on
> LinkedIn] <https://www.linkedin.com/company/datsolutions> [image: Visit
> our YouTube Channel] <https://www.youtube.com/datloadboards> [image:
> Visit us on Instagram] <https://instagram.com/dat_solutions>
>

--
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email: *waqas(dot)m(at)bitnine(dot)net <waqas(dot)m(at)bitnine(dot)net>*
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Ikram 2024-09-13 05:51:00 Re: is the oracle client supposed to be owned by postgres or root?
Previous Message Ron Johnson 2024-09-13 02:41:37 Re: Query plan getting less efficient over time with frequent updates and deletes..