Home » SQL & PL/SQL » SQL & PL/SQL » Can we create new partitions in a partitioned table
icon5.gif  Can we create new partitions in a partitioned table [message #209400] Thu, 14 December 2006 10:44 Go to next message
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.
Re: Can we create new partitions in a partitioned table [message #209402 is a reply to message #209400] Thu, 14 December 2006 10:57 Go to previous message
dba_blr
Messages: 43
Registered: December 2006
Member
Yes it is possible...

Use the following...

Alter table <Table> add partition .....
Previous Topic: deleting char from a string
Next Topic: insert more that 32000 Character in a CLOB field
Goto Forum:
  


Current Time: Sun Dec 04 16:36:03 CST 2016

Total time taken to generate the page: 0.05545 seconds