Overview

OceanBase Developer Center (ODC) provides the database import and export features and the table import and export features, to facilitate database data maintenance for database developers. The database import and export features allow you to import data to or export data from selected tables in the database in batches. The table import and export features allow you to import data to or export data from the target table.

ODC provides a Task Center page. After you create an import or export task, this page displays the current import or export task. You can also view task details and logs on this page.

Notice

OceanBase Database of a version earlier than V2.2.30 supports only UTF8.

In ODC V2.2.1 and earlier versions, to use the import and export features, you must connect ODC to the target instance through OBProxy. If you directly connect ODC to the target instance, the import and export features are unavailable.

In ODC V2.4.1 and later, you can use the sys tenant account to accelerate the import and export tasks. To export objects other than tables and views, you must configure the sys tenant account.

This chapter describes the import/export features in different topics.

• Export and import formats

• Batch export and import

• Single table export and import