What's New

OBDUMPER 3.3.0 and OBLOADER 3.3.0 released in September 2022 can distinguish private cloud environments and public cloud environments in scenarios without sys tenant passwords in limited mode, and support the following features: data import and export by using OceanBase Database Proxy (ODP) (Sharding), configuration of session-level JDBC connection variables, matching file names with regular expressions for single table import, and setting custom invisible characters as line breaks. During the import of CUT files, OBLOADER 3.3.0 also supports custom line breaks, ignoring escape characters, and skipping the first and last lines of data.

New features

Fixed issues

• The Length value of the preprocessing function in the control file is inconsistent with the Length value in MySQL when OBLOADER imports data to or OBDUMPER exports data from OceanBase Database in MySQL mode.

• The specified --flashback-scn/--flashback-timestamp/--snapshot option is invalid for empty tables when OBDUMPER exports data.

• OBDUMPER reports an error when it exports the FLOAT data type from OceanBase Database in Oracle mode.

• The precision of floating-point numbers is lost when OBDUMPER exports the FLOAT data type from OceanBase Database in Oracle mode.

• When the -exclude-data-type/--exclude-column-names option is specified for the export of a file in the --ddl format by using OBDUMPER, the file cannot be exported. During the export of only schemas, the -exclude-data-type/--exclude-column-names option takes effect only when the table contains the same data type.

• The SEQUENCE/CONSTANT control function does not take effect when OBDUMPER exports data.

• The control file does not take effect when the keyword, such as SEQUENCE/CONSTANT, defined for the control file is used as the column name.

• The error record incorrect string value is not recorded in the ob-loader-dumper.bad file when OBLOADER imports data.

• When the number of columns recorded in a data file is greater than the number of columns in the real schema, OBLOADER cannot import the entire file.

• The annotation -- cannot be correctly identified when OBLOADER imports files in the --mix/--ddl format.