OraFAQ Forum: Server Administration » Changing Noninterval to Interval Partitions

Home » RDBMS Server » Server Administration » Changing Noninterval to Interval Partitions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing Noninterval to Interval Partitions [message #668546]

Wed, 28 February 2018 16:01

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

Report message to a moderator

Re: Changing Noninterval to Interval Partitions [message #668548 is a reply to message #668546]

Wed, 28 February 2018 23:20

Michel Cadot
Messages: 68418
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 03:09:53 CDT 2023