How can we help you today? How can we help you today?

Parsing failed with message SyntaxError. Unexpected token 'PARTITION' (Line 35, Col 1) symbol Id

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:

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
)
/
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
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
asollber
0

Add comment

Please sign in to leave a comment.