Why use a number to represent a date? There is no advantage
whatsoever, and numerous disadvantages. ...and as Gus pointed out, range partitioning syntax is "VALUES LESS THAN" not "VALUES LESS THAN OR EQUAL TO"... Gus Spier wrote: Of course, it's up to you, but if you set NLS_DATE_FORMAT='YYYYMMDD', you won't need the TXN_DATE_ID. I might also recommend that your partition by range (TXN_DATE_ID) use values less than 20070201 instead of 20070131.-- //www.freelists.org/webpage/oracle-l |