OBLOADER & OBDUMPER 3.1.0 released in April 2022 allows you to use key files, set session variables, and accurately delimit data files in the CUT, CSV, and SQL formats. When you export data, OBDUMPER supports the preprocessing of data in all formats and allows you to export table group information during the export of table definitions. When you export data of the DATE type, OBDUMPER allows you to export the to_date() function in the SQL format. This version also improves the pagination query performance during the export of tables that have a primary key.
New features
| Feature |
Description |
| OBLOADER and OBDUMPER |
When you import or export data, you can use a key file instead of specifying the password of the SYS tenant on the command line. For more information, see Scenarios and examples. Accurate delimitation is supported for data files in the following formats: CUT, CSV, SQL. |
| OBLOADER |
The control file supports more preprocessing functions. For more information, see Define control files for OBLOADER. The large file splitting logic is optimized to improve the accuracy of splitting. |
| OBDUMPER |
The following session variables can be set: ob_query_timeout, ob_trx_timeout, net_read_timeout, net_write_timeout, and proxy_route_policy. For more information, see Scenarios and examples. Data files of the following formats can be preprocessed: CUT, CSV, SQL. The performance of pagination queries is optimized for the export of tables that have a primary key. This way, the export is more stable compared with common and streaming queries. Table definitions can be exported with related information of table groups. The to_date() function can be exported during the export of data of the DATE type (only in the SQL format).
Example: INSERT INTO "TEST010" ("C3") VALUES (TO_DATE(char [, fmt [, 'nlsparam' ] ])); |
Fixed issues
- The issue is fixed where the --public-cloud option becomes invalid when OBLOADER imports data.
- The issue is fixed where an error for global index export occurs when OBDUMPER exports definitions.
