Partition Key Date Format
Hi All
We have table which is range partitioned on a Date field with the following date format
PARTITION "P200905" VALUES LESS THAN (TO_DATE(' 2008-08-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
But whenever the user is inserting the data he is using this to_date format
TO_DATE(?,'YYYY-MM-DD HH24:MI:SS')
Here while inserting the date he is not using the format which we used to create the partition I mean 'SYYYY-MM-DD HH24:MI:SS' this format instead the user is using 'YYYY-MM-DD HH24:MI:SS' is this will cause any error to insert data into the particular partitions ?
Particular error we are getting is the
Original thrown object message: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition