Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00933: SQL command not properly ended - problem

709026Jun 26 2009 — edited Jun 26 2009
I am trying to run the following query

create table SEQUENCE (
Code NUMBER(14,0),
Item NUMBER(2,0),
Location NUMBER(9,0)
)
partition by range (Code)
(partition TESTPART1 values less than ('30517578125')
tablespace TESTPART1_TS)

However I am getting the error ORA-00933: SQL command not properly ended when running this code. This query is part of a larger applicationt that requires a lot more tablespaces when run. However, I am running this query just to test it. I thought the problem may be with only creating one partition. However, after checking this I am led to believe that this is valid. Is this correct?

Any help as to what is causing the error would be much appreciated.

Thanks,
Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2009
Added on Jun 26 2009
6 comments
4,760 views