Before you run OBLOADER & OBDUMPER, make sure that you have the appropriate operating environment and privileges.
Operating environment configurations
| Configuration item | Requirements |
|---|---|
| OS | Linux, macOS, and Windows 7 or later |
| Java environment | Install Oracle JDK 1.8, and configure the JAVA_HOME environment variable. We do not recommend that you use OpenJDK. |
| Character set | We recommend that you use UTF-8 as the file character set. |
| Java virtual machine (JVM) parameters | Modify the JVM memory parameter in the bin/obloader and bin/obloader script to avoid JVM memory insufficiency. |
Privileges
When you connect OBLOADER & OBDUMPER to OceanBase Database and use this tool to import data, you must have the following privileges:
The user account that you use to connect to OceanBase Database must have the privileges to execute the
SELECT,INSERT,MERGE, andUPDATEstatements.In non-limited mode, the
--sys-userand--sys-passwordoptions must be specified for OBLOADER & OBDUMPER.Notice
The--sys-userand--sys-passwordoptions must be set to the username and password of a user with system table and view query privileges under the SYS tenant.