安装 Oracle 后如何启用分区选项 true？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20271031/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to enable partitioning option true after installing the Oracle?
提问by lucifer
I have installed oracle 10G XE but in the time of installation i may have not enabled the partion option.now when i am running the command
我已经安装了 oracle 10G XE 但在安装时我可能没有启用分区选项。现在当我运行命令时
select * from v$option where parameter = 'Partitioning'; its showing false ..
when i tried to run this script
当我尝试运行此脚本时
CREATE TABLE products
(partno NUMBER,
description VARCHAR2 (60))
PARTITION BY HASH (partno)
PARTITIONS 4
STORE IN (tab1, tab2, tab3, tab4);
it shows that
它表明
ORA-00439: feature not enabled: Partitioning
i have important tables there if i delete the database then i will have to face problem.
如果我删除数据库，我有重要的表，那么我将不得不面对问题。
can i enable portioning option after installing??or i have to re install the oracle??please help.
我可以在安装后启用分配选项吗？或者我必须重新安装 oracle？？请帮忙。
