Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-14176: this attribute may not be specified for a hash partition

672680Sep 23 2009 — edited Sep 23 2009
Why below code can`t be executed?
It is from <Expert one on one> by tom kyte and as I can see it works well in Tom`s example.
Am I missing anything? Please help! 
CREATE TABLE emp (empno int, ename varchar2(20))
PARTITION BY HASH(empno) 
(partition part_1 tablespace IMSDBA,
partition part_2 tablepsace GTMDBA
)/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2009
Added on Sep 23 2009
9 comments
1,285 views