Home » RDBMS Server » Server Administration » How to add a new partition to an existing partition
How to add a new partition to an existing partition [message #249002] Tue, 03 July 2007 01:21 Go to next message
manoj_vilayil
Messages: 9
Registered: May 2007
Location: India
Junior Member
Sir
I have some tables already partitioned(hash).I want to add some new partition(s) to it.Is it possible.Plz reply with example


CREATE TABLE temp(
ID NUMBER,
YEAR NUMBER)
PARTITION BY HASH(YEAR)
PARTITIONS 1
STORE IN (SYSTEM)
Re: How to add a new partition to an existing partition [message #249011 is a reply to message #249002] Tue, 03 July 2007 01:33 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL Reference, ALTER TABLE page, add_table_partition clause, add_hash_partition_clause part.

Less than 15 seconds to find it.

Regards
Michel
Previous Topic: Creating an index on a table with data
Next Topic: **FIXED** ORA-12514 When Setting up a Servive Name using Net Configuration Assistant
Goto Forum:
  


Current Time: Sat Dec 10 08:51:02 CST 2016

Total time taken to generate the page: 0.16890 seconds