Create partitioned and take export from normal table import into to partitioned tables,oracle will take care of placing rows in particular partitions based on the condition u given while creating partions.
Thanks and Regards
GowdA....
CTS - CSI
Vnet -- 42275
P & T -- 2275
"Our life is what our thoughts made it"
-----Original Message-----
From: Hartley, John [mailto:John.[Email Address Removed]
Sent: Thursday, August 28, 2003 11:50 PM
To: LazyDBA.com Discussion
Subject: Migrating a table to a partitioned table
> Guru's
>
> I have a 10m row table that I want to migrate to a partitioned table
> using a range partition.
>
> I know the syntax to create a new partitioned table, but how do I
> migrate the existing non-partitoned table to a new partitioned one?
> (i.e. insert with a select? Create table as select...?)
>
> I hope I'm not overthinking this.. Any help would be appreciated.
> Thanks
>
>
> John
****************************************************************
Please Note
The information in this E-mail message is legally privileged and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you
*****************************************************************
--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
Oracle LazyDBA home page