在oracle标准版中使用什么功能，例如在oracle企业版中进行分区 [英] what feature to use in oracle standard edition like that of partitioning in oracle enterprise edition

问题描述

我只能访问oracle标准版，oracle标准版的该功能提供了类似于分区的功能，在逻辑上像MYSQL中那样合并表的任何概念.

I only have access to oracle standard edition, which feature of oracle standard edition provides the functionality like that of partitioning is there any concept of logically merging table like that in MYSQL.

推荐答案

唯一想到的是为每个分区"创建一个真实的表，然后通过一个视图将它们结合在一起.但是，每次添加或删除分区"时，您都必须重建视图，并且可能存在性能问题，以及除了selects之外的任何内容的潜在复杂性-您可以通过执行插入/更新/过程来解决此问题.在相关基础表上删除.可能不是很容易创建或维护，也不是很健壮.甲骨文对此收取额外费用是有原因的.

Only thing that comes to mind is to have a real table for each 'partition', and then a view than unions them all together. But you'd have to rebuild the view every time you added or removed a 'partition', and there might be performance issues, as well as potential complication with anything except selects - which you could get around with procedures to do insert/update/delete on the relevant underlying table. Probably wouldn't be very easy to create or maintain, or very robust. There's a reason Oracle charge extra for this.

这篇关于在oracle标准版中使用什么功能，例如在oracle企业版中进行分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！