Please don't hijack threads. https://www.postgresql.org/docs/13/limits.html No mention of schemas.
On Mon, Mar 20, 2023 at 12:08 PM DAVID ROTH <adapt...@comcast.net> wrote: > 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> > 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* > >
