Transform=disable_archive_logging:Y Is Not Working When using Datapump Import on a Table with a BLOB Column (Doc ID 3027067.1)

Last updated on JUNE 11, 2024

Applies to:

Symptoms

On 19c version, the Data Pump Import transform=disable_archive_logging:Y parameter is not working when importing a table into the database.

On the source database, a datapump export of a table with large size BLOB column was taken and while importing this table into an Oracle Database 19C, a huge amount of redolog files are generated, exhausting the space on the mount point even while using "transform=disable_archive_logging:Y" in the datapump import command. The parameter is supposed to disable the redo log generation, but it doesn't work as expected. The redolog files generated are more than the size of the table being imported.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.