1、OBLOADER 与 OBDUMPER 企业版本4.2.4使用如下语句导出ddl
./obdumper -h* -P2883 -u***@# -p*** --sys-user root --sys-password **** -D ABC_TEST–ddl --all --retry=true -f /root/output/abc_test_ddl**
出行了如下的异常：
2024-04-21 23:51:20 [INFO] Load jdbc driver class: “com.oceanbase.jdbc.Driver” finished
2024-04-21 23:51:21 [INFO] Found 4 empty tables before executing… Elapsed: 28.80 ms
2024-04-21 23:51:21 [WARN] No VIEW are exist in the schema: “ABC_TEST”
2024-04-21 23:51:21 [ERROR] Dump failed! Error: unknown escape sequence {1}
2024-04-21 23:51:21 [ERROR] System exit 1
2、根据提示以为是sequence 问题，使用下面语句直接导出sequence，是可以正常导出的./obdumper -h* -P2883 -u***@# -p*** --sys-user root --sys-password **** -D ABC_TEST–ddl --sequence=* -f /root/output/abc_test_ddl/sequence**
3、由于该库没有视图语句，使用下面的语句导出视图
./obdumper -h* -P2883 -u***@# -p*** --sys-user root --sys-password **** -D ABC_TEST–ddl ----view=* -f /root/output/abc_test_ddl/view**
结果是报错
2024-04-21 23:47:07 [INFO] Load jdbc driver class: “com.oceanbase.jdbc.Driver” finished
2024-04-21 23:47:07 [WARN] No VIEW are exist in the schema: “ABC_TEST”
2024-04-21 23:47:07 [ERROR] Dump failed! Error: No dump tasks are generated for schema: “ABC_TEST”
2024-04-21 23:47:07 [ERROR] System exit 1