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.
Background
ODC is an enterprise-level database development platform tailored for OceanBase Database and aims to help enterprises use databases securely and efficiently. You can use ODC to create and manage more than 10 types of database objects, such as tables and views. ODC provides the WebSQL-based SQL window and anonymous block window in which you can develop and diagnose SQL and PL/SQL statements. You can also allocate resources and relevant access permissions to roles. This makes development collaboration among different roles simple and controllable.
To use ODC to import and export data, you need to deploy the web version of ODC. For more information about ODC and the deployment process, see OceanBase Developer Center.
Export and import data by using ODC
The database import and export features of ODC allow you to import data to or export data from tables in the database in batches. The table import and export features allow you to import schemas and data to or export schemas and data from the target table.
ODC provides the Tasks page where you can manage tasks. 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
- Instances earlier than OceanBase Database V2.2.30 support 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 versions later than ODC V2.4.1, 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.