Home » SQL & PL/SQL » SQL & PL/SQL » Table pratitioning
Table pratitioning [message #189559] Fri, 25 August 2006 01:52 Go to next message
Messages: 10
Registered: August 2005
Location: india
Junior Member
can any one help me on creating table partition on exsiting table which have data in it

alter table fact_prodect add pratition by range (pradect_101_id)
partition value (1023),
partition value (1234))

syntax might me wrong but for your clearens i had mentioned the statement. Please help me out thank you
Re: Table pratitioning [message #189569 is a reply to message #189559] Fri, 25 August 2006 02:38 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
You really need to post details about your table and how you want to partition it (range or list partitioning). Furthermore, Oracle has a nice documentation set with syntax examples. Have you checked there?

Re: Table pratitioning [message #189602 is a reply to message #189569] Fri, 25 August 2006 03:55 Go to previous message
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
Check this URL. it has the way to create partition on existing table.


Previous Topic: materialized view refresh causing errors in other queries running simaultaneously
Next Topic: Truncating the content of a file
Goto Forum:

Current Time: Fri Oct 28 17:07:59 CDT 2016

Total time taken to generate the page: 0.26443 seconds