ORA-00933: SQL command not properly ended - problem
709026Jun 26 2009 — edited Jun 26 2009I 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