[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]>
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




