Home » RDBMS Server » Server Administration » Changing Noninterval to Interval Partitions
Changing Noninterval to Interval Partitions [message #668546] Wed, 28 February 2018 16:01 Go to next message
scottwmackey
Messages: 515
Registered: March 2005
Senior Member
Is there anyway to change an existing partition to an interval partition, i.e. the "NO" values below to "YES"?
SQL> SELECT partition_name, high_value, INTERVAL FROM user_tab_partitions WHERE table_name = 'SWM_TEST';

PARTITION_NAME HIGH_VALUE INTERVAL
-------------- ---------- --------
P_0            100        NO
P_999          1000       NO
SYS_P3168265   1002       YES
Re: Changing Noninterval to Interval Partitions [message #668548 is a reply to message #668546] Wed, 28 February 2018 23:20 Go to previous message
Michel Cadot
Messages: 65982
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For such question, the Oracle version is mandatory to have an accurate answer as features are not the same ones in each version, aren't they?

As per the documentation this column indicates:

Quote:
Indicates whether the partition is in the interval section of an interval partitioned table (YES) or whether the partition is in the range section (NO)

So, the answer is NO.

Previous Topic: ORA-16038, ORA-00312, ORA-16014
Next Topic: DBMS_RLS.ADD_POLICY
Goto Forum:
  


Current Time: Tue Nov 20 20:37:12 CST 2018