旁路导入时 secure_file_priv 租户变量的设置方法

[root@observer ~]# obclient -hxxx.xxx.xxx.xxx -P2883 -uSYS@oboracle#kylin_kvm_cluster1 -p
Enter password:
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 2361312
Server version: OceanBase 3.2.4.8 (r108030012024102211-a93c91b0a83a081a9e5c3ab96250517f17483b5c) (Built Oct 22 2024 11:35:15)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient(SYS@oboracle)[SYS]>
obclient(SYS@oboracle)[SYS]> set global secure_file_priv = "/";
ORA-00600: internal error code, arguments: -4007, Not supported feature or function
obclient(SYS@oboracle)[SYS]>
obclient(SYS@oboracle)[SYS]> set global secure_file_priv = '';
ORA-00600: internal error code, arguments: -4007, Not supported feature or function

[root@observer ~]# obclient -hxxx.xxx.xxx.xxx -P2881 -uSYS@oboracle -p
Enter password:
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221623480
Server version: OceanBase 3.2.4.8 (r108030012024102211-a93c91b0a83a081a9e5c3ab96250517f17483b5c) (Built Oct 22 2024 11:35:15)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(SYS@oboracle)[SYS]> set global secure_file_priv = '';
ORA-00600: internal error code, arguments: -4007, Not supported feature or function
obclient(SYS@oboracle)[SYS]> set global secure_file_priv = "/";
ORA-00600: internal error code, arguments: -4007, Not supported feature or function

[root@observer ~]# obclient -S /home/admin/oceanbase/run/sql.sock -uxxxx@xxx -pxxxxxx
[root@observer ~]# obclient -S /home/admin/oceanbase/run/sql.sock -usys@oboracle -p
Enter password:
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221742871
Server version: OceanBase 4.2.1.9 (r109000092024091919-9e4708744c35a06376fd4289b995cf1ae70698d7) (Built Sep 19 2024 19:55:12)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(SYS@oboracle)[SYS]> set global secure_file_priv = '';
Query OK, 0 rows affected (0.079 sec)

obclient(SYS@oboracle)[SYS]> set global secure_file_priv = "/";
Query OK, 0 rows affected (0.092 sec)