Sunday , September 24 2023

impdb disable_archive_logging usage

With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog mode. In this way, the risk of filling the archive log directory in large import operations will be eliminated and you will be able to process faster.

If the log_mode of the database is not force_logging, you can use this parameter. You can check the log_mode of a database as follows.

In the following example, the import operation of a table was performed using disable_archive_logging.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *