Parsing failed with message SyntaxError. Unexpected token 'PARTITION' (Line 35, Col 1) symbol Id
asollber
Posts: 5 New member
I'm trying to create audit tables with a storage clause as well as a partitioning clause. This is what such a table looks like:
The options we're setting (wrapped in another script) are:
Do I have to change the format to get this to work or is there an option I have to set differently?
Thanks for any help with this
Alain
create table MY_SCHEMA.MY_TEST_AUDT ( TEST_ID NUMBER(19), -- all sorts of business fields, omitted for clarity AUDT_CRT_DTM TIMESTAMP DEFAULT SYSTIMESTAMP, AUDT_ACTN_CODE VARCHAR2(1), AUDT_CRT_USR_NM VARCHAR2(128) DEFAULT USER, AUDT_CLIENT_IDENTIFIER VARCHAR2(256), AUDT_CLIENT_INFO VARCHAR2(256) ) TABLESPACE MY_TABLESPACE PCTFREE 0 INITRANS 10 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) COMPRESS FOR OLTP NOCACHE PARTITION BY RANGE (AUDT_CRT_DTM) INTERVAL(interval '1' month) ( PARTITION P0 VALUES LESS THAN (date '2018-11-01') PCTFREE 0 INITRANS 10 ) /<br>The first time I ran it I got this error:
Parsing failed with message SyntaxError. Unexpected token 'K'Pointing to the storage clause. When I got rid of the storage clause (since I can use the defaults) it started complaining about the partitioning clause and that's where I am not very happy with the software.
Parsing failed with message SyntaxError. Unexpected token 'PARTITION' (Line 35, Col 1) symbol Id<br>We're running Schema Compare for Oracle version:4.0.8.420
The options we're setting (wrapped in another script) are:
-behavior=scriptheader -behavior=defineoff -ignore=slowdependencies -ignore=dependentobjects -ignore=whitespace -ignore=casedifferences -ignore=storage -ignore=doublequotes -ignore=sequencevalue -ignore=permissions -ignore=constraintnames -ignore=indexnames -ignore=loggroups /exclude:Additional
Do I have to change the format to get this to work or is there an option I have to set differently?
Thanks for any help with this
Alain