In these cases I always recommend SQL*Developer as it can do SQL syntax and I can't Niall Litchfield On May 5, 2010 6:30 PM, "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx> wrote: Ahhhhh… there **were** the wrong number of parenthesis! Gotham will sleep well tonight! Thank you, Harel! ------------------------------ *From:* Harel Safra [mailto:harel.safra@xxxxxxxxx] *Sent:* Wednesday, May 05, 2010 12:16 PM *To:* Bellows, Bambi (Comsys) *Cc:* oracle-l L *Subject:* Re: Riddle me this, Batman. Why get an ora-922 when creating a partition? You should have opening paranthesis "(" before the partitions and closing parenthesis ")" afte...