Oracle与oceanbase兼容性

从Oracle库上导出一张表的sql文件,导入oceanbase时报错

2023-06-26 21:21:59 [INFO] No Sys user setting, connectionId=5001327
2023-06-26 21:21:59 [INFO] Begin transferring data
2023-06-26 21:21:59 [INFO] Find 1 resources in local path: “/opt/odc/./data/data_transfer/1000760” success. Elapsed: 231.8 μs
2023-06-26 21:21:59 [INFO] Init writer thread pool finished
2023-06-26 21:21:59 [WARN] No statements are parsed from: “/opt/odc/./data/data_transfer/1000760/import_upload_1687785712973_50.sql”
2023-06-26 21:22:00 [INFO] Close connection count: 2 of the DataSource. Key: BIZ
2023-06-26 21:22:00 [INFO] shutdown task context finished
2023-06-26 21:22:00 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ----------
2023-06-26 21:22:00 [INFO]

All Load Tasks Finished:


    No.#        |        Type        |               Name               |            Count             |       Status       

     1          |        FILE        |import_upload_1687785712973_50.sql|              0               |      FAILURE       

Total Count: 0 End Time: 2023-06-26 21:22:00

2023-06-26 21:22:00 [WARN] Failed to execute data transfer task
java.lang.IllegalStateException: mysql.import_upload_1687785712973_50.sql: No statements are parsed from: “/opt/odc/./data/data_transfer/1000760/import_upload_1687785712973_50.sql”
at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.syncWaitFinished(BaseDataTransferTask.java:167) ~[classes!/:?]
at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.call(BaseDataTransferTask.java:128) ~[classes!/:?]
at com.oceanbase.odc.service.datatransfer.task.BaseDataTransferTask.call(BaseDataTransferTask.java:35) ~[classes!/:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_372]
at com.oceanbase.odc.common.trace.TraceDecorator.lambda$decorate$0(TraceDecorator.java:25) ~[odc-common-4.1.3-20230524.jar!/:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_372]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_372]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_372]

这是啥原因?

sql文件是什么格式?分割线的数据文件?这种应该用obloader导入。

如果是insert语句,那应该是可以用odc导入。

现在要分析,看能不能给个sql文件,表结构,odc版本,ob版本。

信息不全,分析不了