[root@ob1 ~]# obclient -h192.168.0.36 -P2883 -uadmin@zylong#obdemo -p1pglBKCX9cf=n+
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3018
Server version: OceanBase 3.2.4.3 (r103000032023041816-83ae8071b606cb563ddbb7658f530966f7b3b7b8) (Built Apr 18 2023 16:44:11)Copyright (c) 2000, 2018, OB Corporation Ab and others.Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
obclient [ADMIN]> drop table bmsql_warehouse;
Query OK, 0 rows affected (0.057 sec)
obclient [ADMIN]> create table bmsql_warehouse (
-> w_id integer not null,
-> w_ytd decimal(12,2),
-> w_tax decimal(4,4),
-> w_name varchar(10),
-> w_street_1 varchar(20),
-> w_street_2 varchar(20),
-> w_city varchar(20),
-> w_state char(2),
-> w_zip char(9)
-> );
Query OK, 0 rows affected (0.113 sec)
obclient [ADMIN]> alter table bmsql_warehouse add constraint bmsql_warehouse_pkey primary key (w_id);
ORA-00600: internal error code, arguments: -4007, Not supported feature or function
obclient [ADMIN]> drop table bmsql_warehouse;
Query OK, 0 rows affected (0.053 sec)
obclient [ADMIN]> CREATE TABLE bmsql_warehouse (
-> w_id integer not null,
-> w_ytd decimal(12,2),
-> w_tax decimal(4,4),
-> w_name varchar(10),
-> w_street_1 varchar(20),
-> w_street_2 varchar(20),
-> w_city varchar(20),
-> w_state char(2),
-> w_zip char(9),
-> PRIMARY KEY(w_id)
-> );
Query OK, 0 rows affected (0.121 sec)
obclient [ADMIN]>
想了解更多干货,可通过下方扫码关注

可扫码添加上智启元官方客服微信👇

17认证网








