OraFAQ Forum: SQL & PL/SQL » move data from one partition to other in a table

Home » SQL & PL/SQL » SQL & PL/SQL » move data from one partition to other in a table (Oracle 9i, windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

move data from one partition to other in a table [message #467021]

Thu, 22 July 2010 01:05

srilaxmi
Messages: 16
Registered: June 2007
Location: hyderabad

Junior Member

Hi,

I want to move data from one partition to another partition in a same table.

Ex: Table A has Partitions P1 and P2. I want to move data from P1 to P2.

Is this is possible?Please give me the syntax.

TIA,
Sri

Report message to a moderator

Re: move data from one partition to other in a table [message #467023 is a reply to message #467021]

Thu, 22 July 2010 01:10

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

No you can not. as Davide the data by Range/Hash/ or list is the basic purpose of partitions

Unless you want to SPLIT the P1 Partition with desire range OR You update the data in P1 with sutaible value which qulify for P1
( Please make sure you have row movement clause ENABLE )

Please check
Managing Partitioned Tables and Indexes

[Updated on: Thu, 22 July 2010 01:19]

Report message to a moderator

Re: move data from one partition to other in a table [message #467026 is a reply to message #467021]

Thu, 22 July 2010 01:17

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Rows are in the partition appropriate to their field values, so for one row there is only ONE appropriate partition.
You do not decide in which partition you want to put a row, the decision is made when you define the partitioning rules itself (RANGE values, LIST values...).

Regards
Michel

Report message to a moderator

Re: move data from one partition to other in a table [message #467028 is a reply to message #467023]

Thu, 22 July 2010 01:18

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Rows will be moved automatically if an update to the partitioning key column makes this necessary, but you must ALTER TABLE ENABLE MOVEMENT or the update will fail with an ORA-14402

Report message to a moderator

Previous Topic:	Has anyone here ever used Noetix web query?
Next Topic:	SQL Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 12 22:14:01 CDT 2025