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)

Report message to a moderator

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: 68686
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 21:51:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.