You can't partition existing table.
1.rename the table
2.You have to create a new table with partitioning option and create all
the constraints , indexes etc.
3. and transfer the data





"j" <oracledba-ezmlmshield-x91521124.[Email address protected]
06/29/2005 05:16 PM


To

"LazyDBA Discussion" <[Email address protected]
cc





Subject
PARTITIONING A EXISTING TABLE







Dear All,

Is it possible to do a table partition on an existing table containing 50
lacs records. If yes, how can we do so.

Thanks and regards,
Jay

Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message and
any attachments. Thank you


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page