Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Split hash partition.

ricardo.tomasApr 8 2013 — edited Apr 8 2013

I have a prodution system with a table that was created with the following configuration:

CREATE TABLE CUSTOMER
(
  CUSTOMER_ID                  NUMBER(18),
  DEFAULT_LANGUAGE_ID          NUMBER(18),
  COMPANY_ID                   NUMBER(18),
  CUSTOMER_NAME                VARCHAR2(100 BYTE),

)
TABLESPACE CUSTOMER_DATA
PARTITION BY HASH (CUSTOMER_ID)
(  
  PARTITION CUSTOMER_TAB_P01
    TABLESPACE CUSTOMER_DATA
)
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING
/

The table was wrongly created with just one partition, now I need to split it from 1 to 10 partitions.
I cannot find how to split a Hash partition, only range partitions.

How can I split it without using a CTAS and replace the table with the new one, as the split partition statment for range partitions?

Thanks for the help.

Best regards,
Ricardo Tomás

This post has been answered by unknown-7404 on Apr 8 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2013

Added on Apr 8 2013

#general-database-discussions

2 comments

479 views