This seems to be a good idea. I will see if this is acceptable to my people.
Earliar I suggested to change to date field, and was not acceptable for them
as there seems plenty of code needs to be changed. I will see if this change
is acceptable for them.
One thing I could understand clearly from
Dear List,
I have a table of size approx 10gig, and I need to partition based on the
YEAR. I have column in the table, REPORT_CYCLE_CD with VARCHAR2(7). The
data in the column of format MON . I need to partition the table based
on the year , that is, substr(report_cycle_cd, 4,4).
Babu
I don't think partitions are clearly documented anywhere. Here is some SQL
that works so you can see how to use a date function. It partitions on two
columns, but I wanted you to see something that works.
add partition sum_fy_28
values less than ('FY',
No, I think you will have to add a column to store '' separately in
order to partition on it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:14 PM
Dear List,
I have a table
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original Message-
Sent: Thursday, March 13, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
??
Dear List,
I have a table of size approx 10gig, and I need to partition
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original
No
-Original Message-
Sent: Thursday, March 13, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
???
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy
Babu,
On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'),
PARTITION P1999