Home » SQL & PL/SQL » SQL & PL/SQL » Table pratitioning
Table pratitioning [message #189559] Fri, 25 August 2006 01:52 Go to next message
raza_oca
Messages: 10
Registered: August 2005
Location: india
Junior Member
Hi,
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
Maaher
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?

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

http://www.oracle-base.com/articles/8i/PartitionedTablesAndIndexes.php


Thanks,
Thangam
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 Dec 09 19:36:58 CST 2016

Total time taken to generate the page: 0.08863 seconds