Home » SQL & PL/SQL » SQL & PL/SQL » How to add multiple partitions to a table
How to add multiple partitions to a table [message #298592] Wed, 06 February 2008 11:29 Go to next message
atl2008
Messages: 2
Registered: February 2008
Junior Member
I need to add several partitions to an oracle table. Do I have to use "ALTER TABLE ADD PARTITION" for each one or is there an alternative way to do it?

[Updated on: Wed, 06 February 2008 11:31]

Report message to a moderator

Re: How to add multiple partitions to a table [message #298593 is a reply to message #298592] Wed, 06 February 2008 11:46 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you have to.

Regards
Michel
Previous Topic: Procedure Call
Next Topic: How to create partition on an existing table with range on a timestamp
Goto Forum:
  


Current Time: Wed Dec 07 20:11:26 CST 2016

Total time taken to generate the page: 0.17720 seconds