无法初始化点云 - ORA-13249:创建 dml 触发器时出错 [英] Unable to initialize point cloud - ORA-13249: Error creating dml trigger
本文介绍了无法初始化点云 - ORA-13249:创建 dml 触发器时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我无法在 Oracle Database 12c 中初始化点云.
I'm unable to initialize point cloud in Oracle Database 12c.
尝试执行以下命令:
CREATE TABLE point_clouds(
id NUMBER,
capture_ts TIMESTAMP,
point_cloud SDO_PC
);
CREATE TABLE pc_blocks AS select * from mdsys.sdo_pc_blk_table;
INSERT INTO point_clouds (id, point_cloud) VALUES (
1001,
sdo_pc_pkg.init(
basetable => 'point_clouds',
basecol => 'point_cloud',
blktable => 'pc_blocks',
ptn_params => 'blk_capacity=10000',
pc_extent => mdsys.sdo_geometry(
2003,
8307,
null,
mdsys.sdo_elem_info_array(1, 1003, 3),
mdsys.sdo_ordinate_array(289020.90, 4320942.61, 290106.02, 4323641.57)
),
pc_tol => 0.05,
pc_tot_dimensions => 3
)
);
但是,在插入时出现此错误:
However, got this error on INSERT:
Error report:
SQL Error: ORA-13249: Error creating dml trigger
ORA-06512: at "MDSYS.SDO_PC_PKG", line 96
ORA-06512: at line 1
13249. 00000 - "%s"
*Cause: An internal error was encountered in the extensible spatial index
component. The text of the message is obtained from some
other server component.
*Action: Contact Oracle Support Services with the exact error text.
那个 INSERT 语句有什么问题?
What is wrong with that INSERT statement?
推荐答案
我被这个问题困扰了很久,最终通过使用 MDSYS.sdo_pc 而不是 sdo_pc 创建 point_clouds 表解决了这个问题.
I was stuck on this for ages, and finally solved it by creating the point_clouds table using MDSYS.sdo_pc instead of sdo_pc.
CREATE TABLE point_clouds(
id NUMBER,
capture_ts TIMESTAMP,
point_cloud MDSYS.SDO_PC
);
这篇关于无法初始化点云 - ORA-13249:创建 dml 触发器时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文