Home » SQL & PL/SQL » SQL & PL/SQL » Add a new hash partition to existing table
Add a new hash partition to existing table [message #408398] Tue, 16 June 2009 02:13 Go to next message
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
Junior Member
Hi,


I need to add a new hash partition to existing table.

Table contains 20 lakhs records.


CREATE TABLE hash_part
(
  Id        CHAR(16 BYTE)                     NOT NULL,
  NAME      VARCHAR2(4 BYTE)                  NOT NULL
 )


How can i add the hash partition?


BR
Rajabaskar
Re: Add a new hash partition to existing table [message #408407 is a reply to message #408398] Tue, 16 June 2009 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Your table is not partitioned, so you can't add a new partition.
You have to create a new partitioned table or use dbms_redefinition.

Regards
Michel
Re: Add a new hash partition to existing table [message #408413 is a reply to message #408407] Tue, 16 June 2009 02:49 Go to previous message
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
Junior Member
Thanks Michel.

BR
Rajabaskar
Previous Topic: jobs question
Next Topic: copying data to a table (merged 6)
Goto Forum:
  


Current Time: Mon Feb 17 19:08:30 CST 2025