Database-logging mode

Because the logging mode is not retained in the schema file, you can specify logging information when you use the dbimport utility to import a database.

You can specify any of the following logging options when you use dbimport:
  • ANSI-compliant database with unbuffered logging
  • Unbuffered logging
  • Buffered logging
  • No logging

For more information, see dbimport create options.

The -l options are equivalent to the logging clauses of the CREATE DATABASE statement, as follows:
  • Omitting any of the -l options is equivalent to omitting the WITH LOG clause.
  • The -l option is equivalent to the WITH LOG clause.
  • The -l buffered option is equivalent to the WITH BUFFERED LOG.
  • The -l -ansi option is equivalent to the WITH LOG MODE ANSI clause, and implies unbuffered logging.

Copyright© 2018 HCL Technologies Limited