don't post every simple problem on this board. Pls do some reading on how to create a partition and then start creating a partition. Can you post your sql statement the one you are using to create this partition. That helps me to answer your question. On Thu, Nov 27, 2008 at 10:22 AM, khabeer khayyam <khabeer1983@xxxxxxxxx>wrote: > Hello! > > when i execute the below query to partition a table I get the following > error: > > partition by RANGE (TDATE) > * > ERROR at line 119: > ORA-00907: missing right parenthesis > > Plz help > > Thanks, > > Khayyam > > > ------------------------------ > Add more friends to your messenger and enjoy! Invite them > now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> > >