Help required for adding patition by range in table [message #669865] |
Mon, 21 May 2018 01:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b69a15eb1f3eaa0ea6558f32108cf3af?s=64&d=mm&r=g) |
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:
|
|
|
|
|
|
|