Yes, you are right. Thank you Brs Hans Vào Th 2, 28 thg 8, 2023 lúc 14:43 Luca Ferrari <[email protected]> đã viết:
> On Fri, Aug 25, 2023 at 5:49 PM duc hiep ha <[email protected]> > wrote: > > > > Hi, > > > > I've just found the root cause! In this command: > > ora2pg -c ora2pg.conf -t COPY -a tablename > > I have created and changed the name of table in postgres. It will not > work like that if i don't put replace_table option in config file. > > Out of curiosity: you renamed a table in PostgreSQL after the schema > was migrated, therefore you need something like > REPLACE_TABLES old_name:new_name > in ora2pg, right? > That explains also why offline mode seemed to work: ora2pg was dumping > with the original name without asking itself if the table was there in > PostgreSQL. > > Luca >
