Copy method via dblink in MTK generates WAL logging
I am using migation toolkit to migrate data from Oracle to EPAS using -fastcopy and -copyviadblinkora.
As per documentation, copyviadblinkora will use COPY API method and fastcopy will prevent wal logging to optimize migration.
When I am doing migration, there is a lot of WAL being generated.It took around 7 minutes for migration and during those 7 minutes 1200+ WALs were generated.
If WAL logging is disabled in fastcopy then why are so many WAL's generated?
/usr/edb/migrationtoolkit/bin/runMTK.sh -copyViaDBLinkOra -fastcopy -cpBatchSize 1024 -dataOnly -truncLoad -loaderCount 6 -allTables HR
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.