Postgres Pro
Downloads
Home   >   mailing lists

Re: is the oracle client supposed to be owned by postgres or root? - Mailing list pgsql-admin

From Muhammad Waqas
Subject Re: is the oracle client supposed to be owned by postgres or root?
Date
Msg-id CAHYHq4XdkH8aJ7vBbrpPjSzruWv1==4opfoC+UJ2VtmutXSRaQ@mail.gmail.com
Whole thread Raw
In response to is the oracle client supposed to be owned by postgres or root?  (Henry Ashu <henry.ashu@dat.com>)
Responses Re: is the oracle client supposed to be owned by postgres or root?
List pgsql-admin
Tree view
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.ashu@dat.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

DAT Solutions    Like us on Facebook  Follow us on Twitter  Connect with us on LinkedIn  Visit our YouTube Channel  Visit us on Instagram


--
Muhammad Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
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.

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Query plan getting less efficient over time with frequent updates and deletes..
Next
From: Muhammad Ikram
Date:
Subject: Re: is the oracle client supposed to be owned by postgres or root?