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.
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: 4579
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
Previous Topic: alter database create datafile
Next Topic: What does Oracle Finance mean?
Goto Forum:
  


Current Time: Fri Mar 29 03:32:54 CDT 2024