Help required for adding patition by range in table [message #669865] |
Mon, 21 May 2018 01:35 |
|
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
Hi,
Please help for adding partition by exchange to the table. I have executed following command but getting error:
alter table TEST_TAB add
PARTITION BY RANGE ("LOAD_TIMESTAMP")
PARTITION "P_18MAY2018" VALUES LESS THAN (TO_DATE(' 2018-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
Error report -
SQL Error: ORA-00902: invalid datatype
00902. 00000 - "invalid datatype"
*Cause:
*Action:
|
|
|
|
|
|
|