暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

OceanBase 3.2.4 Oracle模式的租户不支持建表后添加主键约束

原创 张玉龙 2023-05-18
1129
[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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文章被以下合辑收录

评论