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!

Month wise Range partition on column with data type varchar2

mohsin javedSep 1 2016 — edited Oct 7 2016

Hi,

I am new to partitioning, and i got requirement to partition transaction table.

Data in this table is being added and updated on regular basis. However for date and time we have two columns INDATE VARCHAR2(8) and INTME VARCHAR2(10).

There is one more column INDATETIME TIMESTAMP(6), but this column is used for different purpose and not being populated for every records.

Now when i convert my non partition transaction table to partition using DBMS_REDEFINATION partition gets created but when i check all my data goes into 1 partition called as FUTURE and only 1 record goes into one partition called PAST.

I am looking for steps in which i can partition my transaction table two columns INDATE VARCHAR2(8) and INTME VARCHAR2(10) and data also gets populated to its related partition.

Thanks

Mohsin

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2016

Added on Sep 1 2016

#general-database-discussions

9 comments

2,118 views