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

[Muhammad Waqas <waqas.m@xxxxxxxxxxx>]

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@xxxxxxx> 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

            

--

Muhammad Waqas

Senior Technical Support Engineer - Tech Support Center (Karachi)

Mobile: +92-322-2844150

Email:  waqas.m@xxxxxxxxxxx 

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.