Is there any practical limit on the number of schemas in a database? Will the number of schemas in a user's search path impact performance?
Thanks Dave Roth > On 03/20/2023 10:15 AM Ron Johnson <ronljohnso...@gmail.com> wrote: > > > Real-time CDC is the difficult part. ora2pg (using views) can do a > static migration. No coding (unless you consider clever use of bash to > modify config files to be coding). I used it to migrate a 7TB db to > Postgresql. > > https://ora2pg.darold.net/ > > On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq > <inzamam.sha...@hotmail.com mailto:inzamam.sha...@hotmail.com > wrote: > > > > Hi, > > > > Hope everyone is fine. > > > > Can someone help or guide regarding Open Source tools for Oracle to > > PostgreSQL migration with real time CDC. along with this is there any > > possibility to change the structure of the database? Let me explain a > > little more, > > > > We have an Oracle DB which is around 1TB and we want to migrate to > > PostgreSQL that have a new table structure, so we want to perform data > > transformation and real time CDC from Oracle to PostgreSQL. Do we have any > > good open source tool to achieve this with No Coding involved.?? > > > > Thanks. > > > > Regards, > > > > Inzamam Shafiq > > Sr. DBA > > > > > > >