OraFAQ Forum: SQL & PL/SQL » Can we create new partitions in a partitioned table

Home » SQL & PL/SQL » SQL & PL/SQL » Can we create new partitions in a partitioned table

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

Can we create new partitions in a partitioned table [message #209400]

Thu, 14 December 2006 10:44

prasanna_anbu
Messages: 34
Registered: November 2006
Location: india

Member

I have a partitioned table which has 24 partitions based on months, if a new month data comes then i want to create one more partition in the same table is it possible ,the table already contains 24 months data in it.

Report message to a moderator

Re: Can we create new partitions in a partitioned table [message #209402 is a reply to message #209400]

Thu, 14 December 2006 10:57

dba_blr
Messages: 43
Registered: December 2006

Member

Yes it is possible...

Use the following...

Alter table <Table> add partition .....

Report message to a moderator

Previous Topic:	deleting char from a string
Next Topic:	insert more that 32000 Character in a CLOB field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 01:40:51 CST 2025