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!

Splitting List partition

user3240461Jan 1 2014 — edited Jan 2 2014

Hi all,

We are using oracle database (10.2.0.4 64bit) and OS AIX (6.1).

We have list partition table. On column sale two values (1 or 0) are stored.

Table has two partition DAILY_ISSUANCE_SALE_FACT_1 for value (1) and DAILY_ISSUANCE_SALE_FACT_0 for value (0).

Due to huge size of table, we want to split partition DAILY_ISSUANCE_SALE_FACT_1 and DAILY_ISSUANCE_SALE_FACT_0.

How I can splite these two partitions with values 1 and 0?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2014

Added on Jan 1 2014

#general-database-discussions

6 comments

322 views