Home » Other » General » About Partition an already created table with mass data
About Partition an already created table with mass data [message #103742] Tue, 02 March 2004 18:17 Go to next message
Vaibhav Bansal
Messages: 1
Registered: March 2004
Junior Member
Dear freinds,
I have a very huge table with 5lacs records in it. For better performance i want to partition that table, but i am not getting the method to partion that. i am thinking to use ALTER TABLE ADD PARTITION command but then what will happen to my old data in it.

Or there is some partiucular synatx to partion an already created table. please freinds help me out in this problem.

Report message to a moderator

Re: About Partition an already created table with mass data [message #103751 is a reply to message #103742] Fri, 05 March 2004 01:54 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

You need to re-create the table as a partitioned table. If you cannot afford the downtime, you may consider using the DBMS_REDEFINITION package.

Best regards.

Frank

Report message to a moderator

Previous Topic: alter database create datafile
Next Topic: What does Oracle Finance mean?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 22:46:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.